Re: [PERFORM] Visual Explain
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 [EMAIL PROTECTED] 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. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [PERFORM] Visual Explain
On 17/06/2004 12:10 Adam Witney wrote: Will this run on other platforms? OSX maybe? It's a Java app so it runs on any any platform with a reasonably modern Java VM. -- Paul Thomas +--+-+ | Thomas Micro Systems Limited | Software Solutions for Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +--+-+ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [PERFORM] Visual Explain
On Jun 17, 2004, at 7:10 AM, Adam Witney wrote: Will this run on other platforms? OSX maybe? I've run it on both linux (rh8) and osx (panther). its java so it *should* run anywhere. It isn't the fastest beast in the world though. takes a bit of time to render the plan. -- Jeff Trout [EMAIL PROTECTED] http://www.jefftrout.com/ http://www.stuarthamm.net/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [PERFORM] Visual Explain
Is it possible to download the Visual Explain only (link)? I only see that you can donwload the whole ISO (which I hardly need). On Thu, 17 Jun 2004 13:52:15 +0100, Paul Thomas [EMAIL PROTECTED] wrote: On 17/06/2004 12:10 Adam Witney wrote: Will this run on other platforms? OSX maybe? It's a Java app so it runs on any any platform with a reasonably modern Java VM. -- Paul Thomas +--+-+ | Thomas Micro Systems Limited | Software Solutions for Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +--+-+ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [PERFORM] Visual Explain
I see. Thanks :). On Thu, 17 Jun 2004 18:35:11 +0100, Paul Thomas [EMAIL PROTECTED] wrote: On 17/06/2004 17:54 Vitaly Belman wrote: Is it possible to download the Visual Explain only (link)? I only see that you can donwload the whole ISO (which I hardly need). You can get it from CVS and build it yourself. -- Paul Thomas +--+-+ | Thomas Micro Systems Limited | Software Solutions for Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +--+-+ ---(end of broadcast)--- TIP 8: explain analyze is your friend
[PERFORM] Visual Explain
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 [EMAIL PROTECTED] 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