Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0D8572E017C for ; Thu, 6 Mar 2008 09:10:17 -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 04844-10 for ; Thu, 6 Mar 2008 09:10:01 -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 5EFE72E010E for ; Thu, 6 Mar 2008 09:10:05 -0400 (AST) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id m26DA35j014979; Thu, 6 Mar 2008 08:10:03 -0500 (EST) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id m26DA2fc014975; Thu, 6 Mar 2008 08:10:02 -0500 (EST) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Thu, 6 Mar 2008 08:10:02 -0500 (EST) From: Greg Smith X-X-Sender: gsmith@westnet.com To: RaviRam Kolipaka cc: pgsql-performance@postgresql.org Subject: Re: postgresql Explain command output In-Reply-To: <752107cb0803052210i534296e2v5b3fad2c9f46bda1@mail.gmail.com> Message-ID: References: <752107cb0803052210i534296e2v5b3fad2c9f46bda1@mail.gmail.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/116 X-Sequence-Number: 29070 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. There's a good intro to using that at http://www.postgresonline.com/journal/index.php?/archives/27-Reading-PgAdmin-Graphical-Explain-Plans.html -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD