From: RaviRam Kolipaka <raviram.kolipaka@gmail.com>
To: Devi <devi@visolve.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: postgresql Explain command output
Date: Fri, 7 Mar 2008 18:29:06 +0530
Message-ID: <752107cb0803070459l6affca5duce1dc0a8ce68d9e5@mail.gmail.com> (raw)
In-Reply-To: <012001c87f56$ef7c39b0$3f0110ac@devco>
References: <752107cb0803052210i534296e2v5b3fad2c9f46bda1@mail.gmail.com>
<012001c87f56$ef7c39b0$3f0110ac@devco>
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.
>
> 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 <raviram.kolipaka@gmail.com>
> *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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: raviram.kolipaka@gmail.com, devi@visolve.com
Subject: Re: postgresql Explain command output
In-Reply-To: <752107cb0803070459l6affca5duce1dc0a8ce68d9e5@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox