Re: [PERFORM] postgresql Explain command output

2008-03-07 Thread RaviRam Kolipaka
VI.G > > - Original Message - > *From:* RaviRam Kolipaka <[EMAIL PROTECTED]> > *To:* pgsql-performance@postgresql.org > *Sent:* Thursday, March 06, 2008 11:40 AM > *Subject:* [PERFORM] postgresql Explain command output > > > hi, > > is there an

Re: [PERFORM] postgresql Explain command output

2008-03-06 Thread Greg Smith
On Thu, 6 Mar 2008, Tom Lane wrote: Red Hat did a "Visual Explain" tool several years ago, which is unmaintained now but still available for download (http://sources.redhat.com/rhdb/). I've heard that EDB picked it up and is now maintaining their own fork, but I don't know the status of that

Re: [PERFORM] postgresql Explain command output

2008-03-06 Thread Tom Lane
Greg Smith <[EMAIL PROTECTED]> writes: > On Thu, 6 Mar 2008, RaviRam Kolipaka wrote: >> My goal is create a visual representation of the expain plan. > This problem has been solved already by code that's in pgadmin and you > might look at that source code for hints if you want to write your own

Re: [PERFORM] postgresql Explain command output

2008-03-06 Thread Greg Smith
On Thu, 6 Mar 2008, RaviRam Kolipaka wrote: My goal is create a visual representation of the expain plan. This problem has been solved already by code that's in pgadmin and you might look at that source code for hints if you want to write your own implementation. There's a good intro to usi

[PERFORM] postgresql Explain command output

2008-03-05 Thread RaviRam Kolipaka
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 conditio