Meaning of "loops" in EXPLAIN ANALYSE output

From: Aaron Bingham <bingham(at)cenix-bioscience(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Meaning of "loops" in EXPLAIN ANALYSE output
Date: 2006-04-10 14:51:19
Message-ID: 443A70E7.20400@cenix-bioscience.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a query optimization problem and I have failed to find the part
of the Postgres docs that explains the meaning of the "loops" value in
the EXPLAIN ANALYSE output.

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? The time for the entire query would
suggest the latter interpretation but I'd like to rule out the
possibility that something else is causing the execution time to balloon.

Thanks,

--
--------------------------------------------------------------------
Aaron Bingham
Senior Software Engineer
Cenix BioScience GmbH
--------------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2006-04-10 15:08:01 Re: Meaning of "loops" in EXPLAIN ANALYSE output
Previous Message Alban Hertroys 2006-04-10 12:25:32 pg_restore 7.4.7 locks itself out