We faced the same problem and added a series of indexes on the events table. CREATE INDEX idx_event_entity_user_id_realm_id_dnsbelgium ON event_entity USING btree (user_id, realm_id); CREATE INDEX idx_event_entity_user_id_type_dnsbelgium ON event_entity USING btree (user_id, type); CREATE INDEX idx_event_entity_type_dnsbelgium ON event_entity USING btree (type); CREATE INDEX idx_event_entity_realm_id_dnsbelgium ON event_entity USING btree (realm_id); CREATE INDEX idx_event_entity_client_id_dnsbelgium ON event_entity USING btree (client_id); CREATE INDEX idx_event_entity_user_id_dnsbelgium ON event_entity USING btree (user_id); and now queries are working fast Johan On 4 July 2017 at 08:41, Sarp Kaya <akaya(a)expedia.com&gt; wrote: