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

Re: query execution time

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Julius T" <julius(at)nsoft(dot)lt>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: query execution time
Date: 2010-10-05 21:30:24
Message-ID: 4CAB52A0020000250003657E@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
Julius T <julius(at)nsoft(dot)lt> wrote:
 
> The question is why the difference of value provided by EXPLAIN
> ANALYZE and observed one is so big?
 
There can be a number of reasons.  The time to transmit the query
results to the client is one that jumps to mind, if the query
generates a large result set.  Parts of what you described might
suggest checkpoint issues, depending on the query mix, the
PostgreSQL version, the hardware and the OS.  You haven't given us
enough information to even start to guess which of these or other
issues might be involved.
 
Please read this page, and repost with more information:
 
http://wiki.postgresql.org/wiki/SlowQueryQuestions
 
-Kevin

In response to

Responses

pgsql-admin by date

Next:From: Lukasz BrodziakDate: 2010-10-05 21:39:36
Subject: Re: query execution time
Previous:From: Craig JamesDate: 2010-10-05 20:50:35
Subject: Re: restore

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