Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mkK44-0005Mn-BS for pgsql-admin@arkaria.postgresql.org; Tue, 09 Nov 2021 05:53:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mkK43-0001yI-14 for pgsql-admin@arkaria.postgresql.org; Tue, 09 Nov 2021 05:52:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mkK42-0001y3-Md for pgsql-admin@lists.postgresql.org; Tue, 09 Nov 2021 05:52:58 +0000 Received: from out20-147.mail.aliyun.com ([115.124.20.147]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mkK3r-0006uW-Nm for pgsql-admin@lists.postgresql.org; Tue, 09 Nov 2021 05:52:57 +0000 X-Alimail-AntiSpam: AC=CONTINUE;BC=0.2665589|-1;BR=01201311R301S67rulernew998_84748_2000303;CH=blue;DM=|CONTINUE|false|;DS=CONTINUE|ham_news_journal|0.0156274-0.00020828-0.984164;FP=0|0|0|0|0|-1|-1|-1;HT=ay29a033018047187;MF=rh@vonng.com;NM=1;PH=DS;RN=2;RT=2;SR=0;TI=SMTPD_---.LprPr8B_1636437159; Received: from smtpclient.apple(mailfrom:rh@vonng.com fp:SMTPD_---.LprPr8B_1636437159) by smtp.aliyun-inc.com(10.194.97.171); Tue, 09 Nov 2021 13:52:40 +0800 From: Ruohang Feng Message-Id: <8D5F0EAA-6C4F-4808-9633-5BC5DC33CB72@vonng.com> Content-Type: multipart/alternative; boundary="Apple-Mail=_9A6406C9-AA92-4AB7-9645-C2B7643AE244" Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.120.0.1.13\)) Subject: Re: Best Prometheus exporter? Date: Tue, 9 Nov 2021 13:52:39 +0800 In-Reply-To: Cc: pgsql-admin@lists.postgresql.org To: Victor Sudakov References: X-Mailer: Apple Mail (2.3654.120.0.1.13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_9A6406C9-AA92-4AB7-9645-C2B7643AE244 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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: =20 https://github.com/Vonng/pigsty https://pigsty.cc Dashboards screenshots: = https://github.com/Vonng/pigsty/raw/master/docs/_media/overview-monitor.jp= g=20 > 2021=E5=B9=B411=E6=9C=889=E6=97=A5 02:49=EF=BC=8CVictor Sudakov = =E5=86=99=E9=81=93=EF=BC=9A >=20 > Dear Colleagues, >=20 > What good Prometheus exporter for Postgres can you recommend (from = your own experience)? >=20 > --=20 > Victor Sudakov VAS4-RIPE > http://vas.tomsk.ru/ > 2:5005/49@fidonet >=20 --Apple-Mail=_9A6406C9-AA92-4AB7-9645-C2B7643AE244 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
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


Dashboards screenshots: https://github.com/Vonng/pigsty/raw/master/docs/_media/overview= -monitor.jpg 



2021=E5=B9=B411=E6=9C=889=E6=97=A5 02:49=EF=BC=8CVictor = Sudakov <vas@sibptus.ru> =E5=86=99=E9=81=93=EF=BC=9A

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


= --Apple-Mail=_9A6406C9-AA92-4AB7-9645-C2B7643AE244--