Re: Strange workaround for slow query - Mailing list pgsql-performance

From Yeb Havinga
Subject Re: Strange workaround for slow query
Date
Msg-id 4B976229.7030407@gmail.com
Whole thread Raw
In response to Strange workaround for slow query  (sverhagen@wps-nl.com)
Responses Re: Strange workaround for slow query
List pgsql-performance
Hello Sander,

Can you post the explain plan output of these queries?

> SELECT * FROM events_events LEFT OUTER JOIN events_event_types ON
> eventType_id=events_event_types.id WHERE severity=20 AND (eventType_id
> IN (71)) ORDER BY datetime DESC limit 50;
>
> SELECT * FROM events_events LEFT OUTER JOIN events_event_types ON
> eventType_id=events_event_types.id WHERE severity=70 AND (eventType_id
> IN (71, 999)) ORDER BY datetime DESC LIMIT 50;
>
regards
Yeb Havinga

pgsql-performance by date:

Previous
From: Kees van Dieren
Date:
Subject: Strange workaround for slow query
Next
From: sverhagen@wps-nl.com
Date:
Subject: Re: Strange workaround for slow query