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.
what tool you recommend for measure the query "real" query execution time?
Estudiante de Ingeniería Civil Informática
Universidad Técnica Federico Santa María.
In response to
pgsql-hackers by date
|Next:||From: Albe Laurenz||Date: 2011-11-22 13:11:32|
|Subject: Review: CHECK FUNCTION statement|
|Previous:||From: Itagaki Takahiro||Date: 2011-11-22 12:22:07|
|Subject: Re: dblink: enable parameters|