pgCluu For Linux

pgCluu is an open source, free and platform-independent web-based and command-line application implemented in Perl and designed from the ground up to help users monitor and audit the performance of a PostgreSQL database server.

The software is capable of performing a complete audit process of a PostgreSQL Cluster. It’s comprised of two tools, as well as a collector that can be used to grab statistics about the PostgreSQL cluster by using the sar and psql commands.

It comes with a grapher that will output the results as HTML reports and charts. The software displays statistics about global cluster information, statistics per database, and statistics about the hosting system. It is compatible with UNIX/Linux operating systems.

The web-based interface of the program is easy to use and intuitive, as you will always have quick access to system information, cluster, databases, pgBouncer and system components of the application. Access each one of them to get more options and get the job done without too much hassle.

A wide range of options are avaialble for the command-line component of the project, allowing the user to enable buffer cache statistics if the pg_buffercache plugin is installed, to specify the database name to connect to, to specify the database server host, to specify the socket directory, to specify the time to wait between runs, as well as to set a comma separated list of metrics to perform.

Among other command-line options, we can mention the ability to specify the database port to connect to, to disable collection of system statistics with sar and lookup of tablespace, to list available metrics actions that can be performed, to enable SSH and run sysstat remotely, to view a list of options to use for the SSH connection and to use a custom PID file.