The Perl and Raku Conference 2023 in Toronto
Attending this event?
Back To Schedule
Tuesday, July 11 • 3:00pm - 3:20pm
Auditing PostgreSQL and system performances using Perl

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

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.

avatar for Gilles DAROLD


PostgreSQL Expert, DAROLD.NET
Gilles is a PostgreSQL expert and developer. He is involved in PostgreSQL and Open Sources for over 25 years and have worked on many different projects. Gilles started using Perl in 1995, and since then he has created some well known tools around PostgreSQL like pgBadger for log analysis... Read More →

Tuesday July 11, 2023 3:00pm - 3:20pm EDT
Track 1