Here are the vRealize Hyperic metrics that are available for vPostgreSQL 9.x database service metrics.

Log Track Supported: No

Config Track Supported: No

Custom Properties Supported: None

Supported Control Actions: Analyze, Vacuum, VacuumAnalyze, Reindex

Table 1. Supported Metrics

Name

Alias

Category

Units

Default On

Default Interval

Availability

Availability

percent

AVAILABILITY

true

10 min

Connections

numbackends

none

UTILIZATION

true

5 min Connections Idle

Connections Idle

idle_backends

none

UTILIZATION

false

5 min

Connections Usage

connections_usage

percent

UTILIZATION

true

5 min

Commits

xact_commit

none

THROUGHPUT

false

10 min

Commits per Second

xact_commit1s

none

THROUGHPUT

true

10 min

Rollbacks

xact_rollback

none

THROUGHPUT

false

10 min

Rollbacks per Second

xact_rollback1s

none

THROUGHPUT

true

10 min

Buffer Read

blks_read

none

THROUGHPUT

false

10 min

Buffer Read per Second

blks_read1m

none

THROUGHPUT

true

10 min

Buffer Hits

blks_hit

none

THROUGHPUT

false

10 min

Buffer Hits per Second

blks_hit1m

none

THROUGHPUT

false

10 min

Buffer Hits %

blks_hit_p

percent

THROUGHPUT

true

5 min

Rows Read

tup_fetched

none

THROUGHPUT

false

10 min

Rows Read per Second

tup_fetched1s

none

THROUGHPUT

true

10 min

Rows Write

tup_altered

none

THROUGHPUT

false

10 min

Rows Write per Second

tup_altered1s

none

THROUGHPUT

true

10 min

Locks Held

granted_locks

none

UTILIZATION

true

5 min

Locks Awaited

awaited_locks

none

UTILIZATION

false

5 min

Indexes Scans

idx_scan

none

UTILIZATION

false

10 min

Indexes Scans per Minute

idx_scan1m

none

UTILIZATION

false

10 min

Indexes Reads

idx_tup_read

none

UTILIZATION

false

10 min

Indexes Reads per Minute

idx_tup_read1m

none

UTILIZATION

true

10 min

Indexes Scan Rows Read

idx_tup_fetch

none

UTILIZATION

false

10 min

Indexes Scan Rows Read per Minute

idx_tup_fetch1m

none

UTILIZATION

false

10 min

Indexes Blocks Reads

idx_blks_read

none

UTILIZATION

false

10 min

Indexes Blocks Reads per Minute

idx_blks_read1m

none

UTILIZATION

true

10 min

Indexes Blocks Hit

idx_blks_hit

none

UTILIZATION

false

10 min

Indexes Blocks Hit per Minute

idx_blks_hit1m

none

UTILIZATION

false

10 min

Tables Sequential Scans

seq_scan

none

UTILIZATION

false

10 min

Tables Sequential Scans per Minute

seq_scan1m

none

UTILIZATION

true

10 min

Tables Sequential Scan Rows Read

seq_tup_read

none

UTILIZATION

false

10 min

Tables Sequential Scan Rows Read per Minute

seq_tup_read1m

none

UTILIZATION

false

10 min

Database Size

DatabaseSize

B

UTILIZATION

false

5 min

Data Space Used

DataSpaceUsed

KB

UTILIZATION

true

5 min

Index Space Used

IndexSpaceUsed

KB

UTILIZATION

false

5 min