PostgreSQL Patroni
3,231

Created 6/3/2023
Updated 6/3/2023
Revision 1
Categories
Databases
Grafana Version >=9.2.13
Datasources
Prometheus

This is a dashboard to view metrics exported by the Patroni /metrics endpoint available since v2.1.0: https://patroni.readthedocs.io/en/latest/releases.html#version-2-1-0

To add the metrics to PMM, simply go to the PMM client and execute a command like the following: pmm-admin add external --listen-port=8008 --service-name=pg-node1-patroni

Both Patroni and PMM client need to be running in the same node.

Get Dashboard
Download
Copy to Clipboard
Source Grafana.com

Used Metrics 16

  • patroni_version

  • patroni_dcs_last_seen

  • patroni_primary

  • patroni_replica

  • patroni_standby_leader

  • patroni_is_paused

  • patroni_postgres_server_version

  • patroni_postmaster_start_time

  • patroni_postgres_running

  • patroni_postgres_timeline

  • patroni_pending_restart

  • patroni_xlog_paused

  • patroni_sync_standby

  • patroni_xlog_location

  • patroni_xlog_received_location

  • patroni_xlog_replayed_location