Re: Get explain output of postgresql in Tables

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <alvherre(at)commandprompt(dot)com>
Cc: <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-12 22:09:47
Message-ID: 021501c65e7d$d0a02588$6a01a8c0@valehousing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

-----Original Message-----
From: "Tom Lane"<tgl(at)sss(dot)pgh(dot)pa(dot)us>
Sent: 12/04/06 23:03:08
To: "Alvaro Herrera"<alvherre(at)commandprompt(dot)com>
Cc: "Germán Poó Caamaño"<gpoo(at)ubiobio(dot)cl>, "Jim C. Nasby"<jnasby(at)pervasive(dot)com>, "mischa(at)ActiveState(dot)com"<mischa(at)ActiveState(dot)com>, "pgsql-hackers(at)postgresql(dot)org"<pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] Get explain output of postgresql in Tables

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

/D

-----Unmodified Original Message-----
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
I don't see a prebuilt package on that page, but I believe the sources
are still available here:
http://sources.redhat.com/rhdb/cvs.html

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2006-04-12 22:34:05 Re: Get explain output of postgresql in Tables
Previous Message Tom Lane 2006-04-12 22:01:51 Re: Get explain output of postgresql in Tables