Postgres Pro
Downloads
Home   >   mailing lists

Re: Why is PostgreSQL 9.1 not using index for simple equality select - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Why is PostgreSQL 9.1 not using index for simple equality select
Date
Msg-id CAF-3MvMR04yV6HW7TB1Edffvx3h3__P7SqYW+Q7jQ_2zKE5JRg@mail.gmail.com
Whole thread Raw
In response to Re: Why is PostgreSQL 9.1 not using index for simple equality select  (Yang Zhang <yanghatespam@gmail.com>)
List pgsql-general
Tree view
On 12 April 2013 10:45, Yang Zhang <yanghatespam@gmail.com> wrote:
explain select * from lead where email = 'foo@blah.com';

What about:
explain analyze select * from lead where email = 'foo@blah.com';


--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.

pgsql-general by date:

Previous
From: stephane.schildknecht@postgres.fr
Date:
Subject: Automatic restart while upgrade
Next
From: Condor
Date:
Subject: Re: How to convert US date format to European date format?