Le 09/02/2010 15:48, Michael Shapiro a écrit :
> 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.
>
It takes longer because it really executes the query.
> 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.
>
It could be interesting to do. Anyways, you can also compare the text
output.
--
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com