Postgres Pro
Downloads
Home   >   mailing lists

Re: Bad Plan for Questionnaire-Type Query - Mailing list pgsql-performance

From David Blewett
Subject Re: Bad Plan for Questionnaire-Type Query
Date
Msg-id 9d1f8d830905071556q1ecbb496m98d3509a80429b5@mail.gmail.com
Whole thread Raw
In response to Re: Bad Plan for Questionnaire-Type Query  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Bad Plan for Questionnaire-Type Query
List pgsql-performance
Tree view 
On Thu, May 7, 2009 at 6:44 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Look into pg_stats for the rows concerning the columns used in the
> query's WHERE and JOIN/ON clauses.

Okay, here you go:
http://rafb.net/p/20y8Oh72.html

David

pgsql-performance by date:

Previous
From: Viktor Rosenfeld
Date:
Subject: Indexes not used in DELETE
Next
From: Tom Lane
Date:
Subject: Re: Indexes not used in DELETE