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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
