Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id DC5B59FB964 for ; Wed, 25 Jul 2007 06:01:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 75491-01 for ; Wed, 25 Jul 2007 06:01:04 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from bay0-omc3-s31.bay0.hotmail.com (bay0-omc3-s31.bay0.hotmail.com [65.54.246.231]) by postgresql.org (Postfix) with ESMTP id A293E9FB5CD for ; Wed, 25 Jul 2007 06:01:04 -0300 (ADT) Received: from hotmail.com ([207.46.11.107]) by bay0-omc3-s31.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Wed, 25 Jul 2007 02:01:02 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 25 Jul 2007 02:01:03 -0700 Message-ID: Received: from 207.46.11.123 by by123fd.bay123.hotmail.msn.com with HTTP; Wed, 25 Jul 2007 09:00:57 GMT X-Originating-IP: [59.160.193.34] X-Originating-Email: [aroravishal22@hotmail.com] X-Sender: aroravishal22@hotmail.com In-Reply-To: From: "Vishal Arora" To: pgsql-admin@postgresql.org Subject: Using Explain Date: Wed, 25 Jul 2007 09:00:57 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 25 Jul 2007 09:01:03.0052 (UTC) FILETIME=[53DB60C0:01C7CE9A] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/273 X-Sequence-Number: 26254 Hi All, I was looking for extensive tutorial for Explain, Plan-reading. The postgres manual is not exhaustive enough. It would be great if somone has a link to some documentation which gives some more in depth information about EXPLAIN / Plan Reading Thanks Vishal _________________________________________________________________ Don't get caught with egg on your face. Play Chicktionary!  http://club.live.com/chicktionary.aspx?icid=chick_hotmailtextlink2