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

Responses

• Re: explain analyze query execution time at 2011-11-22 12:52:33 from Rudyar

pgsql-hackers by date

Next:	From: Dean Rasheed	Date: 2011-11-22 07:49:49
	Subject: Re: Singleton range constructors versus functional coercion notation
Previous:	From: Mark Kirkwood	Date: 2011-11-22 05:06:01
	Subject: Re: Rename a database that has connections