Skip to content

Add metrics to measure XID And XLOG generation and track replication XLOG consumption

Gregory Stark requested to merge postgres-uptime into master

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

Merge request reports