X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1123ED1B267 for ; Thu, 17 Jun 2004 08:10:10 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20208-05 for ; Thu, 17 Jun 2004 11:10:08 +0000 (GMT) Received: from mailhub2.sghms.ac.uk (firewall.sghms.ac.uk [194.82.50.2]) by svr1.postgresql.org (Postfix) with ESMTP id AE781D1B1BE for ; Thu, 17 Jun 2004 08:10:03 -0300 (ADT) Received: from [194.82.51.24] (helo=imail) by mailhub2.sghms.ac.uk with esmtp (Exim 4.24) id 1BaumP-0004N0-OS; Thu, 17 Jun 2004 12:10:01 +0100 Received: from [172.16.20.3] (mrc1-003.sghms.ac.uk [172.16.20.3]) by imail.sghms.ac.uk (iPlanet Messaging Server 5.2 Patch 1 (built Aug 19 2002)) with ESMTPA id <0HZG00JEA9OPBA@imail.sghms.ac.uk>; Thu, 17 Jun 2004 12:10:01 +0100 (BST) Date: Thu, 17 Jun 2004 12:10:30 +0100 From: Adam Witney Subject: Re: Visual Explain In-reply-to: To: Jeff , pgsql-performance Message-id: MIME-version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT User-Agent: Microsoft-Entourage/10.1.1.2418 X-MailScanner-Information: Please contact sysadmin at sghms.ac.uk for more information X-MailScanner-MH2: No Virues detected X-MailScanner-SpamCheck: not spam, SpamAssassin (score=-1.9, required 5, APARENTLY_FROM_MYSELF 1.00, BAYES_00 -4.90, FROM_SGHMS -1.00, MY_OBFUJ 0.50, MY_OBFUT 0.50, MY_OBFUX 0.50, MY_OBFUY 1.00, MY_OBFU_MISC 0.50) X-MailScanner-From: awitney@sghms.ac.uk X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/167 X-Sequence-Number: 7225 Will this run on other platforms? OSX maybe? > I've known about this tool for a while, but it seems many people do not > know of its existence and I think it would be useful to a lot of people > who have a hard time reading explain analyze output. (And even those > who can read them without blinking.. when you get deep in join hell it > gets tricky!) > > Red Hat Visual Explain - part of Red Hat Database. > > It is what the name implies - a graphical (java) program to draw a > picture of your query plan (along with all the juicy information > explain analyze provides). I just tried it out today and after > upgrading my JDBC to 7.4 it worked fine (If you get a message about SET > AUTOCOMMIT then you need to upgrade your jdbc jar) > > Quite handy for getting a grasp on stupidly large query plans. > > http://sources.redhat.com/rhdb/visualexplain.html > > I used the CVS version, I have no idea how well the "official" releases > work. > Anyone else using it? > > > -- > Jeff Trout > http://www.jefftrout.com/ > http://www.stuarthamm.net/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.