> as you see, explain analyze says it will execute in 175.952ms and
> because of network transfer of data executing this from pgadmin in
> another machine it runs for 17s... but from time to time pgFouine is
> shown upto 345.11 sec
Well, 86000 rows is not enough to give PostgreSQL a headache, even on
mediocre hardware. So I think that most likely culprit is the
application that is reading the data - pgadmin or pgFouine.
...Robert