Re: [PERFORM] postgresql Explain command output

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

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, 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