PostgreSQL 8.1 server
PostgreSQL 8.1 server
Log Track Supported: No
Config Track Supported: No
Custom Properties Supported:
| Name | Description |
|---|---|
| version | PostgreSQL Version |
Supported Control Actions: Analyze,ResetStatistics,Vacuum,VacuumAnalyze
Supported Metrics:
| Name | Alias | Units | Category | Default On | Default Interval |
|---|---|---|---|---|---|
| Availability | Availability | percentage | AVAILABILITY | true | 5 min |
| Backends | NumBackends | none | UTILIZATION | true | 5 min |
| Locks Held | LocksHeld | none | UTILIZATION | false | 5 min |
| Data Space Used | DataSpaceUsed | KB | UTILIZATION | true | 5 min |
| Index Space Used | IndexSpaceUsed | KB | UTILIZATION | false | 5 min |
| Commits | Commits | none | THROUGHPUT | true | 10 min |
| Commits per Minute | Commits1m | none | THROUGHPUT | true | 10 min |
| Rollbacks | Rollbacks | none | THROUGHPUT | false | 10 min |
| Rollbacks per Minute | Rollbacks1m | none | THROUGHPUT | false | 10 min |
| Blocks Read | BlocksRead | none | THROUGHPUT | true | 10 min |
| Blocks Read per Minute | BlocksRead1m | none | THROUGHPUT | true | 10 min |
| Buffer Hits | BufferHits | none | THROUGHPUT | false | 10 min |
| Buffer Hits per Minute | BufferHits1m | none | THROUGHPUT | false | 10 min |
Configuration help:
Configure PostgreSQL 8.1 for Monitoring
Monitoring of PostgreSQL is done through the statistics collector. For PostgreSQL to collect these metrics, they must be enabled by modifying the statistics parameters in postgresql.conf.
The parameters required for monitoring are as follows:
- stats_start_collector = true
- stats_block_level = true
- stats_row_level = true
An optional setting is to set stats_reset_on_server_start = false so that a database restart will not cause gaps in the monitoring data.
Make sure to restart PostgreSQL after making the changes to postgresql.conf.
Also note that some metrics like 'Index Space Used' and 'Database Space Used' will only be incremented after vacuum or analyze is run.
For more information see the PostgreSQL Documentation