Re: Get explain output of postgresql in Tables

> -----Original Message-----
> From: Jim C. Nasby [mailto:jnasby(at)pervasive(dot)com]
> Sent: 13 April 2006 01:07
> To: Dave Page; tgl(at)sss(dot)pgh(dot)pa(dot)us; gpoo(at)ubiobio(dot)cl;
> mischa(at)ActiveState(dot)com; pgsql-hackers(at)postgresql(dot)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(at)commandprompt(dot)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.