Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 0DBA02E02A1
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu,  6 Mar 2008 02:10:14 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 03852-04 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu,  6 Mar 2008 02:10:08 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from gv-out-0910.google.com (gv-out-0910.google.com
 [216.239.58.191])
	by postgresql.org (Postfix) with ESMTP id 3C5212E02D1
	for <pgsql-performance@postgresql.org>;
	Thu,  6 Mar 2008 02:10:06 -0400 (AST)
Received: by gv-out-0910.google.com with SMTP id y18so1678197gvf.7
	for <pgsql-performance@postgresql.org>;
	Wed, 05 Mar 2008 22:10:06 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
	bh=naYvoUeBU06D2hg0gVy30SISlAfiBCPNaZ9wZpgFsro=;
	b=hc1gi6DusYUexyffo+iUKHwgpFz5WU7DorqNrtp5/p/bSPCPP69jmblXkDnXhbXM4eFadywfaNZh/lMeMNCkq1Cp0QMWxcdio7lMeXrpK906FdSegC9p2myyYZOSeqEdCbUzjyEH9TOoecJ2BvHvqsAgmPWkE/pnsTkiOJozhVs=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=a3MEy4h8W3Km2wqzvtOsQZZ0msLSu44ERgtqBYdsLm5MbaCsB6dVyryinm3Ht9loH6rut8h5zUM0l0jqcYUFRkAEBAkdE0SlSbECDkSY2gZqaI4CaJoJHDkJ1ee8wx/AA43em8hVQ0HsRU+hACOgY0NepE1wpGf9kfziD6EnB3U=
Received: by 10.150.124.2 with SMTP id w2mr1730520ybc.2.1204783805150;
	Wed, 05 Mar 2008 22:10:05 -0800 (PST)
Received: by 10.150.143.15 with HTTP; Wed, 5 Mar 2008 22:10:05 -0800 (PST)
Message-ID: <752107cb0803052210i534296e2v5b3fad2c9f46bda1@mail.gmail.com>
Date: Thu, 6 Mar 2008 11:40:05 +0530
From: "RaviRam Kolipaka" <raviram.kolipaka@gmail.com>
To: pgsql-performance@postgresql.org
Subject: postgresql Explain command output
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_40754_13414381.1204783805174"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200803/91
X-Sequence-Number: 29045

------=_Part_40754_13414381.1204783805174
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

hi,

     is there any generalized format for the output for the output of the
explain command ?. If so please send that generalized format to me.
otherwise tell me how to parse the output of explain command to
know where the relation name occurs,where the conditions occurs,
where the join conditions occur and so on. My  goal is create a visual
representation of the expain plan. Can some body help me in this regard.
         Thanks & regards
       RAVIRAM KOLIPAKA
      M.TECH(CSE)-final year
      IIIT Hyderabad

------=_Part_40754_13414381.1204783805174
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<br>hi,<br>&nbsp;<br>&nbsp; &nbsp;&nbsp; is there any generalized format for the output for the output of the explain command ?. If so please send that generalized format to me.<br>otherwise tell me how to parse the output of explain command to <br>
know where the relation name occurs,where the conditions occurs,<br>where the join conditions occur and so on. My&nbsp; goal is create a visual <br>representation of the expain plan. Can some body help me in this regard.<br>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Thanks &amp; regards<br>
&nbsp; &nbsp; &nbsp;&nbsp; RAVIRAM KOLIPAKA<br>&nbsp; &nbsp; &nbsp; M.TECH(CSE)-final year<br>&nbsp; &nbsp; &nbsp; IIIT Hyderabad&nbsp; &nbsp;  <br>

------=_Part_40754_13414381.1204783805174--