Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3DF6F9FBD4F for ; Wed, 25 Jul 2007 17:58:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 76345-03 for ; Wed, 25 Jul 2007 17:58:24 -0300 (ADT) X-Greylist: delayed 00:08:07.313984 by SQLgrey-1.7.5 Received: from server.firetrust.net (mailserver.firetrust.com [209.213.221.13]) by postgresql.org (Postfix) with ESMTP id 216429FBD69 for ; Wed, 25 Jul 2007 17:58:27 -0300 (ADT) Received: from localhost.localdomain (203-97-61-135.dsl.clear.net.nz [203.97.61.135]) by server.firetrust.net (8.14.1/8.14.1) with SMTP id l6PKoHtx010665 for ; Thu, 26 Jul 2007 08:50:18 +1200 Date: Thu, 26 Jul 2007 08:53:25 +1200 From: Steve Holdoway To: pgsql-admin@postgresql.org Subject: Re: Using Explain Message-Id: <20070726085325.c89a2ec8.steve.holdoway@firetrust.com> In-Reply-To: References: Organization: Firetrust Ltd X-Mailer: Sylpheed version 2.3.0beta5 (GTK+ 2.8.20; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-MailWasher-Server-Scanned: Checked by MailWasher server v2.2.3 (www.Firetrust.com) X-MailWasher-Server-Status: Clean X-Virus-Scanned: ClamAV 0.91.1/3764/Thu Jul 26 07:13:25 2007 on server.firetrust.net X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/287 X-Sequence-Number: 26268 On Wed, 25 Jul 2007 12:38:31 +0000 "Vishal Arora" wrote: >=20 >=20 >=20 > >From: "Milen A. Radev" > >To: pgsql-admin@postgresql.org > >Subject: Re: [ADMIN] Using Explain > >Date: Wed, 25 Jul 2007 14:26:57 +0300 > > > >Vishal Arora =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0: > > > > > > 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 gi= ves > > > some more in depth information about EXPLAIN / Plan Reading > > > > > > >http://www.postgresql.org/communityfiles/13.sxi >=20 > Thanks for the link. I am sorry but I am not able to view this file. > > > > Try saving it and open with OpenOffice...