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