PostgreSQL
Metrics
You can go to this dashboard and select Instance
.
We run exporter for the first 5 nodes, that should be enough to debug performance issues.
Data sources and raw queries
You can use PostgreSQL X
datasources, first 5 nodes to select things for your dashboards or debug.
Slow queries debug
Use pg_stat_statements
extension, it is enabled for all databases in NodeSet
select * from pg_stat_statements;