PostgreSQL Cluster Utilization
pgCluu is a Perl program used to perform a full audit of a PostgreSQL Cluster performances. It is divided in two parts, a collector used to grab statistics on the PostgreSQL server using psql and sar, a reports builder that will generate all HTML and charts output.
This release is a maintenance release that fix some issues. There's also some new interesting reports:
and useful features:
This release also adds -r | --rotate-daily and -R | --rotate-hourly options to pgcluu_collectd be able to rotate statistic files on a daily or hourly basis. You can use -z or --compress option to compress rotated data files.
There also some code relative to next coming major release that will be used to allow a full incremental mode and a temporal selection into the collected statistics from a CGI program. This code enable caching (option -C or --cache) by dumping statistics stored in memory into binary files. With those files, data files can be removed (automatically with option -c or --clean) and report can be build later from them. This is not really useful now but this s the first stage to build incremental and cumulative reports.
See ChangeLog for a complete list of changes and bug fixes.
The goal of this project is to provide a complete PostgreSQL auditing tool that don't need any dependency to be run easily to audit a local or remote server.
If you just have a sar output file, pgCluu can be use to draw graphs about the system utilization only.
pgCluu is an original collection of tools built during my work at Dalibo. Those tools are published under the PostgreSQL License to be shared, any one is welcome to contribute.
For more information take a look at pgcluu.darold.net
View a sample report at pgcluu.darold.net/example/index.html
pgCluu is created and maintained by Gilles Darold.