Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4880E2E2F7D for ; Thu, 6 Mar 2008 09:31:35 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 22303-01 for ; Thu, 6 Mar 2008 09:31:25 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id DAC912E003D for ; Thu, 6 Mar 2008 09:31:25 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m26DVHHv015227; Thu, 6 Mar 2008 08:31:17 -0500 (EST) To: Greg Smith cc: RaviRam Kolipaka , pgsql-performance@postgresql.org Subject: Re: postgresql Explain command output In-reply-to: References: <752107cb0803052210i534296e2v5b3fad2c9f46bda1@mail.gmail.com> Comments: In-reply-to Greg Smith message dated "Thu, 06 Mar 2008 08:10:02 -0500" Date: Thu, 06 Mar 2008 08:31:16 -0500 Message-ID: <15226.1204810276@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/120 X-Sequence-Number: 29074 Greg Smith 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