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