Re: Best Prometheus exporter?

[Vijaykumar Jain <vijaykumarjain.github@xxxxxxxxx>]

On Tue, 9 Nov 2021 at 00:19, Victor Sudakov <vas@xxxxxxxxxx> wrote:

What good Prometheus exporter for Postgres can you recommend (from your own experience)?

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)

prometheus-community/postgres_exporter: A PostgreSQL metric exporter for Prometheus (github.com)

should be a good start.

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

and alerting queries for this exporter

Awesome Prometheus alerts | Collection of alerting rules (grep.to)

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

the below utils are also very much handy.

NikolayS/postgres_dba: The missing set of useful tools for Postgres DBAs and all engineers (github.com)

dataegret/pg-utils: Useful PostgreSQL utilities (github.com)

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.

pgBadger Documentation (darold.net)

 

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