It's actually just `text`. I updated my SO question with some more info including explain analyze (no difference), \d, and your last incantation. Thanks! On Fri, Apr 12, 2013 at 7:11 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Yang Zhang <yanghatespam@xxxxxxxxx> writes: >> 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) >> (2 rows) > > That's awfully odd. What data type is the "email" column? > > It seems possible also that the index on it is marked invalid. I'd have > expected \d to tell you so, but maybe you're using a version of psql that > doesn't know about that. It'd be interesting to look at > select * from pg_index where indexrelid = 'index name here'::regclass; > > > regards, tom lane -- Yang Zhang http://yz.mit.edu/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
