Re: help on slow query using postgres 8.4 - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: help on slow query using postgres 8.4
Date
Msg-id 20121120130609.156400@gmx.com
Whole thread Raw
In response to help on slow query using postgres 8.4  ("Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov>)
List pgsql-performance
Maria L. Wilson wrote:

> Can someone shed some light on the following query.....
> any help would certainly be appreciated!

The query text and EXPLAIN ANALYZE output are a good start, but a lot
of other information is needed to really understand the issue.

http://wiki.postgresql.org/wiki/SlowQueryQuestions

The EXPLAIN ANALYZE output will be easier to read as an attachment --
or even better, post it to:

http://explain.depesz.com/

-Kevin


pgsql-performance by date:

Previous
From: Russell Keane
Date:
Subject: FW: slow query on postgres 8.4
Next
From: "Kevin Grittner"
Date:
Subject: Re: PQconnectStart/PQconnectPoll