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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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: Tue, 15 Jan 2008 09:50:44 +0000
  • Message-id: <937d27e10801150150g260df708se1f9d610bdadc16a(at)mail(dot)gmail(dot)com>

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: PNG image



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group