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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
