Postgres Pro
Downloads
Home   >   mailing lists

Re: about explain analyze - Mailing list pgsql-hackers

From Tom Lane
Subject Re: about explain analyze
Date
Msg-id 28634.1070038097@sss.pgh.pa.us
Whole thread Raw
In response to about explain analyze  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: about explain analyze  ("Marc G. Fournier" <scrappy@postgresql.org>)
Re: about explain analyze  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-hackers
Tree view 
Teodor Sigaev <teodor@sigaev.ru> writes:
> Explain analyze takes 3 times more time for execution. Why?

Measurement overhead.  It would seem your platform has a particularly
slow version of gettimeofday() though ... I've never noticed such a
large discrepancy myself.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: timestamp convert function
Next
From: Tom Lane
Date:
Subject: Re: Functions with COPY