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

Re: Different execution plan

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Different execution plan
Date: 2008-09-24 11:06:42
Message-ID: alpine.DEB.1.10.0809241203370.19066@aragorn.flymine.org (view raw or flat)
Thread:
Lists: pgsql-performance
On Wed, 24 Sep 2008, Sabin Coanda wrote:
> I think it would be nice to log the reasons why an explain analyze chooses a
> specific way or another for an execution plan. This would avoid wasting time
> to find the source of these decisions from the existing logs.

That would probably fill up the logs pretty quickly.

What may be really useful would be some sort of "extended explain" option. 
At the moment, explain prints out the best query plan found. Sometimes it 
would be nice if it printed out all the plans it considered, so we don't 
have to go fiddling with enable_xxx to find alternatives.

Matthew

-- 
I suppose some of you have done a Continuous Maths course. Yes? Continuous
Maths? <menacing stares from audience> Whoah, it was like that, was it!
                                        -- Computer Science Lecturer

In response to

pgsql-performance by date

Next:From: Steve ClarkDate: 2008-09-24 11:11:57
Subject: Re: Intel's X25-M SSD
Previous:From: Artis CauneDate: 2008-09-24 10:52:44
Subject: Re: UFS 2: soft updates vs. gjournal (AKA: Choosing a filesystem 2.)

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