Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TanWo-0003J1-3P for pgsql-performance@postgresql.org; Tue, 20 Nov 2012 13:06:14 +0000 Received: from mailout-us.gmx.com ([74.208.5.67] helo=mailout-us.mail.com) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TanWm-0004MK-Cn for pgsql-performance@postgresql.org; Tue, 20 Nov 2012 13:06:13 +0000 Received: (qmail 2911 invoked by uid 0); 20 Nov 2012 13:06:11 -0000 Received: from 76.255.19.161 by rms-us016 with HTTP Content-Type: text/plain; charset="utf-8" Date: Tue, 20 Nov 2012 08:06:09 -0500 From: "Kevin Grittner" Message-ID: <20121120130609.156400@gmx.com> MIME-Version: 1.0 Subject: Re: help on slow query using postgres 8.4 To: Maria.L.Wilson-1@nasa.gov,pgsql-performance@postgresql.org X-Authenticated: #138763884 X-Flags: 0001 X-Mailer: GMX.com Web Mailer x-registered: 0 Content-Transfer-Encoding: 8bit X-GMX-UID: FuXZcHxc3zOlOQ09LnwhsQN+IGRvb0Ah X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201211/203 X-Sequence-Number: 48569 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