| |
|
5/8/13
PostgreStats 1.5
is Now Available!
Download it Here.
V1.5 includes various PHP notice fixes regarding variable declarations. Minor bug fixes & improvements.
|
|
4/16/13
Enterprise 1.1
is Now Available!
Download it Here.
PostgreStats Enterprise is officially out of Beta. Thanks to DBAs everywhere for providing critical feedback. V1.1 includes several key improvements as well as minor bug fixes.
|
|
1/22/13
PostgreStats 1.4
is Now Available!
Download it Here.
New in V1.4 is a CSS overhaul, an updated HTML5 doctype declaration, target stats are now highlighted in chart tooltips, & other core updates. Now tested under PostgreSQL version 9.1.7.
|
|
1/19/13
PostgreStats Enterprise Beta Now Available!
Enterprise is here, built for PostgreSQL multi-server envrionments!
- Multi-server Support
- Postgres Data Storage
- Stat Pausing
- Data-Aware Interface
- Full Online GUI
- Lots of Core Updates!
Demo and Source:
Check out the Beta demo right here. Download beta source here.
|
|
10/19/12
Enterprise Edition
Now in Development!
PostgreStats Enterprise is now in development with huge, new features. Stay tuned for the upcoming beta release and live demo.
|
|
7/13/12
PostgreStats 1.3
is Now Available!
Download it Here.
Version 1.3 includes an automated, configurable FTP-to-Webserver feature as well as various minor updates and fixes. V1.3 has also been tested under PostgreSQL 9.1.4. Enjoy!
|
|
11/23/11
Thank you!
A huge thanks to developers all over the world who have submitted critical feedback and critcism regarding the PostgreStats software package. I'm very glad you guys are finding it as useful as I have! |
|
9/27/10
Expanded Statistics!
Thank you to devs & Postgres admins for feedback. PostgreStats is now statting several new database fields including Sequences & Indexes as well as rows used in both Sequence and Index Scans. Check out the online demo to see it in action right here. |
|
Feedback:
If you'd like to provide feedback or comments on PostgreStats, please email us. We'd love to hear your thoughts on our software whether that's criticism or ideas you'd like to see implemented in a future release. |
|
|
| Extract, store and display statistics from PostgreSQL's Stat Collector in an automated, graphical fashion. |
What is PostgreStats?
PostgreStats is a powerful set of fully automated scripts allowing you to easily extract, store, monitor and display online statistics from PostgreSQL's Statistic Collector, in timed-cycles.
Built on a thoroughly documented and tested PHP/AJAX model, it allows database administrators to view activity on their PostgreSQL implementations with statistic views like Monthly Snapshot, Daily Individual, Month VS Month comparison, Weekly Trending and Yearly Snapshot.
Easily target and chart statistics on both Server-wide or individual database levels such as Commits, Rollbacks, Block Reads, Buffer Hits, User Inserts, Updates & Deletes, etc., and pull stats for a selected date or time-frame. View peak statistics, compare data across days & months and see your PostgreSQL data in an entirely new light.
PostgreStats & Enterprise - Which One's For Me?
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, it executes from any webserver and uses the PostgreSQL database for data storage. Both versions collect the same base set of statistics. Additional information about both versions can be found in our Documentation, Requirements and Installation Guide pages.
Fully Documented & Customizable.
One thing I've learned from communicating with developers all over the world, is that no PostgreSQL implementation is exactly the same. Every single major line of code in both PostgreStats and Enterprise is fanatically commented. Developers have modified the core code to suit their specific network and database requirements which is what this is all about.
Why Was PostgreStats Developed?
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.
How Exactly Does it Work?
PostgreStats and Enterprise are simple to set-up and fully automate. Below is a quick read on how each are set-up:
| • |
PostgreStats
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
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. |
From the Developer:
My name is Joel Detter, PHP / PostgreSQL programmer and lead developer of PostgreStats. I started developing PostgreStats for my own company's (NWLYNX) use when Postgres was at version 7.4. I went years without knowing exactly what was going on behind the scenes of my Postgres implementation and viewing website statistics is not a valid indication of database activity, as you know. I was introduced to several great Linux/Unix based shell techniques and quickly learned to monitor PostgreSQL activity which gave me some insight as to performance, but I wanted to see more stats and on new levels.
The first time I turned on the Stat Collector Process in PostgreSQL, I was astonished to see such detailed statistics available but to me, unless I could break down this data further, tallying numbers in the stat views was not quite meaningless. I wanted to view online all of the databases in my implementation, individual and detailed stats for each one with options for breaking down data in time intervals, comparing data from previous days, months, side-by-side, etc.
When I saw for the first time what PostgreStats revealed about my databases, I was quite literally shocked. Since then, I've used this data to help me understand PostgreSQL performance on my network and have re-written queries and complete systems because of that. From my years of research, I knew many other PostgreSQL users and developers would also love to see statistics in this format, as a great supplemental tool for monitoring performance of Postgres Databases and viewing stat collector statistics. |
Features:
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
- Index Scans + Rows Used
PostgreStats Features:
• Optional Email Snapshot Reports
• Optional CSS Customization
• Optional Standard Apache Security
• Optional Local Log Back-up
• Optional Vacuum Analyze on Update
• Optional FTP to Webserver
Enterprise Features:
• Multi-server Support
• Full Online GUI Administration
• Stat Pausing
• Replication Mode
• Data-aware Navigations
• Finer Control of Stat Viewing
|
|
