Re: Wildly erratic query performance - Mailing list pgsql-general

From Dennis Brakhane
Subject Re: Wildly erratic query performance
Date
Msg-id 20081031221635.GA4413@thinky
Whole thread Raw
In response to Re: Wildly erratic query performance  (Eric Schwarzenbach <subscriber@blackbrook.org>)
List 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


Attachment

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Are there plans to add data compression feature to postgresql?
Next
From: Ron Mayer
Date:
Subject: Re: Are there plans to add data compression feature to postgresql?