Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 71DDD2E0194 for ; Fri, 7 Mar 2008 08:59:15 -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 44205-02 for ; Fri, 7 Mar 2008 08:59:12 -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.190]) by postgresql.org (Postfix) with ESMTP id BA7632E018F for ; Fri, 7 Mar 2008 08:59:11 -0400 (AST) Received: by gv-out-0910.google.com with SMTP id y18so366836gvf.7 for ; Fri, 07 Mar 2008 04:59:07 -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:cc:in-reply-to:mime-version:content-type:references; bh=3JuK9u+aWZ51XvIPtQujGtsNpkXj0NQyPwo5KfJN3fo=; b=pIAwUCLaXFXtkmpptjvgtDqXKG81a82XoxJoamo3pS1mFwcwLEMz5ckDgEsOppxI1WQadPnIMviBRhr/J7CKckndYlmmZShTwPW3dPxYJcoIeyfpk4oF5k7M/risqOmdWYGmUWeG1Vc/jSEtq6dojE0mLh96H12GtW2zVx3YwGQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=ht6HfktR1VTS6/cWDtp1FAk674K4//gtVjcdJ6pux1qFkLp9upECud4+fKHXEUNzHdK6mZA9SSOO15u99onDCU+YzOnususYsFEh1lZsdqC7UP96yRYrx/bqcQe8FOWQP0eHyuD3rcZ8AQxTsGLZVj42oGH5zeH3ryr0In4e0gI= Received: by 10.150.227.9 with SMTP id z9mr466889ybg.166.1204894746223; Fri, 07 Mar 2008 04:59:06 -0800 (PST) Received: by 10.150.143.15 with HTTP; Fri, 7 Mar 2008 04:59:06 -0800 (PST) Message-ID: <752107cb0803070459l6affca5duce1dc0a8ce68d9e5@mail.gmail.com> Date: Fri, 7 Mar 2008 18:29:06 +0530 From: "RaviRam Kolipaka" To: Devi Subject: Re: postgresql Explain command output Cc: pgsql-performance@postgresql.org In-Reply-To: <012001c87f56$ef7c39b0$3f0110ac@devco> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_474_8528895.1204894746207" References: <752107cb0803052210i534296e2v5b3fad2c9f46bda1@mail.gmail.com> <012001c87f56$ef7c39b0$3f0110ac@devco> 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/156 X-Sequence-Number: 29110 ------=_Part_474_8528895.1204894746207 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline How do we know in the output of expain command table or constraint names so that while parsing each line of the output we can able to recognise them and build the pictorial representation. for example if you consider the following output EXPLAIN select * from table1,table2 where roll=id_no; QUERY PLAN ---------------------------------------------------------------------- Hash Join (cost=29.12..59.31 rows=850 width=124) Hash Cond: (table2.id_no = table1.roll) -> Seq Scan on table2 (cost=0.00..18.50 rows=850 width=62) -> Hash (cost=18.50..18.50 rows=850 width=62) -> Seq Scan on table1 (cost=0.00..18.50 rows=850 width=62) we can know the table name , just by seeing any string after ON keyword . Like that how to recognise the other constraints and so on. On Thu, Mar 6, 2008 at 12:24 PM, Devi wrote: > Hi, > > I suppose the format depends on the query you serve. The following links > will throw some light. > > http://www.postgresql.org/docs/8.1/static/sql-explain.html > http://www.postgresql.org/docs/7/static/c4888.htm > > Thanks > DEVI.G > > ----- Original Message ----- > *From:* RaviRam Kolipaka > *To:* pgsql-performance@postgresql.org > *Sent:* Thursday, March 06, 2008 11:40 AM > *Subject:* [PERFORM] postgresql Explain command output > > > 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 > > ------------------------------ > > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.516 / Virus Database: 269.21.5/1314 - Release Date: 3/5/2008 > 6:38 PM > > ------=_Part_474_8528895.1204894746207 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline  How do we know in the output of expain command table  or constraint names so that while parsing  each line of the output
 we can able to recognise them and build the pictorial representation. for example if you consider the following output
 
              EXPLAIN select * from table1,table2 where roll=id_no;
                              QUERY PLAN
----------------------------------------------------------------------
 Hash Join  (cost=29.12..59.31 rows=850 width=124)
   Hash Cond: (table2.id_no = table1.roll)
   ->  Seq Scan on table2  (cost=0.00..18.50 rows=850 width=62)
   ->  Hash  (cost=18.50..18.50 rows=850 width=62)
         ->  Seq Scan on table1  (cost=0.00..18.50 rows=850 width=62)
 
       we can know the table name , just by seeing any string after ON keyword . Like that how to recognise the other constraints and so on.

On Thu, Mar 6, 2008 at 12:24 PM, Devi <devi@visolve.com> wrote:
Hi,
 
I suppose the format depends on the query you serve.  The following links will throw some light.
 
 
Thanks
DEVI.G
----- Original Message -----
Sent: Thursday, March 06, 2008 11:40 AM
Subject: [PERFORM] postgresql Explain command output


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   

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.21.5/1314 - Release Date: 3/5/2008 6:38 PM

------=_Part_474_8528895.1204894746207--