Plugins like this provide extra functionality beyond Pingdom Server Monitor's default monitoring capabilities. This and 90+ other plugins are available via a one-click install in our web interface.
PostgreSQL monitoring
Provides a summary of PostgreSQL cluster query activity.
Overview
Provides a summary of PostgreSQL cluster query activity. The following query statistics are recorded:
- SELECTs (from index) (rows/second)
- SELECTs (from scans) (rows/second)
- INSERTs (rows/second)
- DELETEs (rows/second)
- UPDATEs (rows/second)
- REPLACEs (rows/second)
- Total queries (rows/second)
- Transactions committed (txn/second)
- Transactions rolled back (txn/second)
- Total transactions (txn/second)
- Blocks read from disk (blocks/second)
- Blocks read from buffer cache (blocks/second)
- Buffer cache hit rate (%)
- Number of active backends
Dependencies
Requires the pg library
gem install pg
Enabling Statistics Collection
Statistics collection must be enabled for this plugin to report data. See our help entry for instructions.
Author
Created by Robert Coup of Koordinates
