From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Michael Shapiro <mshapiro51(at)gmail(dot)com> |
Cc: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Export the explain diagram? |
Date: | 2010-02-09 15:03:00 |
Message-ID: | 4B717924.7000405@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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.org
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Shapiro | 2010-02-09 15:09:19 | Re: Export the explain diagram? |
Previous Message | Michael Shapiro | 2010-02-09 14:48:07 | Re: Export the explain diagram? |