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
--------------------------------------------------------------------
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 |