Re: Meaning of "loops" in EXPLAIN ANALYSE output - Mailing list pgsql-general

From Tom Lane
Subject Re: Meaning of "loops" in EXPLAIN ANALYSE output
Date
Msg-id 26412.1144684087@sss.pgh.pa.us
Whole thread Raw
In response to Meaning of "loops" in EXPLAIN ANALYSE output  (Aaron Bingham <bingham@cenix-bioscience.com>)
List pgsql-general
Aaron Bingham <bingham@cenix-bioscience.com> writes:
> For example, my EXPLAIN ANALYSE output contains the following line:

> Unique  (cost=9775.21..10015.32 rows=1 width=8) (actual
> time=264.889..264.889 rows=1 loops=791)

> Does that mean that the entire operation took 264.889 ms, or that a
> single iteration took that long?

That's the average time per full execution cycle of the node, ie, we
actually spent 264.889 * 791 msec here or in its subnodes.  Presumably
this node is in a subquery, or on the inside of a nestloop, or something
else that would demand its output more than once.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_restore 7.4.7 locks itself out
Next
From: Alban Hertroys
Date:
Subject: Re: pg_restore 7.4.7 locks itself out