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@sss.pgh.pa.us> wrote:
> Yang Zhang <yanghatespam@gmail.com> 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/