The PostgreSQL performance auditing and monitoring tool pgCluu has been updated.

pgCluu version 3.4 released

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 fixes issues reported by users since past six months.

• Fix unwanted report of missing index from partitions.
• Fix cases where detection of redundant indexes was depending on the creation order.
• Move "Cancelled queries" report from "Replication" sub menu to upper level.
• Allow -k option to make pgcluu_collectd exit gracefully. Previous behavior was to exit immediately, for an immediate interrupt use the TERM (-15) signal now.
• Fix collect of the pg_stat_user_indexes, pg_stat_user_tables and corresponding I/O stats.
• Fix --rotate-daily spill directory.
• [CGI] verify that pidstat statistics exists before trying to load them.
• [CGI] Fix wrong error message when attempt to read binary files and remove useless code.
• Remove newline from indexes definition to avoid data import error when building reports.

See  ChangeLog for a complete list of changes, bug fixes and acknowledgement.

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 also be use to draw graphs about the system utilization from this file.

pgCluu is a collection of tools published under the PostgreSQL License to be shared, any one is welcome to contribute.

For more information take a look at  http://pgcluu.darold.net/

View a sample report at  http://pgcluu.darold.net/example/index.html

About

pgCluu is created and maintained by Gilles Darold.

• Web/Demo site:  http://pgcluu.darold.net/
• Download:  https://github.com/darold/pgcluu/releases
• Development:  https://github.com/darold/pgcluu
• Documentation:  https://github.com/darold/pgcluu/blob/master/README

pgCluu version 3.4 released