Verax NMS PostgreSQL management plugin enables easy monitoring, alerting, health check, management and performance reporting for PostgreSQL servers and databases.
Verax NMS plugin supports multiple instances of PostgreSQL 8.1 and higher running in 32 and 64 bit environments. The communication between Verax NMS and PostgreSQL server(s) takes place via SQL queries (no management agent is required on PostgreSQL server).
The view presents general server and database information such as:
The view displays a list of all current server and database configuration parameters.
The view displays a list of all database tables including name, size, average row length and expected vs. real pages used. It also provides a graphical presentation of the most fragmented tables which require optimization.
The view displays a list of processes currently accessing the database providing the following information:
PostgreSQL Vacuum is a background daemon for reclaiming unused storage (occupied by deleted records). The Vacuum view provides the following information, essential for optimizing database performance:
The view provides comprehensive statistics on database memory including:
Provides statistics for identifying database performance bottlenecks including:
Provides a comprehensive summary of top transactions for each database on the server including:
The diagnostics report allows troubleshooting database performance. The report presents the following information:
The plugin provides predefined templates for most commonly monitored PostgreSQL items (listed in the table below). Other, user-defined sensors and performance counters can be added.
|PostgreSQL monitoring templates|
|PostgreSQL Database tables number|
|PostgreSQL Number of commits|
|PostgreSQL Logged users number|
|PostgreSQL Number of rollbacks|
|PostgreSQL Blocks read|
|PostgreSQL Disk block fetch requests found in cache number|
|PostgreSQL Number of tuples updated|
|PostgreSQL Number of tuples deleted|
|PostgreSQL Buffer hits rate|
|PostgreSQL Active server processes number|
|PostgreSQL Disk block fetch requests number|
|PostgreSQL Number of tuples inserted|