Extract, store, monitor & display statistics from PostgreSQL's Statistics Collector.
PostgreStats is a powerful set of fully automated scripts allowing you to easily view core statistics such as commits, rollbacks, block reads, buffer hits, user inserts, updates and deletes in time-based interval views such as monthly snapshot, daily individual, month VS month comparison, weekly trending and yearly snapshot. View statistics on selected dates or time frames, peak & average statistics, activity trending, stat data for isolated databases or server-wide clusters. Compare data across days, months and years and see your PostgreSQL data in an entirely new light.
There are two major versions of this software, PostgreStats and Enterprise. Postgrestats is built for smaller networks or single server set-ups, executes from the database server and uses a TXT flat-file format for data storage. PostgreStats Enterprise was built for multi-server environments or for administrators who require advanced features or finer control, executes from any webserver and uses the PostgreSQL database for data storage. Both versions collect the same base set of statistics but offer their own unique features.
• Email Snapshot Reports
• Built-in Apache Realm Security
• Localized Log/Data Back-up
• Vacuum-Analyze on Update
• Auto FTP to Webserver
• TXT File Data Storage
• CSS Quick Interface Swap
• Multi-server Support
• Full Online GUI Administration
• Stat Pausing
• Replication Mode
• Data-aware Navigations
• PostgreSQL Data Storage
• DB Specific & Cluster Wide Statistics
PostgreStats - gets installed and executes on the database server. Once the software is downloaded, the main conf file is customized where you'll add your database credentials and turn on or off optional features such as email-on-update, user/pass authentication, auto-vacuum analyze, ftp-to-webserver, etc. A single cron-job is then set-up which will handle ongoing statistics collection where stats are stored in txt flat-files. Each time stats are collected, PostgreStats will reset statistics in the collector and the cycle repeats. Stats are viewed online in a site set-up for PostgreStats.
PostgreStats Enterprise - gets installed on any webserver and has a full online GUI for administration. Simply set-up and visit the site where you'll then configure the main database and add servers & databases for which you'll collect statistics. Enterprise statistics are also collected VIA a single cron-job where PostgreSQL stores the data itself. Enterprise does not require either root or the PostgreSQL super-user and does not require that statistics in the collector be reset at all. Stats are viewed online.
Every single major line of code in both PostgreStats and Enterprise is fanatically commented. Developers can easily modify the core code-base to suit their specific network and database requirements. Fully documented installation guides
as well as frequently asked questions
, server requirements
and even a request support
feature are all available from this site.
If you're familiar with the PostgreSQL Statistics Collector
process, you already 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 put into any meaningful format which easily allows you to make the most out of it. 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.