Add metrics to measure XID And XLOG generation and track replication XLOG consumption
Add several new metrics for Postgres monitoring which will be useful to calculate an uptime for our SLA.
- pg_oldest_blocked_age_seconds
- pg_txid_current
- pg_txid_xmin
- pg_txid_xmin_age
- pg_xlog_position_bytes
We want to use rate(pg_xlog_position_bytes)
and possibly combine it with rate(pg_txid_current)
and rate(pg_stat_database_xact_commit)
as an uptime metric.
Edited by Gregory Stark