Re: explain analyze query execution time

On 22/11/11 02:58, Kevin Grittner wrote:
> Rudyar 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?
>
> It's the "observer effect" -- there is a cost to the timing,
> counting, measuring, and reporting which is done by EXPLAIN ANALYZE,
> which distorts what is being measured. It's just about impossible to
> avoid entirely.
>
> -Kevin
Thanks kevin,

what tool you recommend for measure the query "real" query execution time?

--
Rudyar Cortés.
Estudiante de Ingeniería Civil Informática
Universidad Técnica Federico Santa María.