PostgreSQL

Metrics are collected for the PostgreSQL application service.

Table 1. PostgreSQL

Metric Name	Category	KPI
Buffers|Buffers Allocated	PostgreSQL	False
Buffers|Buffers Written by Backend	PostgreSQL	True
Buffers|Buffers Written by Background Writer	PostgreSQL	True
Buffers|Buffers Written During Checkpoints	PostgreSQL	True
Buffers|fsync Call Executed by Backend	PostgreSQL	False
Checkpoints|Checkpoints sync time	PostgreSQL	False
Checkpoints|Checkpoints write time	PostgreSQL	False
Checkpoints|Requested checkpoints performed count	PostgreSQL	False
Checkpoints|Scheduled checkpoints performed count	PostgreSQL	False
Clean scan stopped count	PostgreSQL	False
Application Availability	PostgreSQL	False
Disk Blocks|Blocks Cache Hits	PostgreSQL Database	False
Disk Blocks|Blocks Read	PostgreSQL Database	False
Disk Blocks|Blocks Read Time	PostgreSQL Database	False
Disk Blocks|Blocks Write Time	PostgreSQL Database	False
Statistics|Backends Connected	PostgreSQL Database	False
Statistics|Data Written by Queries	PostgreSQL Database	True
Statistics|Deadlocks Detected	PostgreSQL Database	True
Statistics|Queries Cancelled	PostgreSQL Database	True
Statistics|Temp Files Created by Queries	PostgreSQL Database	False
Transactions|Transactions Committed	PostgreSQL Database	True
Transactions|Transactions Rolled Back	PostgreSQL Database	True
Tuples|Tuples Deleted	PostgreSQL Database	True
Tuples|Tuples Fetched	PostgreSQL Database	True
Tuples|Tuples Inserted	PostgreSQL Database	True
Tuples|Tuples Returned	PostgreSQL Database	True
Tuples|Tuples Updated	PostgreSQL Database	True