Statistics collection and reporting for the PostgreSQL database.

Lightweight package with powerful features.

How it works.

Why PostgreStats was developed.

PostgreStats Enterprise is a small suite of scripts that allow database administrators to view core stats collected from the PostgreSQL Statistics Collector in time-based intervals. Developed in PHP, HTML5 and Javascript and automated with cron, PostgreStats has numerous ways to view your data including monthly, daily, month VS month, weekly and yearly statistics views. PostgreStats can collect database stats from single server environments or multiple servers simultaneously (such as production and development) and has a Replication Mode to easily combine or separate these statistics for comparison.From full online GUI administration and statistics pausing on both server and database levels, to replication mode for specific servers or cluster-wide environments, data-aware navigations and PostgreSQL itself for data storage, PostgreStats was developed for database administrators, by a database administrator. The PostgreStats code-base is fanatically commented. Developers can easily modify its core scripts to suit their specific network and database requirements.PostgreStats gets installed on any webserver and has a full online GUI for administration. Using Apache, simply set-up and visit the website where you'll then configure the main database and add servers & databases for which you'll collect statistics. Stats are collected VIA a single cron-job where PostgreSQL stores the data itself. PostgreStats Enterprise does not require either root or the PostgreSQL super-user and does not require that statistics in the collector be reset at all. Visit our Installation and FAQ pages for more details.If you're familiar with the PostgreSQL Statistics Collector, you know it contains valuable stat data on your running databases but you also know that the views which contain this data such as pg_stat_database and pg_stat_user_tables are simply running numbers of commits, inserts, buffer hits, etc. Stats are not broken down by days or months and not displayed in a truly meaningful format. PostgreStats was designed precisely with this in mind, to support the viewing of primary statistics broken down by database in timed cycles in a multitude of views, helping you identify trends, issues and general knowledge of your Postgres implementation.