Re: Get explain output of postgresql in Tables

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, 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: Get explain output of postgresql in Tables
Date: 2006-04-13 00:06:44
Message-ID: 20060413000644.GO49405@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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...
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-04-13 02:31:34 Re: Control File
Previous Message Alvaro Herrera 2006-04-12 23:28:25 Re: Get explain output of postgresql in Tables