From: Ruohang Feng <rh@vonng.com>
To: Victor Sudakov <vas@sibptus.ru>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Best Prometheus exporter?
Date: Tue, 9 Nov 2021 13:52:39 +0800
Message-ID: <8D5F0EAA-6C4F-4808-9633-5BC5DC33CB72@vonng.com> (raw)
In-Reply-To: <YYlxLJ8FjMyXjyoo@admin.sibptus.ru>
References: <YYlxLJ8FjMyXjyoo@admin.sibptus.ru>
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/pigstyhttps://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
>
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: rh@vonng.com, vas@sibptus.ru, pgsql-admin@lists.postgresql.org
Subject: Re: Best Prometheus exporter?
In-Reply-To: <8D5F0EAA-6C4F-4808-9633-5BC5DC33CB72@vonng.com>
* 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