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

Re: Saving explain output graphically

From: "Dave Page" <dpage(at)postgresql(dot)org>
To: "Magnus Hagander" <magnus(at)hagander(dot)net>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Saving explain output graphically
Date: 2008-01-15 09:50:44
Message-ID: 937d27e10801150150g260df708se1f9d610bdadc16a@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
On 14/01/2008, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> There was some talk a while back about being able to save the explain
> output graphically, and I've taken a stab at it. Attached patch appears
> to be working for me, but I had a lot of trouble getting things to work
> properly before I found the right track. Specifically, I got the wrong
> size of the image all the time.
>
> So if some people could test the patch with a bunch of different queries
> and strange explain outputs, to see if you get proper size images out of
> it, that would be great :-)

I consistently get no border along the right hand side - see the
attached example. It looks pretty good though :-)

Now you just need to add options to include the data for each node and
the query text :-p

/D

Attachment: pg_stat_all_tables.png
Description: image/png (25.0 KB) (inlined above)

In response to

Responses

pgadmin-hackers by date

Next:From: svnDate: 2008-01-16 15:31:52
Subject: SVN Commit by dpage: r6999 - in branches/REL-1_8_0_PATCHES/pgadmin3: . pgadmin/schema
Previous:From: Magnus HaganderDate: 2008-01-14 22:36:22
Subject: Saving explain output graphically

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