From: Victor Sudakov <vas@sibptus.ru>
To: pgsql-admin@lists.postgresql.org
Cc: Ruohang Feng <rh@vonng.com>
Subject: Re: Best Prometheus exporter?
Date: Tue, 9 Nov 2021 09:55:41 +0000
Message-ID: <YYpFnXz/4T8UUd9B@admin.sibptus.ru> (raw)
In-Reply-To: <8D5F0EAA-6C4F-4808-9633-5BC5DC33CB72@vonng.com>
References: <YYlxLJ8FjMyXjyoo@admin.sibptus.ru>
<8D5F0EAA-6C4F-4808-9633-5BC5DC33CB72@vonng.com>
Hello Ruohang!
I've installed pg_exporter (very simple setup) and indeed I'm
impressed. All the metrics are customizable and the default set of
metrics in the stock config is impressive.
You are the author so can I ask a few questions?
1. Are you providing an official docker image, or a single binary I
could just ADD to a docker image, without the additional RUN steps for
curl'ing and unpacking? An official docker image would be best of
course.
2. I don't think I'm presently going to use the whole of Pigsty, we
are already using some in-house scripts over Patroni, but a collection
of Grafana dashboards using the pg_exporter metrics is something I'd
love having. Is it possible to get them separately from Pigsty?
The exporter itsef is grand!
Ruohang Feng wrote:
> I would recommend https://github.com/Vonng/pg_exporter for some reasons:
>
> Support both Postgres & Pgbouncer
> Flexible: Almost all metrics are defined in customizable configuration files in SQL style.
> Fine-grained execution control: Tags Filter, Facts Filter, Version Filter, Timeout, Cache, etc..
> Dynamic Planning: you could define multiple branches for a collecto. Queries matches server version & fact & tags will be actually executed.
> Configurable caching policy & query timeout
> Rich metrics about pg_exporter itself.
> Auto discovery multi-database in the same instance
> Tested and verified in real world production environment for 3+ years (200+ Nodes)
>
>
> The most important part is: it has a complete solution for monitoring & dashboards:
>
> https://github.com/Vonng/pigsty
> https://pigsty.cc <https://pigsty.cc/;
>
>
> Dashboards screenshots: https://github.com/Vonng/pigsty/raw/master/docs/_media/overview-monitor.jpg
>
>
>
> > 2021年11月9日 02:49，Victor Sudakov <vas@sibptus.ru> 写道：
> >
> > Dear Colleagues,
> >
> > What good Prometheus exporter for Postgres can you recommend (from your own experience)?
> >
> > --
> > Victor Sudakov VAS4-RIPE
> > http://vas.tomsk.ru/
> > 2:5005/49@fidonet
> >
>
--
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, rh@vonng.com
Subject: Re: Best Prometheus exporter?
In-Reply-To: <YYpFnXz/4T8UUd9B@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