| 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: | Whole Thread | Raw Message | 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? |