Re: Export the explain diagram?

From: Michael Shapiro <mshapiro51(at)gmail(dot)com>
To: Andreas Neumann <a(dot)neumann(at)carto(dot)net>
Cc: Guillaume Lelarge <guillaume(at)lelarge(dot)info>, "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Export the explain diagram?
Date: 2010-02-09 16:52:05
Message-ID: ca3a8da21002090852h68ae6ec8sa67f0431583a3845@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

As long as JPG is also supported. You might want to offer a Save As where
SVG, PNG, JPG, BMP(?) are offered.

On Tue, Feb 9, 2010 at 10:46 AM, Andreas Neumann <a(dot)neumann(at)carto(dot)net>wrote:

> If someone works on exporting the diagram, it would be worth looking at
> the SVG format, which is supported by modern browsers.
>
> This way it can be read into Inkscape as well for further processing.
>
> And it could potentially also contain scripting/interactivity for tooltips.
>
> Andreas
>
>
> On Tue, February 9, 2010 3:48 pm, Michael Shapiro wrote:
> > The diagram looks pretty much the same, but I do see that when I click on
> > one of the items in the diagram, the text box that pops up showing info
> > from
> > the explain (cost, etc) has more to it (not just cost, but actual time).
> I
> > assume that information is coming from the more extensive information
> from
> > the ANALYZE. Nice! It takes a bit longer to run the EXPLAIN with ANALYZE
> > turned on, but it is worth it.
> >
> > I have a another request for a mod to the diagram. The text box
> disappears
> > as soon as I move the mouse. It would be helpful if it would stay up
> > longer
> > (eg, until the mouse is clicked in the text box). In order to compare
> > various queries, it is helpful to be able to see the info from two
> > diagrams
> > at the same time. What would make this possible is if the text boxes were
> > to
> > stay up until I click again.
> >
> > On Tue, Feb 9, 2010 at 8:24 AM, Guillaume Lelarge
> > <guillaume(at)lelarge(dot)info>wrote:
> >
> >> Le 09/02/2010 15:09, Michael Shapiro a écrit :
> >> > We are talking about EXPLAIN, not VACUUM, since this is from the Query
> >> tool.
> >> >
> >>
> >> Sorry, I meant EXPLAIN when I said VACUUM. Should sleep more :)
> >>
> >> > Is there a lot more information in the EXPLAIN diagram with ANALYZE
> >> than
> >> > without it?
> >> >
> >>
> >> A lot, not really. More useful than a "simple" EXPLAIN, sure.
> >>
> >>
> >> --
> >> Guillaume.
> >> http://www.postgresqlfr.org
> >> http://dalibo.com
> >>
> >
>
>
> --
> Andreas Neumann
> http://www.carto.net/neumann/
> http://www.svgopen.org/
>
>

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Raymond O'Donnell 2010-02-09 21:06:46 Feature request: <null> in table view
Previous Message Andreas Neumann 2010-02-09 16:46:13 Re: Export the explain diagram?