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