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