irclogbot=# \d messages
                                     Table "public.messages"
   Column   |            Type             |                       Modifiers                       
------------+-----------------------------+-------------------------------------------------------
 id         | integer                     | not null default nextval('messages_id_seq'::regclass)
 body       | text                        | 
 channel    | integer                     | not null
 ircuser    | integer                     | not null
 created_at | timestamp without time zone | 
 vectors    | tsvector                    | 
Indexes:
    "messages_pkey" PRIMARY KEY, btree (id)
    "body_index" gist (vectors)
    "createdidx" btree (created_at)
Foreign-key constraints:
    "messages_channel_fkey" FOREIGN KEY (channel) REFERENCES channels(id) ON UPDATE CASCADE ON DELETE CASCADE
    "messages_ircuser_fkey" FOREIGN KEY (ircuser) REFERENCES users(id) ON UPDATE CASCADE ON DELETE CASCADE
Triggers:
    update_now AFTER INSERT ON messages FOR EACH ROW EXECUTE PROCEDURE update_now()
    update_user_count AFTER INSERT ON messages FOR EACH ROW EXECUTE PROCEDURE update_user_now()
    vectorize BEFORE INSERT OR DELETE OR UPDATE ON messages FOR EACH ROW EXECUTE PROCEDURE tsearch2('vectors', 'body')


irclogbot=# explain select * from messages where created_at < '3-16-2007';