Skip site navigation (1) Skip section navigation (2)

Re: Export the explain diagram?

From: Michael Shapiro <mshapiro51(at)gmail(dot)com>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Export the explain diagram?
Date: 2010-02-09 14:48:07
Message-ID: ca3a8da21002090648h30e7d43dl4d3b3ad35dd00876@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
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(at)lelarge(dot)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
>

In response to

Responses

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2010-02-09 15:03:00
Subject: Re: Export the explain diagram?
Previous:From: Guillaume LelargeDate: 2010-02-09 14:24:37
Subject: Re: Export the explain diagram?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group