PostgreSQL 8.3 server

PostgreSQL 8.3 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

false

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

false

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.3 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