On Tue, Sep 24, 2013 at 6:24 AM, Sam Wong <sam@xxxxxxxxxxxx> wrote: > This event_log table has 4 million rows. > > “log_id” is the primary key (bigint), > > there is a composite index “event_data_search” over (event::text, > insert_time::datetime). I think you need to add log_id to that composite index to get pg to use it. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance