Re: Why is PostgreSQL 9.1 not using index for simple equality select

John R Pierce <pierce@xxxxxxxxxxxx> · Fri, 12 Apr 2013 01:13:59 -0700

On 4/12/2013 1:03 AM, Yang Zhang wrote:
     db=> explain select * from lead where email = 'blah';
                              QUERY PLAN
     ------------------------------------------------------------
      Seq Scan on lead  (cost=0.00..319599.38 rows=1 width=5108)
        Filter: (email = 'blah'::text)

try EXPLAIN ANALYZE .....    its more useful.

my guess is, there's no statistics on this table, and doing an ANALYZE 
lead;  would rectify this.

--
john r pierce                                      37N 122W
somewhere on the middle of the left coast

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general