Обсуждение: question on graphical explain
Hi - I just installed PGADMIN 1.8.4 on my machine. I would like to save the graphical explain output for printing for later presentations. It is easy enough to export the 'data output'Of the explain to a file but I wish to print the 'explain' output. Any help would be appreciated. Thank you, Mark Steben│Database Administrator│ @utoRevenueT 480 Pleasant Street, Suite B200, Lee, MA 01238 413-243-4800 x1512 (Phone) │ 413-243-4809 (Fax) A Division of Dominion Enterprises
2008/8/20 Mark Steben <msteben@autorevenue.com>: > Hi - I just installed PGADMIN 1.8.4 on my machine. > I would like to save the graphical explain output for printing for later > > presentations. It is easy enough to export the 'data output' > Of the explain to a file but I wish to print the 'explain' output. > Any help would be appreciated. There aren't yet any printing options in pgAdmin (it's a lot of work, for a rarely requested feature), but iirc, Magnus had a patch to save the EXPLAIN output to a bitmap file. What happened to that Magnus? In the meantime, if you're on Windows, you can use Alt+Print Screen to copy the current window to the clipboard from where you can paste it into your favourite graphics program. On a Mac, press Cmd+Shift+4, then hit the spacebar and click to snap the window (a file will be saved to your desktop. There's probably 1001 different ways to do it on Linux, none of which I know. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
Dave Page wrote: > 2008/8/20 Mark Steben <msteben@autorevenue.com>: >> Hi - I just installed PGADMIN 1.8.4 on my machine. >> I would like to save the graphical explain output for printing for later >> >> presentations. It is easy enough to export the 'data output' >> Of the explain to a file but I wish to print the 'explain' output. >> Any help would be appreciated. > > There aren't yet any printing options in pgAdmin (it's a lot of work, > for a rarely requested feature), but iirc, Magnus had a patch to save > the EXPLAIN output to a bitmap file. What happened to that Magnus? Sitting in my queue. There were some adjustments needed to make it work on the Mac, IIRC, and I just haven't gotten around to doing those and then applying it. //Magnus
No rush Magnus, Dave's alt-printscreen suggestion works just fine. Thanks Dave ________________________________ Mark Steben│Database Administrator│ @utoRevenueT 480 Pleasant Street, Suite B200, Lee, MA 01238 413-243-4800 x1512 (Phone) │ 413-243-4809 (Fax) A Division of Dominion Enterprises -----Original Message----- From: Magnus Hagander [mailto:magnus@hagander.net] Sent: Wednesday, August 20, 2008 4:24 PM To: Dave Page Cc: Mark Steben; pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] question on graphical explain Dave Page wrote: > 2008/8/20 Mark Steben <msteben@autorevenue.com>: >> Hi - I just installed PGADMIN 1.8.4 on my machine. >> I would like to save the graphical explain output for printing for later >> >> presentations. It is easy enough to export the 'data output' >> Of the explain to a file but I wish to print the 'explain' output. >> Any help would be appreciated. > > There aren't yet any printing options in pgAdmin (it's a lot of work, > for a rarely requested feature), but iirc, Magnus had a patch to save > the EXPLAIN output to a bitmap file. What happened to that Magnus? Sitting in my queue. There were some adjustments needed to make it work on the Mac, IIRC, and I just haven't gotten around to doing those and then applying it. //Magnus
print-screen doesn't cut it when the diagram is too tall or too wide for window and the image has scrollbars. The EXPORT to image for the explain diagram would preserve all of the image.
2008/8/20 Mark Steben <msteben@autorevenue.com>
No rush Magnus, Dave's alt-printscreen suggestion works just fine. Thanks
Dave
________________________________
Mark Steben│Database Administrator│ @utoRevenueT
480 Pleasant Street, Suite B200, Lee, MA 01238
413-243-4800 x1512 (Phone) │ 413-243-4809 (Fax)
A Division of Dominion Enterprises-----Original Message-----
From: Magnus Hagander [mailto:magnus@hagander.net]
Sent: Wednesday, August 20, 2008 4:24 PM
To: Dave Page
Cc: Mark Steben; pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] question on graphical explain
Dave Page wrote:
> 2008/8/20 Mark Steben <msteben@autorevenue.com>:
>> Hi - I just installed PGADMIN 1.8.4 on my machine.
>> I would like to save the graphical explain output for printing for later
>>
>> presentations. It is easy enough to export the 'data output'
>> Of the explain to a file but I wish to print the 'explain' output.
>> Any help would be appreciated.
>
> There aren't yet any printing options in pgAdmin (it's a lot of work,
> for a rarely requested feature), but iirc, Magnus had a patch to save
> the EXPLAIN output to a bitmap file. What happened to that Magnus?
Sitting in my queue. There were some adjustments needed to make it work
on the Mac, IIRC, and I just haven't gotten around to doing those and
then applying it.
//Magnus
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support