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: 4ECAE5C2020000250004336D@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

-Kevin

Responses

Browse pgsql-hackers by date

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