Statistics collection and reporting for the PostgreSQL database.
Lightweight package with powerful features.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.
How it works.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.
Why PostgreStats was developed.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.