From: Victor Sudakov <vas@sibptus.ru>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Cc: Vijaykumar Jain <vijaykumarjain.github@gmail.com>
Subject: Re: Best Prometheus exporter?
Date: Tue, 9 Nov 2021 10:31:14 +0000
Message-ID: <YYpN8pacFwfe7WYD@admin.sibptus.ru> (raw)
In-Reply-To: <CAM+6J97OOsdPh=vL-YRF-pf0hF7Je=5dpdFHkyb_k_59Tbm=1g@mail.gmail.com>
References: <YYlxLJ8FjMyXjyoo@admin.sibptus.ru>
<CAM+6J97OOsdPh=vL-YRF-pf0hF7Je=5dpdFHkyb_k_59Tbm=1g@mail.gmail.com>
Hello Vijaykumar!
Thank you for your useful links. I've just installed
prometheus-community/postgres_exporter and it is working. It is
also useful that it comes with a ready Grafana dashboard. I've installed
Grafana dashboard "9628" and found it not very useful (in comparison
e.g. with the standard Zabbix PostgreSQL template), but maybe I've not
invested enough time studying it.
I have not looked at the alerter yet.
Vijaykumar Jain wrote:
> On Tue, 9 Nov 2021 at 00:19, Victor Sudakov <vas@sibptus.ru> 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)
> <https://github.com/prometheus-community/postgres_exporter;
> should be a good start.
> PostgreSQL Database dashboard for Grafana | Grafana Labs
> <https://grafana.com/grafana/dashboards/9628; would be the corresponding
> grafana dashboard.
>
> and alerting queries for this exporter
> Awesome Prometheus alerts | Collection of alerting rules (grep.to)
> <https://awesome-prometheus-alerts.grep.to/rules.html#postgresql-1;
>
> 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) <https://github.com/NikolayS/postgres_dba;
> dataegret/pg-utils: Useful PostgreSQL utilities (github.com)
> <https://github.com/dataegret/pg-utils;
> pg_stat_monitor/USER_GUIDE.md at master ยท percona/pg_stat_monitor
> (github.com)
> <https://github.com/percona/pg_stat_monitor/blob/master/docs/USER_GUIDE.md;
> (new but i like the option to check query plan via sql query)
>
> <https://github.com/prometheus-community/postgres_exporter>and the most
> important wrt logs.
> pgBadger Documentation (darold.net)
> <https://pgbadger.darold.net/documentation.html;
> <https://pgbadger.darold.net/documentation.html;
> I shared much more than asked, feel free to discard what is not needed.
--
Victor Sudakov VAS4-RIPE
http://vas.tomsk.ru/
2:5005/49@fidonet
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: vas@sibptus.ru, pgsql-admin@lists.postgresql.org, vijaykumarjain.github@gmail.com
Subject: Re: Best Prometheus exporter?
In-Reply-To: <YYpN8pacFwfe7WYD@admin.sibptus.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox