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