Products Overview

HQ Enterprise

Benefits

Documentation

Case Studies

Datasheets

PostgreSQL Management Support

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 management of PostgreSQL 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 metrics, but also control capabilities commonly associated with PostgreSQL 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 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.

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

PostgreSQL Supported Versions

PostgreSQL 7.4
PostgreSQL 8.0
PostgreSQL 8.1
PostgreSQL 8.2

PostgreSQL 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 and 8.2 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 and 8.2 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

Technologies Managed

Operating Systems | Web Servers | Application Servers | Databases | Messaging Middleware | Microsoft Technology | Virtualization |
Mail Servers | Other Technologies | Application Platforms