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
