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

Re: explain analyze query execution time

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Rudyar <rudyar(dot)cortes(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: explain analyze query execution time
Date: 2011-11-22 04:20:18
Message-ID: CAMkU=1wFOAL726P9e18i1pZePu1QE++JfdFGSD1p2_e8eEAfHw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On 11/21/11, Rudyar <rudyar(dot)cortes(at)gmail(dot)com> wrote:
> Hello,
>
> 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?

Analyze has to do a lot of gettimeofday calls and other bookkeeping,
and that takes time.  If the data queried is all in memory, this
analyze overhead can be far more than the query itself.

Jeff

In response to

pgsql-hackers by date

Next:From: Mark KirkwoodDate: 2011-11-22 04:24:24
Subject: Re: Rename a database that has connections
Previous:From: Tom LaneDate: 2011-11-22 04:17:40
Subject: Re: strange nbtree corruption report

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