Drew Wilson wrote:
> Merge Join (cost=524224.49..732216.29 rows=92447 width=97) (actual
> time=1088.871..1351.840 rows=170759 loops=1)
> ...
> Total runtime: 1366.757 ms
It looks like the query actual runs in less than 3 seconds, but it takes
some time to fetch 170759 rows to the client.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com