Re: Slow query - Mailing list pgsql-performance

From Stephan Szabo
Subject Re: Slow query
Date
Msg-id 20030324110115.A25958-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Slow query  (Oleg Lebedev <oleg.lebedev@waterford.org>)
List pgsql-performance
On Mon, 24 Mar 2003, Oleg Lebedev wrote:

> Please help me speed up the following query. It used to run in 2-5 sec.,
> but now it takes 2-3 mins!

EXPLAIN ANALYZE output would be useful to see where the time is actually
taking place (rather than an estimate thereof).


pgsql-performance by date:

Previous
From: Oleg Lebedev
Date:
Subject: Re: Slow query
Next
From: Oleg Lebedev
Date:
Subject: Re: Slow query