Re: Get explain output of postgresql in Tables

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Cc: <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <gpoo(at)ubiobio(dot)cl>, <jnasby(at)pervasive(dot)com>, <mischa(at)ActiveState(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Get explain output of postgresql in Tables
Date: 2006-04-13 07:23:47
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E4011C9C71@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> -----Original Message-----
> From: Alvaro Herrera [mailto:alvherre(at)commandprompt(dot)com]
> Sent: 13 April 2006 00:28
> To: Dave Page
> Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us; gpoo(at)ubiobio(dot)cl; jnasby(at)pervasive(dot)com;
> mischa(at)ActiveState(dot)com; pgsql-hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] Get explain output of postgresql in Tables
>
> 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?

Yes.

> I found a screenshot here:
> http://www.pgadmin.org/images/screenshots/pgadmin3_explain.png
>
> Seems nice (but lacking the attributes for each node ...)

They're there - dangle your mouse over a node (or left click it) and they popup.

Regards, Dave.

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2006-04-13 07:27:04 Re: Get explain output of postgresql in Tables
Previous Message Martijn van Oosterhout 2006-04-13 06:57:34 Re: Practical impediment to supporting multiple SSL libraries