Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time - Mailing list pgsql-admin

From Tom Lane
Subject Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time
Date
Msg-id 18991.1294762751@sss.pgh.pa.us
Whole thread Raw
In response to Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-admin
Tree view 
Achilleas Mantzios <achill@matrix.gatewaynet.com> writes:
> I have noticed that in 9.0.2 EXPLAIN ANALYZE takes considerably longer time to return than the actual query. I never
noticedthis in 8.3. 

Same hardware?  What it sounds like is you're running 9.0 on a machine
with slow gettimeofday().

            regards, tom lane

pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time
Next
From: "Daniel J. Summers"
Date:
Subject: Re: problem about postgresql installation and user login