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