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@lelarge.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/