Re: Wildly erratic query performance

From: Dennis Brakhane <brakhane(at)googlemail(dot)com>
To: Eric Schwarzenbach <subscriber(at)blackbrook(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Wildly erratic query performance
Date: 2008-10-31 22:16:35
Message-ID: 20081031221635.GA4413@thinky
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Oct 31, 2008 at 04:36:02PM -0400, Eric Schwarzenbach wrote:
> As I explained already (no pun intended) running the query using EXPLAIN
> makes the wild variation go away. So I cannot get explain results for a
> fast and for a slow execution.

EXPLAIN only determines and outputs the query plan. It does not actually
run the query.

You probably want to use EXPLAIN ANALYZE

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Mayer 2008-10-31 22:33:39 Re: Are there plans to add data compression feature to postgresql?
Previous Message Bruce Momjian 2008-10-31 22:05:59 Re: Are there plans to add data compression feature to postgresql?