SEO

#1 (**permalink**) 04-18-2008, 08:55 AM

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 :-)

Thanks!

//Magnus

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

#2 (**permalink**) 04-18-2008, 08:55 AM

Dave Page wrote:
> On 14/01/2008, Magnus Hagander <magnus@hagander.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 :-)

Interesting. I don't get that here - what platform is that on? Mac?

Maybe just add a simple +20 pixels or something to the right to work
around it? ;-) Given that it's not exactly aligned to the edge of the
image anyway, that shouldn't be a problem?

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

Be my guest :-)

What would actually be *really* cool was an export in SVG including
those, but wx doesn't do that :-)

//Magnus

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

#3 (**permalink**) 04-18-2008, 08:55 AM

Yeah, it's mac. I assume it doesn't do it on win32/unix? An additional
few px seems reasonable btw.

/D

On 1/16/08, Magnus Hagander <magnus@hagander.net> wrote:
> Dave Page wrote:
> > On 14/01/2008, Magnus Hagander <magnus@hagander.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 :-)
>
> Interesting. I don't get that here - what platform is that on? Mac?
>
> Maybe just add a simple +20 pixels or something to the right to work
> around it? ;-) Given that it's not exactly aligned to the edge of the
> image anyway, that shouldn't be a problem?
>
>
> > Now you just need to add options to include the data for each node and
> > the query text :-p
>
> Be my guest :-)
>
> What would actually be *really* cool was an export in SVG including
> those, but wx doesn't do that :-)
>
> //Magnus
>

--
Sent from my mobile device

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Saving explain output graphically