irclogbot=# explain select * from messages where created_at < '3-16-2007'; QUERY PLAN ----------------------------------------------------------------------------- Seq Scan on messages (cost=0.00..65981.94 rows=1435549 width=205) Filter: (created_at < '2007-03-16 00:00:00'::timestamp without time zone) (2 rows)