Re: Slow response in select

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk>
Cc: postgres list <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Slow response in select
Date: 2010-09-21 14:11:09
Message-ID: 4C98BCFD.10202@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 09/21/2010 08:25 PM, Gary Stainburn wrote:
> Hi folks,I have a view that seems to be very slow compared to similar views on
> the same server.
>
> I've had a look at running explain but I don't really understand it.
>
> I've posted the view and the output from explain at
>
> http://www1.ringways.co.uk/explain.txt

Woah. That's an interesting plan.

When concerned about execution time, it's probably best to post EXPLAIN
ANALYZE rather than plain EXPLAIN results. EXPLAIN ANALYZE provides more
timing information and information about how rowcount estimates differed
from reality.

--
Craig Ringer

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gary Stainburn 2010-09-21 14:20:15 Re: Slow response in select
Previous Message Gary Stainburn 2010-09-21 12:25:55 Slow response in select