PostgreSQL

Setup
To enable PostgreSQL for the Prometheus metrics you can use the Prometheus exporter for PostgreSQL Here​
You can enable exporter using docker to a running PostgreSQL DB instance with the following command
1docker run \ 2 --net=host \ 3 -e DATA_SOURCE_NAME="postgresql://postgres:password@localhost:5432/postgres?sslmode=disable" \ 4 quay.io/prometheuscommunity/postgres-exporter
Once it is attached to the DB instance check your Prometheus for the following metrics to verify it is attached properly
pg_stat_database_numbackends
pg_stat_database_xact_commit
Metrics
Requests & Errors
Metric
Key Performance Indicator (KPI)
Requests
pg_stat_database_xact_commit
pg_stat_database_xact_rollback
pg_stat_database_blks_read
Request Rate
rate(pg_stat_database_xact_commit[5m])
rate(pg_stat_database_xact_rollback[5m])
rate(pg_stat_database_blks_read[5m])
Errors
pg_stat_database_conflicts
Error Ratio
rate(pg_stat_database_conflicts[5m])/ rate(pg_stat_database_xact_commit[5m])
Latency
pg_stat_database_blks_hit + pg_stat_database_blks_read
Latency Average
rate(pg_stat_database_blks_hit + pg_stat_database_blks_read[5m])/ rate(pg_stat_database_blk_read_time[5m])
Resource
Metric
Key Performance Indicator (KPI)
Connections
pg_stat_database_numbackends
Connections Usage
avg_over_time(pg_stat_database_numbackends[5m)
Connection usage against limit
pg_stat_database_numbackends / pg_settings_max_connections
Database Disk Usage
pg_database_size_bytes
 
Database disk usage limit
predict_linear(pg_database_size_bytes[1h])
Alerts
KPI
Alert
​
​
Request Rate
RequestRateAnomaly
Error Ratio
ErrorRatioBreach and ErrorBuildup based on an availability SLO of 99.9
Latency Average
LatencyAverageBreach and LatencyAverageAnomaly
Database Disk Usage
ResourceMayExhaust
Connections
ResourceRateAnomaly and Saturation with severity level of warning and critical when memory utilization exceeds 80% and 90% respectively
Failure Alerts
PostgresIsDown
Postgresql is not running
pg_up != 1
PostgresGotRestarted
Postgresql server restarted
time() - pg_postmaster_start_time_seconds < 60
PostgresHasHighDeadLocks
Postgresql is having too many deadlocks
rate(pg_stat_database_deadlocks[1m]) * 60 > 5
PostgresHasExporterErrors
Exporter is not running properly
pg_exporter_last_scrape_error > 0
Dashboards
Following dashboard will show key metrics like
Uptime
Transactions
Active Session
Max Connection
You can configure the following Dashboard as a custom dashboard in case you would like to get very detailed information for each PostgreSQL Prometheus metric.

MySQL

Redis

Last modified 1yr ago

Metric	Key Performance Indicator (KPI)
Requests `pg_stat_database_xact_commit` `pg_stat_database_xact_rollback` `pg_stat_database_blks_read`	Request Rate `rate(pg_stat_database_xact_commit[5m])` `rate(pg_stat_database_xact_rollback[5m])` `rate(pg_stat_database_blks_read[5m])`
Errors `pg_stat_database_conflicts`	Error Ratio `rate(pg_stat_database_conflicts[5m])`/ `rate(pg_stat_database_xact_commit[5m])`
Latency `pg_stat_database_blks_hit + pg_stat_database_blks_read`	Latency Average `rate(pg_stat_database_blks_hit + pg_stat_database_blks_read[5m])`/ `rate(pg_stat_database_blk_read_time[5m])`

Metric	Key Performance Indicator (KPI)
Connections `pg_stat_database_numbackends`	Connections Usage `avg_over_time(pg_stat_database_numbackends[5m)` Connection usage against limit `pg_stat_database_numbackends` / `pg_settings_max_connections`
Database Disk Usage `pg_database_size_bytes`	Database disk usage limit `predict_linear(pg_database_size_bytes[1h])`

KPI	Alert

Request Rate	RequestRateAnomaly
Error Ratio	ErrorRatioBreach and ErrorBuildup based on an availability SLO of `99.9`
Latency Average	LatencyAverageBreach and LatencyAverageAnomaly
Database Disk Usage	ResourceMayExhaust
Connections	ResourceRateAnomaly and Saturation with severity level of warning and critical when memory utilization exceeds 80% and 90% respectively