Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id A9E412E0201 for ; Thu, 6 Mar 2008 09:43:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 16333-05 for ; Thu, 6 Mar 2008 09:43:37 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from westnet.com (westnet.com [216.187.52.2]) by postgresql.org (Postfix) with ESMTP id 6F88C2E0205 for ; Thu, 6 Mar 2008 09:43:45 -0400 (AST) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id m26DhhMS021467; Thu, 6 Mar 2008 08:43:43 -0500 (EST) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id m26DhhW1021463; Thu, 6 Mar 2008 08:43:43 -0500 (EST) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Thu, 6 Mar 2008 08:43:43 -0500 (EST) From: Greg Smith X-X-Sender: gsmith@westnet.com cc: RaviRam Kolipaka , pgsql-performance@postgresql.org Subject: Re: postgresql Explain command output In-Reply-To: <15226.1204810276@sss.pgh.pa.us> Message-ID: References: <752107cb0803052210i534296e2v5b3fad2c9f46bda1@mail.gmail.com> <15226.1204810276@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.15 tagged_above=0 required=5 tests=AWL=-1.431, MISSING_HEADERS=1.581 X-Spam-Level: X-Archive-Number: 200803/121 X-Sequence-Number: 29075 On Thu, 6 Mar 2008, Tom Lane wrote: > 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. I know I wrote this down somewhere...ah ha, it was in the MySQL comparision paper: Visual Explain, originally a RedHat component that has been kept current and improved by Enterprise DB, comes bundled with the EnterpriseDB Advanced Server package. It can be built to run against other PostgreSQL installations using the source code to their Developer Studio package: http://www.enterprisedb.com/products/download.do -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD