Re: about explain analyze - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: about explain analyze
Date
Msg-id 3FC78E72.1030609@sigaev.ru
Whole thread Raw
In response to Re: about explain analyze  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: about explain analyze  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Functions with COPY
Next
From: Tom Lane
Date:
Subject: Re: about explain analyze