From: | Adam Witney <awitney(at)sghms(dot)ac(dot)uk> |
---|---|
To: | Jeff <threshar(at)torgo(dot)978(dot)org>, pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Visual Explain |
Date: | 2004-06-17 11:10:30 |
Message-ID: | BCF73AB6.3485A%awitney@sghms.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
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 <jeff(at)jefftrout(dot)com>
> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Henrik Steffen | 2004-06-17 11:36:34 | Re: index with LIKE |
Previous Message | Richard Huxton | 2004-06-17 10:34:56 | Re: Join a varchar array |
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Thomas | 2004-06-17 12:16:34 | Re: [PERFORM] Visual Explain |
Previous Message | Josh Berkus | 2004-06-17 00:33:37 | Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED |