Re: Slow query

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)org>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Slow query
Date: 2003-03-24 19:03:42
Message-ID: 20030324110115.A25958-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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).

In response to

  • Slow query at 2003-03-24 17:48:52 from Oleg Lebedev

Browse pgsql-performance by date

  From Date Subject
Next Message Oleg Lebedev 2003-03-24 19:20:13 Re: Slow query
Previous Message Oleg Lebedev 2003-03-24 19:02:51 Re: Slow query