Re: Get explain output of postgresql in Tables

> -----Original Message-----
> From: Jim C. Nasby [mailto:jnasby@pervasive.com]
> Sent: 13 April 2006 01:07
> To: Dave Page; tgl@sss.pgh.pa.us; gpoo@ubiobio.cl;
> mischa@ActiveState.com; pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] Get explain output of postgresql in Tables
>
> On Wed, Apr 12, 2006 at 07:28:25PM -0400, Alvaro Herrera wrote:
> > Dave Page escribi?:
> >
> > > > Alvaro Herrera <alvherre@commandprompt.com> writes:
> > > > > It would be nice to see the "visual explain" tool that Denis
> > > > > wrote -- did he finish it?  Is it available
> somewhere?  Are there any screenshots?
> > >
> > > > Red Hat did one of these some years ago:
> > > > http://sources.redhat.com/rhdb/visualexplain.html
> > > pgAdmin also has visual explain capabilities.
> >
> > How does it work?  Does it parse the text representation?
> >
> > I found a screenshot here:
> > http://www.pgadmin.org/images/screenshots/pgadmin3_explain.png
> >
> > Seems nice (but lacking the attributes for each node ...)
>
> To get the details you hover over each box. It would be nice
> if you could have it show that info on the main screen though...

It rapidly fills the canvas and becomes difficult to read - there's
quite a bit of text to show.

Regards, Dave.