PostgreSQL Tuple Statistics (Designed for PMM2)
The PostgreSQL Tuple Statistics Dashboard
This dashboard gives an overview of tuple statistics, table operations, vacuum stats, and database XID age information. Information is obtained by two queries: one over pg_stat_user_tables catalog and the other over pg_database catalog.
These custom queries can be found in https://raw.githubusercontent.com/Percona-Lab/pmm-custom-queries/master/postgresql/pg_tuple_statistics.yaml and should be placed in the /usr/local/percona/pmm2/collectors/custom-queries/postgresql/low-resolution directory.
If you’re using a PMM version older than 2.16.0, use the instructions from the original blogpost: https://www.percona.com/blog/2019/04/08/adding-postgresql-tuple-statistics-dashboard-to-the-pmm-plugin/
Data source config
Collector config:
Dashboard revisions
Upload an updated version of an exported dashboard.json file from Grafana
Revision | Decscription | Created | |
---|---|---|---|
Download |
Get this dashboard
Data source:
Dependencies: