Re: Strange workaround for slow query

From: Yeb Havinga <yebhavinga(at)gmail(dot)com>
To: sverhagen(at)wps-nl(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Strange workaround for slow query
Date: 2010-03-10 09:11:05
Message-ID: 4B976229.7030407@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message sverhagen 2010-03-10 09:27:40 Re: Strange workaround for slow query
Previous Message Kees van Dieren 2010-03-10 09:07:41 Strange workaround for slow query