The Perl and Raku Conference 2023 in Toronto

pgCluu is a PostgreSQL performances monitoring and auditing dedicated tool. It generates reports of all statistics collected from a PostgreSQL databases cluster and from the operating system. pgCluu can also be use to generated reports from pgBouncer and the Sysstat sar command output or binary file. After a short demonstration of the reports generated by pgCluu we will look deeper in the pgCluu architecture and how Perl is used to collect the metrics and generate the reports. This tool generates standalone HTML reports or continuously reporting through a CGI web application.

This talk is about pgCluu, a Perl tool for PostgreSQL performances monitoring and auditing. It allows to correlate system activity with PostgreSQL metrics to find the source of the performances bottlenecks. It can also generate reports for pgBouncer and the sysstat sar command.