Re: Visual Explain
От | Adam Witney |
---|---|
Тема | Re: Visual Explain |
Дата | |
Msg-id | BCF73AB6.3485A%awitney@sghms.ac.uk обсуждение исходный текст |
Ответ на | Visual Explain (Jeff <threshar@torgo.978.org>) |
Ответы |
Re: Visual Explain
|
Список | 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@jefftrout.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.
В списке pgsql-performance по дате отправления: