On 11/21/11, Rudyar <rudyar(dot)cortes(at)gmail(dot)com> wrote:
> I try to get the execution time of a query workload. I try using explain
> analyze but this time is allways higher than
> the execution time of a query across a client like pgadmin3
> what is the reason about that difference?
Analyze has to do a lot of gettimeofday calls and other bookkeeping,
and that takes time. If the data queried is all in memory, this
analyze overhead can be far more than the query itself.
In response to
pgsql-hackers by date
|Next:||From: Mark Kirkwood||Date: 2011-11-22 04:24:24|
|Subject: Re: Rename a database that has connections|
|Previous:||From: Tom Lane||Date: 2011-11-22 04:17:40|
|Subject: Re: strange nbtree corruption report |