Hiraedd (Marco's blog)

I wrote a small tool, postgresqlgraph, to monitor and plot the statistics of a postgresql database, using rrdtool.

The tool is able to monitor every database created inside a postgresql installation.

The parameters plotted for each database in the graph are:

• numbackends: number of backends:
• xact_commit: transactions committed;
• xact_rollback: transactions rolled back;
• blks_read: blocks read from the disk;:
• blks_hit: blocks hit in the cache;
• tup_returned: tuples returned (only in postgresql 8.3)
• tup_fetched: tuples fetched (only in postgresql 8.3)
• tup_inserted: tuples inserted (only in postgresql 8.3)
• tup_updated: tuples updated (only in postgresql 8.3)
• tup_deleted: deleted (only in postgresql 8.3)

For each parameter the graph shows the maximum and average values, and plots the derivative (rate change).

The software is published under GPLv3 .

A demo is available here.

Please feel free to submit me bugs, critics, improvements, or tell me if you find the tool of any worthwhileness.