A division of VMware
Spring Source - Hyperic | Build, Run, Manage

PostgreSQL Monitoring & Management

PostgreSQL is a highly-scalable, open source object-relational database management system. With more than 15 years of development history, it is quickly becoming the de facto database for enterprise level open source solutions.

Because Hyperic HQ uses PostgreSQL 8.0 as its built in database backend, we have aimed to provide the deepest, most comprehensive PostgreSQL monitoring available in any management solution.

Hyperic HQ allows discreet management of both the server engine as well as every individual table in the system, thereby providing not only a vast assortment of metrics, but also control capabilities commonly associated with PostgreSQL monitoring and management such as vacuum, analyze, and vacuum full analyze. Performing these management tasks on an automated basis through HQ's integrated control infrastructure allows you to define policies such as reallocating free space through vacuum whenever the rate of deletes per minute on a table exceed a threshold.

Hyperic HQ aims to provide PostgreSQL users the monitoring and management capabilities typically found in database centric tools coupled with management support for the other technologies which, along with databases, are used in today.s enterprise environment. Its powerful application concept allows you to visualize monitoring data from your database tier alongside your business logic and presentation tiers by giving you the ability to measure how client activity is reflected across the various layers of your application infrastructure.

For more information, please visit our PostgreSQL monitoring plugin HyperFORGE page.

Auto-Discover your hardware and PostgreSQL servers
Monitor every metric, log, and configuration for all PostgreSQL resources in your inventory
Identify problem resources with automatic baselines for every metric
Control all your PostgreSQL resources on-demand, on schedule, or in response to alerts
Alert on any measurement, log, or security event in your PostgreSQL environment

System Supported Versions

  • PostgreSQL 7.4
  • PostgreSQL 8.0
  • PostgreSQL 8.1
  • PostgreSQL 8.2
  • PostgreSQL 8.3

System Monitoring Specification

General Server Metrics
  • Availability
  • Backends
  • Locks Held
  • Data Space Used
  • Index Space Used
  • Commits
  • Commits per Minute
  • Rollbacks
  • Rollbacks per Minute
  • Blocks Read
  • Blocks Read per Minute
  • Buffer Hits
  • Buffer Hits per Minute
PostgreSQL 7.4, 8.0, 8.1, 8.2 and 8.3 Index Metrics
  • Availability
  • Index Scans
  • Index Scans per Minute
  • Index Reads
  • Index Reads per Minute
  • Index Fetches
  • Index Fetches per Minute
PostgreSQL 7.4, 8.0, 8.1, 8.2 and 8.3 Table Metrics
  • Availability
  • Sequential Scans
  • Sequential Scans per Minute
  • Index Scans
  • Index Scans per Minute
  • Sequential Scan Rows Read
  • Sequential Scan Rows Read per Minute
  • Index Scan Rows Read
  • Index Scan Rows Read per Minute
  • Data Space Used
  • Index Space Used
  • Number Of Row Inserts
  • Number Of Row Inserts per Minute
  • Number Of Row Updates
  • Number Of Row Updates per Minute
  • Number Of Row Deletes
  • Number Of Row Deletes per Minute

Postgresql Control Specification

Control Actions
  • Analyze
  • ResetStatistics
  • Vacuum
  • VacuumAnalyze
  • Reindex