Re: postgresql Explain command output

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: RaviRam Kolipaka <raviram(dot)kolipaka(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: postgresql Explain command output
Date: 2008-03-06 13:31:16
Message-ID: 15226.1204810276@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Greg Smith <gsmith(at)gregsmith(dot)com> writes:
> On Thu, 6 Mar 2008, RaviRam Kolipaka wrote:
>> My goal is create a visual representation of the expain plan.

> This problem has been solved already by code that's in pgadmin and you
> might look at that source code for hints if you want to write your own
> implementation.

It's been solved more than once actually --- Red Hat did a "Visual
Explain" tool several years ago, which is unmaintained now but still
available for download (http://sources.redhat.com/rhdb/). I've heard
that EDB picked it up and is now maintaining their own fork, but I
don't know the status of that for sure. That code is in Java, if it
makes a difference to you.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2008-03-06 13:43:43 Re: postgresql Explain command output
Previous Message Greg Smith 2008-03-06 13:27:14 Re: count * performance issue