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

Re: explain analyze query execution time

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


pgsql-hackers by date

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

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