Software Catalogue - Reporting tools

Script that monitors and reports on over 30 different important items for one or more Postgres servers. It can be used with Nagios, with MRTG, or standalone. Some of the checks include locks, table and index bloat, database size, open transactions, long-running queries, WAL files, postgresql.conf changes, and verifying that replication is working.

RPT - universal reporting tool delivering standarized, easy and intuitive access to data analysis, reports and queries basing on various IT systems or data sources

pgBadger is a PostgreSQL log analyzer build for speed with fully detailed reports from your PostgreSQL log file.

pgsnap is a PostgreSQL tool that mimics orasnap performance report tool for Oracle.

It's written in PHP but one uses it on the command line. Many HTML files, aka reports, are written on a folder. You only need a web browser to read the complete report.

pg_top is 'top' for PostgreSQL. It is derived from Unix Top.

A powerful set of fully automated scripts allowing you to easily extract, store, monitor and display online statistics from PostgreSQL's Stat Collector.

With various reporting views, optional Apache security, email snapshot reports and auto vacuum / analyze on update, PostgreStats allows you to view and track your Postgres activity in a whole new light.

Graphical Statistics:
• Monthly Snapshot Review
• Daily Over-all Statistics
• Individual Database Statistics
• Month VS Month Statistics Analysis
• Weekly Trending Stats
• Yearly Summary Statistics

Meaningful Data:
• Peak Day Statistics
• Data Comparison on Previous Cycles
• Trending & Activity Statistics
• Averages: Day / Hour / Min / Sec
• Stats all Major Statistics Including:
- Commits
- Rollbacks
- Block Reads
- Buffer Hits
- User Inserts
- User Updates
- User Deletes
- Sequence Scans & Rows Used in Scans
- Index Scans & Rows Used in Scans

Easy to Set-up / Fully Automated:
• Simple Customizable Conf File
• Automated Easily with Cron
• Log File Data Storage for Portability

Powerful Options / Features:
• Optional Email Snapshot Reports
• Optional CSS Customization
• Optional Standard Apache Security
• Optional Local Log Back-up
• Optional Vacuum Analyze on Update

Fully Documented / Commented:
The PostgreStats project and source code is fanatically documented and commented to support those who would like to further customize the package for their own specific needs.

Active Project - Support:
PostgreStats is an active open-source project, receives regular updates & patches and has an extensive base of support documentation.

Enterprise is PostgreStats for multi-server PostgreSQL environments.

Built from the ground up to support multi-database server networks, PostgreStats Enterprise tracks the same collector statistics such as commits, rollbacks, block reads, buffer hits, inserts, updates, deletes, etc., and allows administrators to view statistics from single or multiple servers and isolate single database stats in timed cycles.

Enterprise Features:
• Server & database statistic isolation
• Replication mode with split & combined stat views
• Statistics pausing
• PostgreSQL data storage
• Data-aware navigations
• Full online GUI for administration
• Lots of core updates

Unlike PostgreStats which uses a flat txt data storage format and gets installed & executed from the database server, Enterprise uses PostgreSQL itself to store statistics and is installed and executed from any network webserver. It does not require root or the PostgreSQL super-user and does not require collector statistics be reset.

Fully Documented / Commented:
The PostgreStats project and source code is fanatically documented and commented to support those who would like to further customize the package for their own specific needs.

Active Project - Support:
PostgreStats is an active open-source project, receives regular updates & patches and has an extensive base of support documentation.