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

From Richard Huxton
Subject Re: Meaning of "loops" in EXPLAIN ANALYSE output
Date
Msg-id 443A74D1.9030806@archonet.com
Whole thread Raw
In response to Meaning of "loops" in EXPLAIN ANALYSE output  (Aaron Bingham <bingham@cenix-bioscience.com>)
Responses Re: Meaning of "loops" in EXPLAIN ANALYSE output
List pgsql-general
Aaron Bingham wrote:
> 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?  The time for the entire query would
> suggest the latter interpretation

You're quite right - multiply the time by the number of loop iterations
to find the total.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Aaron Bingham
Date:
Subject: Meaning of "loops" in EXPLAIN ANALYSE output
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Meaning of "loops" in EXPLAIN ANALYSE output