Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 9B307B5DFDB for ; Wed, 8 Jun 2011 08:08:18 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 16610-03 for ; Wed, 8 Jun 2011 11:08:11 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from elizabeth.gransy.com (elizabeth.gransy.com [89.187.132.199]) by mail.postgresql.org (Postfix) with ESMTP id 793A7B5DEE3 for ; Wed, 8 Jun 2011 08:08:11 -0300 (ADT) Received: from sq.gransy.com (localhost [127.0.0.1]) by elizabeth.gransy.com (Postfix) with ESMTP id 2BB4815E40BD; Wed, 8 Jun 2011 13:08:10 +0200 (CEST) Received: from 85.160.195.232 (SquirrelMail authenticated user tv@fuzzy.cz) by sq.gransy.com with HTTP; Wed, 8 Jun 2011 13:08:10 +0200 Message-ID: In-Reply-To: <4DEF3EEE.1080203@postnewspapers.com.au> References: <4DEF3EEE.1080203@postnewspapers.com.au> Date: Wed, 8 Jun 2011 13:08:10 +0200 Subject: Re: Set of related slow queries From: tv@fuzzy.cz To: "Craig Ringer" Cc: "John Williams" , pgsql-performance@postgresql.org User-Agent: SquirrelMail/1.4.21 MIME-Version: 1.0 Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201106/63 X-Sequence-Number: 43996 > Thanks for including explain analyze output. > > Is there any chance you can pop the full explains (not just excerpts) in > here: > > http://explain.depesz.com/ > > ? I believe he already did that - there's a link below each query. Tomas