Skip site navigation (1) Skip section navigation (2)

Re: explain analyze query execution time

From: Rudyar <rudyar(dot)cortes(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: explain analyze query execution time
Date: 2011-11-22 12:52:33
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
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.

In response to

pgsql-hackers by date

Next:From: Albe LaurenzDate: 2011-11-22 13:11:32
Subject: Review: CHECK FUNCTION statement
Previous:From: Itagaki TakahiroDate: 2011-11-22 12:22:07
Subject: Re: dblink: enable parameters

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group