От: Jeff
Тема: Visual Explain
Дата: ,
Msg-id: AC19531A-BF9D-11D8-A9B4-000D9366F0C4@torgo.978.org
(см: обсуждение, исходный текст)
Ответы: Re: Visual Explain  (Adam Witney)
Список: pgsql-performance

Скрыть дерево обсуждения

Visual Explain  (Jeff, )
 Re: Visual Explain  (Adam Witney, )
  Re: Visual Explain  (Jeff, )
 Re: Visual Explain  (Paul Thomas, )
  Re: Visual Explain  (Vitaly Belman, )
   Re: Visual Explain  (Jeff, )
   Re: Visual Explain  (Paul Thomas, )
    Re: Visual Explain  (Vitaly Belman, )

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 <>
http://www.jefftrout.com/
http://www.stuarthamm.net/



В списке pgsql-performance по дате сообщения:

От: Stephen Frost
Дата:
Сообщение: Re: Basic Postgresql Performance Question
От: Kevin Barnard
Дата:
Сообщение: Re: Basic Postgresql Performance Question