Skip to main content

PostgreSQL Performance Metrics

Metric AliasMetric DescriptionUnit
UptimeUptime of this components
VersionPostgreSQL version
RolePostgreSQL role, Master/Slave
AvailabilityPostgreSQL availability, normal/abnormal/unmonitored
CPU UsageProcess CPU usage%
Memory UsedProcess memory usageBytes
Memory UsageProcess memory usage / host total memory%
Disk Throughput (Read)Process disk read throughput per secondBytes/s
Disk Throughput (Write)Process disk write throughput per secondBytes/s
Traffic (Send)Bytes sent per second by PostgreSQLBytes/s
Traffic (Receive)Bytes received per second by PostgreSQLBytes/s
Throughput (QPS)Number of SQL executions per second (CRUD operations)Count/s
Throughput (TPS)Number of transactions per second (commit+rollback)Count/s
Throughput DetailsNumber of insert, delete, update, select, commit, rollback per secondCount/s
Active Connection CountCurrent number of active connections
Active Connection RatioActive connections / max connections%
Connection DetailsAll current connection states in database
Database SizeDatabase size in bytes, by databaseBytes
Temp Table CountNumber of temporary tables per second, by databaseCount/s
Deadlock Interrupted Query CountNumber of queries interrupted by deadlock per secondCount/s
Lock CountNumber of locks generated per secondCount/s
Deadlock CountNumber of deadlocks generated per secondCount/s
Average Response Time (Read)Average read operation durationms
Average Response Time (Write)Average write operation durationms
Buffer Cache Hit RateDatabase buffer cache hit rate%
Index Hit RateDatabase index hit rate%
Toast Table Buffer Cache Hit RateToast table buffer cache hit rate%
Toast Table Index Hit RateToast table index hit rate%
Replication Lag (Logical Replication)Logical replication master-slave lag, lower value means less lagBytes
Replication Lag (Physical Replication)Physical replication master-slave lag, lower value means less lagBytes