pgCluu

pgCluu is a totally free and open-source tool that works on any platform. It's perfect for keeping an eye on your PostgreSQL database server’s performance. Built with Perl, this application makes it easy to monitor and audit everything you need.

Complete Audit for Your PostgreSQL Cluster

This handy software can perform a full audit of your PostgreSQL Cluster. It has two main tools and a collector that gathers stats from the PostgreSQL cluster using commands like sar and psql. This way, you get all the information you need at your fingertips.

Create Beautiful Reports Easily

One of the coolest features? It includes a grapher that turns all those stats into HTML reports and charts! You’ll see global cluster data, info for each database, and details about the hosting system. Plus, it works great on UNIX/Linux operating systems!

User-Friendly Web Interface

The web-based interface is super easy to navigate. You’ll have quick access to important system information, clusters, databases, pgBouncer, and other components of your application. Just click around to find what you need without any fuss!

Command-Line Flexibility

If you prefer working in the command line, you're in luck! The command-line tool offers tons of options. You can enable buffer cache stats if you have the pg_buffercache plugin installed. Want to connect to a specific database? No problem! You can specify the database name, server host, socket directory, wait time between runs, and even set a list of metrics.

A Variety of Options Available

You also have plenty of command-line options available! For example, you can choose which port to connect through or skip collecting system stats with sar. Want SSH access for remote monitoring? That’s possible too! You can view a list of actions available or use a custom PID file as well.

If you're ready to dive in deeper with pgCluu or want to download it now, check out this link: Download pgCluu.