From: | Jeff <threshar(at)torgo(dot)978(dot)org> |
---|---|
To: | Postgres Performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Visual Explain |
Date: | 2004-06-16 14:01:32 |
Message-ID: | AC19531A-BF9D-11D8-A9B4-000D9366F0C4@torgo.978.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Luc Lachance | 2004-06-16 14:14:14 | Re: How to delete the not DISTINCT ON entries |
Previous Message | Tom Lane | 2004-06-16 13:48:42 | Re: 7.4 performance issue |
From | Date | Subject | |
---|---|---|---|
Next Message | Bill | 2004-06-16 19:15:27 | Basic Postgresql Performance Question |
Previous Message | Frank van Vugt | 2004-06-16 08:42:10 | Re: why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ?? |