Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: SQL select query becomes slow when using limit (with no offset)
- From: PFC <lists(at)peufeu(dot)com>
- To: "Kees van Dieren" <keesvandieren(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
- Subject: Re: SQL select query becomes slow when using limit (with no offset)
- Date: Fri, 31 Jul 2009 14:46:45 +0200
- Message-id: <op.uxxm37opcigqcu@soyouz> <text/plain>
The query: select events_events.id FROM events_events left join events_event_types on events_events.eventType_id= events_event_types.id where events_event_types.severity=70 and events_events.cleared='f' order by events_events.dateTime DESC
The main problem seems to be lack of a suitable index... - Try creating an index on events_events( eventType_id, cleared ) - Or the other way around : events_events( cleared, eventType_id ) (depends on your other queries) Please try both and report EXPLAIN ANALYZE.
- References:
- SQL select query becomes slow when using limit (with no offset)
- From: Kees van Dieren
- SQL select query becomes slow when using limit (with no offset)
- Prev by Date: Re: SQL select query becomes slow when using limit (with no offset)
- Next by Date: Re: load / stress testing
- Previous by thread: Re: SQL select query becomes slow when using limit (with no offset)
- Indexes: