pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Visual Explain
9+ messages / 4 participants
[nested] [flat]

* Visual Explain
@ 2004-06-16 14:01 Jeff <threshar@torgo.978.org>
  2004-06-17 11:10 ` Re: Visual Explain Adam Witney <awitney@sghms.ac.uk>
  0 siblings, 1 reply; 9+ messages in thread

From: Jeff @ 2004-06-16 14:01 UTC (permalink / raw)
  To: 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@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Visual Explain
  2004-06-16 14:01 Visual Explain Jeff <threshar@torgo.978.org>
@ 2004-06-17 11:10 ` Adam Witney <awitney@sghms.ac.uk>
  2004-06-17 12:16   ` Re: [PERFORM] Visual Explain Paul Thomas <paul@tmsl.demon.co.uk>
  2004-06-17 13:37   ` Re: Visual Explain Jeff <threshar@torgo.978.org>
  0 siblings, 2 replies; 9+ messages in thread

From: Adam Witney @ 2004-06-17 11:10 UTC (permalink / raw)
  To: Jeff <threshar@torgo.978.org>; 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.




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: [PERFORM] Visual Explain
  2004-06-16 14:01 Visual Explain Jeff <threshar@torgo.978.org>
  2004-06-17 11:10 ` Re: Visual Explain Adam Witney <awitney@sghms.ac.uk>
@ 2004-06-17 12:16   ` Paul Thomas <paul@tmsl.demon.co.uk>
  2004-06-17 12:52     ` Re: Visual Explain Paul Thomas <paul@tmsl.demon.co.uk>
  1 sibling, 1 reply; 9+ messages in thread

From: Paul Thomas @ 2004-06-17 12:16 UTC (permalink / raw)
  To: Adam Witney <awitney@sghms.ac.uk>; +Cc: pgsql-general @ postgresql . org <pgsql-general@postgresql.org>


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   |
+------------------------------+---------------------------------------------+



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Visual Explain
  2004-06-16 14:01 Visual Explain Jeff <threshar@torgo.978.org>
  2004-06-17 11:10 ` Re: Visual Explain Adam Witney <awitney@sghms.ac.uk>
  2004-06-17 12:16   ` Re: [PERFORM] Visual Explain Paul Thomas <paul@tmsl.demon.co.uk>
@ 2004-06-17 12:52     ` Paul Thomas <paul@tmsl.demon.co.uk>
  2004-06-17 16:54       ` Re: Visual Explain Vitaly Belman <vitalyb@gmail.com>
  0 siblings, 1 reply; 9+ messages in thread

From: Paul Thomas @ 2004-06-17 12:52 UTC (permalink / raw)
  To: pgsql-performance


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   |
+------------------------------+---------------------------------------------+




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Visual Explain
  2004-06-16 14:01 Visual Explain Jeff <threshar@torgo.978.org>
  2004-06-17 11:10 ` Re: Visual Explain Adam Witney <awitney@sghms.ac.uk>
  2004-06-17 12:16   ` Re: [PERFORM] Visual Explain Paul Thomas <paul@tmsl.demon.co.uk>
  2004-06-17 12:52     ` Re: Visual Explain Paul Thomas <paul@tmsl.demon.co.uk>
@ 2004-06-17 16:54       ` Vitaly Belman <vitalyb@gmail.com>
  2004-06-17 17:05         ` Re: Visual Explain Jeff <threshar@torgo.978.org>
  2004-06-17 17:35         ` Re: Visual Explain Paul Thomas <paul@tmsl.demon.co.uk>
  0 siblings, 2 replies; 9+ messages in thread

From: Vitaly Belman @ 2004-06-17 16:54 UTC (permalink / raw)
  To: Paul Thomas <paul@tmsl.demon.co.uk>; +Cc: pgsql-performance

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 <paul@tmsl.demon.co.uk> 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
>



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Visual Explain
  2004-06-16 14:01 Visual Explain Jeff <threshar@torgo.978.org>
  2004-06-17 11:10 ` Re: Visual Explain Adam Witney <awitney@sghms.ac.uk>
  2004-06-17 12:16   ` Re: [PERFORM] Visual Explain Paul Thomas <paul@tmsl.demon.co.uk>
  2004-06-17 12:52     ` Re: Visual Explain Paul Thomas <paul@tmsl.demon.co.uk>
  2004-06-17 16:54       ` Re: Visual Explain Vitaly Belman <vitalyb@gmail.com>
@ 2004-06-17 17:05         ` Jeff <threshar@torgo.978.org>
  1 sibling, 0 replies; 9+ messages in thread

