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])