Hello,

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?

On 11/21/11, Rudyar <rudyar(dot)cortes(at)gmail(dot)com> wrote:
> Hello,
>
> 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.

Jeff