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

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