From: Jeff @ 2004-06-17 17:05 UTC (permalink / raw)
  To: Vitaly Belman <vitalyb@gmail.com>; +Cc: Paul Thomas <paul@tmsl.demon.co.uk>; pgsql-performance


On Jun 17, 2004, at 12:54 PM, 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'll need to snag it out of cvs:

http://sources.redhat.com/rhdb/cvs.html

You can checkout just visual explain so you won't need to grab 
everything.

--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Visual Explain
  2004-06-16 14:01 Visual Explain Jeff <threshar@torgo.978.org>
  2004-06-17 11:10 ` Re: Visual Explain Adam Witney <awitney@sghms.ac.uk>
  2004-06-17 12:16   ` Re: [PERFORM] Visual Explain Paul Thomas <paul@tmsl.demon.co.uk>
  2004-06-17 12:52     ` Re: Visual Explain Paul Thomas <paul@tmsl.demon.co.uk>
  2004-06-17 16:54       ` Re: Visual Explain Vitaly Belman <vitalyb@gmail.com>
@ 2004-06-17 17:35         ` Paul Thomas <paul@tmsl.demon.co.uk>
  2004-06-17 18:13           ` Re: Visual Explain Vitaly Belman <vitalyb@gmail.com>
  1 sibling, 1 reply; 9+ messages in thread

From: Paul Thomas @ 2004-06-17 17:35 UTC (permalink / raw)
  To: Vitaly Belman <vitalyb@gmail.com>; +Cc: pgsql-performance

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   |
+------------------------------+---------------------------------------------+



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Visual Explain
  2004-06-16 14:01 Visual Explain Jeff <threshar@torgo.978.org>
  2004-06-17 11:10 ` Re: Visual Explain Adam Witney <awitney@sghms.ac.uk>
  2004-06-17 12:16   ` Re: [PERFORM] Visual Explain Paul Thomas <paul@tmsl.demon.co.uk>
  2004-06-17 12:52     ` Re: Visual Explain Paul Thomas <paul@tmsl.demon.co.uk>
  2004-06-17 16:54       ` Re: Visual Explain Vitaly Belman <vitalyb@gmail.com>
  2004-06-17 17:35         ` Re: Visual Explain Paul Thomas <paul@tmsl.demon.co.uk>
@ 2004-06-17 18:13           ` Vitaly Belman <vitalyb@gmail.com>
  0 siblings, 0 replies; 9+ messages in thread

From: Vitaly Belman @ 2004-06-17 18:13 UTC (permalink / raw)
  To: Paul Thomas <paul@tmsl.demon.co.uk>; +Cc: pgsql-performance

I see. Thanks :).

On Thu, 17 Jun 2004 18:35:11 +0100, Paul Thomas <paul@tmsl.demon.co.uk> 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   |
> +------------------------------+---------------------------------------------+
>



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Visual Explain
  2004-06-16 14:01 Visual Explain Jeff <threshar@torgo.978.org>
  2004-06-17 11:10 ` Re: Visual Explain Adam Witney <awitney@sghms.ac.uk>
@ 2004-06-17 13:37   ` Jeff <threshar@torgo.978.org>
  1 sibling, 0 replies; 9+ messages in thread

From: Jeff @ 2004-06-17 13:37 UTC (permalink / raw)
  To: Adam Witney <awitney@sghms.ac.uk>; +Cc: pgsql-performance


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




^ permalink  raw  reply  [nested|flat] 9+ messages in thread


end of thread, other threads:[~2004-06-17 18:13 UTC | newest]

Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-16 14:01 Visual Explain Jeff <threshar@torgo.978.org>
2004-06-17 11:10 ` Adam Witney <awitney@sghms.ac.uk>
2004-06-17 12:16   ` Paul Thomas <paul@tmsl.demon.co.uk>
2004-06-17 12:52     ` Paul Thomas <paul@tmsl.demon.co.uk>
2004-06-17 16:54       ` Vitaly Belman <vitalyb@gmail.com>
2004-06-17 17:05         ` Jeff <threshar@torgo.978.org>
2004-06-17 17:35         ` Paul Thomas <paul@tmsl.demon.co.uk>
2004-06-17 18:13           ` Vitaly Belman <vitalyb@gmail.com>
2004-06-17 13:37   ` Jeff <threshar@torgo.978.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox