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';