Re: about explain analyze

How many times is gettimeofday called?
wow=# explain analyze select 1;                                     QUERY PLAN 

------------------------------------------------------------------------------------ Result  (cost=0.00..0.01 rows=1
width=0)(actual time=0.008..0.010 rows=1 loops=1) Total runtime: 0.047 ms
 
(2 rows)

Several thousands?

Tom Lane wrote:
> 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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

-- 
Teodor Sigaev                                  E-mail: teodor@sigaev.ru