Re: Best Prometheus exporter? - Mailing list pgsql-admin

I have not got a lot of exposure with prometheus, but was able to quickly set up using below,

but I was aware of monitoring and alerting otherwise , so it was easy. the below were combined with node_exporter (specially storage io metrics)

should be a good start.

PostgreSQL Database dashboard for Grafana | Grafana Labs would be the corresponding grafana dashboard.

and alerting queries for this exporter

these are very basics to start with, feel free to improvise.

the below utils are also very much handy.

pg_stat_monitor/USER_GUIDE.md at master · percona/pg_stat_monitor (github.com)  (new but i like the option to check query plan via sql query)

and the most important wrt logs.

 

I shared much more than asked, feel free to discard what is not needed.