wiki:PluginPortrait/pg_diskusage

Plugin to display the disk usage of PostgreSQL databases.

Requires oid2name, usually bundled in some "contrib" package.

Tested with PostgreSQL version 8.0 and 8.1.

FreeBSD remark

On FreeBSD, the 'du' program seems unable to return the size in bytes. The used argument -b is not recognized by the FreeBSD 'du' program.

If you run FreeBSD, I suggest you change line 60 from:

echo `du -bs $OID` | awk '{ print $1 }'

to

echo `du -s $OID` | awk '{ print $1*1000 }'
Last modified at 2008-10-23T02:56:41+02:00 Last modified on 2008-10-23T02:56:41+02:00

Attachments (1)

Download all attachments as: .zip