Best open source monitoring tools for PostgreSQL?

pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed

Best open source monitoring tools for PostgreSQL?
7+ messages / 7 participants
[nested] [flat]

* Best open source monitoring tools for PostgreSQL?
@ 2022-10-14 15:44 Sbob <sbob@quadratum-braccas.com>
  2022-10-14 16:10 ` Re: Best open source monitoring tools for PostgreSQL? Mani Sankar <manisankar01695@gmail.com>
  2022-10-15 00:13 ` Re: Best open source monitoring tools for PostgreSQL? Edward J. Sabol <edwardjsabol@gmail.com>
  0 siblings, 2 replies; 7+ messages in thread

From: Sbob @ 2022-10-14 15:44 UTC (permalink / raw)
  To: Pgsql-admin <pgsql-admin@lists.postgresql.org>

All;

I'm wanting to find a good open source monitoring & alerting tool for 
PostgreSQL, it needs to have near real time alerting so tools like PG 
Badger / PGCLUU are out.  What are you all using?

Thanks in advance for any suggestions

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Best open source monitoring tools for PostgreSQL?
  2022-10-14 15:44 Best open source monitoring tools for PostgreSQL? Sbob <sbob@quadratum-braccas.com>
@ 2022-10-14 16:10 ` Mani Sankar <manisankar01695@gmail.com>
  2022-10-14 16:19   ` Re: Best open source monitoring tools for PostgreSQL? Evan Bauer <evanbauer@mac.com>
  2022-10-14 16:23   ` Re: Best open source monitoring tools for PostgreSQL? Keith Fiske <keith.fiske@crunchydata.com>
  2022-10-14 16:25   ` Re: Best open source monitoring tools for PostgreSQL? Tomasz Sroka <tomasz.sroka@gmail.com>
  1 sibling, 3 replies; 7+ messages in thread

From: Mani Sankar @ 2022-10-14 16:10 UTC (permalink / raw)
  To: Sbob <sbob@quadratum-braccas.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>

Hi Sbob,

Maybe you can check tools like grafana, nagios, postgres_check, PMM etc.

Regards,
Mani.

On Fri, Oct 14, 2022 at 7:44 PM Sbob <sbob@quadratum-braccas.com> wrote:

> All;
>
>
> I'm wanting to find a good open source monitoring & alerting tool for
> PostgreSQL, it needs to have near real time alerting so tools like PG
> Badger / PGCLUU are out.  What are you all using?
>
>
> Thanks in advance for any suggestions
>
>
>
>
>
>

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Best open source monitoring tools for PostgreSQL?
  2022-10-14 15:44 Best open source monitoring tools for PostgreSQL? Sbob <sbob@quadratum-braccas.com>
  2022-10-14 16:10 ` Re: Best open source monitoring tools for PostgreSQL? Mani Sankar <manisankar01695@gmail.com>
@ 2022-10-14 16:19   ` Evan Bauer <evanbauer@mac.com>
  2 siblings, 0 replies; 7+ messages in thread

From: Evan Bauer @ 2022-10-14 16:19 UTC (permalink / raw)
  To: Mani Sankar <manisankar01695@gmail.com>; +Cc: Sbob <sbob@quadratum-braccas.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>


--Apple-Mail-F7C2FA92-462E-4051-94EE-5AFF87C0D1AD
Content-Type: multipart/related;
	type="text/html";
	boundary=Apple-Mail-F7A335C4-35AE-4680-97A0-33FF4505D60D
Content-Transfer-Encoding: 7bit


--Apple-Mail-F7A335C4-35AE-4680-97A0-33FF4505D60D
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto">Snob,<div><br></div><div>Zabbix is an optio=
n worth looking at as well. &nbsp;PostgreSQL capability is good and you can u=
se it to monitor the rest of your stack as well.&nbsp;</div><div><div style=3D=
"display: block;" class=3D""><div style=3D"-webkit-user-select: all; -webkit=
-user-drag: element; display: inline-block;" class=3D"apple-rich-link" dragg=
able=3D"true" role=3D"link" data-url=3D"https://www.zabbix.com/integrations/=
postgresql"><a style=3D"border-radius:10px;font-family:-apple-system, Helvet=
ica, Arial, sans-serif;display:block;-webkit-user-select:none;width:300px;us=
er-select:none;-webkit-user-modify:read-only;user-modify:read-only;overflow:=
hidden;text-decoration:none;" class=3D"lp-rich-link" rel=3D"nofollow" href=3D=
"https://www.zabbix.com/integrations/postgresql"; dir=3D"ltr" role=3D"button"=
 draggable=3D"false" width=3D"300"><table style=3D"table-layout:fixed;border=
-collapse:collapse;width:300px;background-color:#E9E9EB;font-family:-apple-s=
ystem, Helvetica, Arial, sans-serif;" class=3D"lp-rich-link-emailBaseTable" c=
ellpadding=3D"0" cellspacing=3D"0" border=3D"0" width=3D"300"><tbody><tr><td=
 vertical-align=3D"center"><table bgcolor=3D"#E9E9EB" cellpadding=3D"0" cell=
spacing=3D"0" width=3D"300" style=3D"font-family:-apple-system, Helvetica, A=
rial, sans-serif;table-layout:fixed;background-color:rgba(233, 233, 235, 1);=
" class=3D"lp-rich-link-captionBar"><tbody><tr><td style=3D"padding:8px 0px 8=
px 0px;" class=3D"lp-rich-link-captionBar-textStackItem"><div style=3D"max-w=
idth:100%;margin:0px 16px 0px 16px;overflow:hidden;" class=3D"lp-rich-link-c=
aptionBar-textStack"><div style=3D"word-wrap:break-word;font-weight:500;font=
-size:12px;overflow:hidden;text-overflow:ellipsis;text-align:left;" class=3D=
"lp-rich-link-captionBar-textStack-topCaption-leading"><a rel=3D"nofollow" h=
ref=3D"https://www.zabbix.com/integrations/postgresql"; style=3D"text-decorat=
ion: none" draggable=3D"false"><font color=3D"#000000" style=3D"color: rgba(=
0, 0, 0, 1);">Postgresql monitoring and integration with Zabbix</font></a></=
div><div style=3D"word-wrap:break-word;font-weight:400;font-size:11px;overfl=
ow:hidden;text-overflow:ellipsis;text-align:left;" class=3D"lp-rich-link-cap=
tionBar-textStack-bottomCaption-leading"><a rel=3D"nofollow" href=3D"https:/=
/www.zabbix.com/integrations/postgresql" style=3D"text-decoration: none" dra=
ggable=3D"false"><font color=3D"#A2A2A9" style=3D"color: rgba(60, 60, 67, 0.=
6);">zabbix.com</font></a></div></div></td><td style=3D"padding:6px 12px 6px=
 0px;" class=3D"lp-rich-link-captionBar-rightIconItem" width=3D"36"><a rel=3D=
"nofollow" href=3D"https://www.zabbix.com/integrations/postgresql"; draggable=
=3D"false"><img style=3D"pointer-events:none !important;display:inline-block=
;width:36px;height:36px;border-radius:3px;" width=3D"36" height=3D"36" dragg=
able=3D"false" class=3D"lp-rich-link-captionBar-rightIcon" alt=3D"apple-touc=
h-icon-180x180-precomposed.png" src=3D"cid:CF747B47-664B-41DF-ABA5-702687F9C=
5B3"></a></td></tr></tbody></table></td></tr></tbody></table></a></div></div=
><div><br></div>Cheers,</div><div><br></div><div>Evan<br><br><div dir=3D"ltr=
">Sent from my iPhone</div><div dir=3D"ltr"><br><blockquote type=3D"cite">On=
 Oct 14, 2022, at 10:11, Mani Sankar &lt;manisankar01695@gmail.com&gt; wrote=
:<br><br></blockquote></div><blockquote type=3D"cite"><div dir=3D"ltr">=EF=BB=
=BF<div dir=3D"ltr">Hi&nbsp;Sbob,<div><br></div><div>Maybe you can check too=
ls like grafana, nagios, postgres_check, PMM etc.</div><div><br></div><div>R=
egards,</div><div>Mani.</div></div><br><div class=3D"gmail_quote"><div dir=3D=
"ltr" class=3D"gmail_attr">On Fri, Oct 14, 2022 at 7:44 PM Sbob &lt;<a href=3D=
"mailto:sbob@quadratum-braccas.com">sbob@quadratum-braccas.com</a>&gt; wrote=
:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8=
ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">All;<br>
<br>
<br>
I'm wanting to find a good open source monitoring &amp; alerting tool for <b=
r>
PostgreSQL, it needs to have near real time alerting so tools like PG <br>
Badger / PGCLUU are out.&nbsp; What are you all using?<br>
<br>
<br>
Thanks in advance for any suggestions<br>
<br>
<br>
<br>
<br>
<br>
</blockquote></div>
</div></blockquote></div></body></html>=

--Apple-Mail-F7A335C4-35AE-4680-97A0-33FF4505D60D
Content-Type: image/png;
	name=apple-touch-icon-180x180-precomposed.png;
	x-apple-part-url=CF747B47-664B-41DF-ABA5-702687F9C5B3
Content-Disposition: inline;
	filename=apple-touch-icon-180x180-precomposed.png
Content-Transfer-Encoding: base64
Content-Id: <CF747B47-664B-41DF-ABA5-702687F9C5B3>

iVBORw0KGgoAAAANSUhEUgAAALQAAAC0CAMAAAAKE/YAAAAABGdBTUEAAK/INwWK6QAAACBjSFJN
AAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAAM1BMVEXUAADsj4/0v7/////3
z8/87+/cMDDncHDhUFDfQEDvn5/XEBDyr6/qgIDkYGD639/ZICDvCrvkAAAAAWJLR0QDEQxM8gAA
AAd0SU1FB+ICEAkjMCogaJQAAAGkSURBVHja7dxJkoNADERRY2M84IH7n7ZXvctWb4RUSfx3gly4
KjFScDoBAAAAAAAA+Mt03l966PNlf4QmNKEJTWhCE5rQhaHn9NC5T3kq83VJD53qpkLfu1PFHirz
rTtVbLmKzM/uVLF1Vodw7Y4Ve6lDOHjmt/pBD35xfFTmT3eqmDyEU3eq2PoVmfNfHeRyvDiehu0t
D6Fje7+7U8U22ruGbO+tO1WM9q5h+Qjt2N7qj+x38IuD9q6xHKW9X92pYpbtLQ/h1p0qJtv70Z0q
dqe9S8j2zn8LnYv2rmH5CG3Y3ivtXcOxveX4yrG9GV+l04ewO9U/VHuPPr6aaO8Ssr1HH18Ztjfj
qyKO7c3ySQ3L9nZcPlHtzfgqn+Xyico8+viK9q7B6mgNlk+KOLY3yyc1LNvbcflEXRyMr/I5Lp+w
OlrjOO29daeKObY3yyc1LNub5ZMaju3tuHzC6mgRx+UTVkdrHKa9Rx9fObY3yyc1HNvbcflEtvdl
Hvvjc3KGvIPU0BWf2SE0oQlNaEITmtCE/lXxeeFdPjEMAAAAAAAAHMUP6F9A4P9wkecAAAAASUVO
RK5CYII=

--Apple-Mail-F7A335C4-35AE-4680-97A0-33FF4505D60D--

--Apple-Mail-F7C2FA92-462E-4051-94EE-5AFF87C0D1AD--





Attachments:

apple-touch-icon-180x180-precomposed.png (image/png, 632B) download
  view image

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Best open source monitoring tools for PostgreSQL?
  2022-10-14 15:44 Best open source monitoring tools for PostgreSQL? Sbob <sbob@quadratum-braccas.com>
  2022-10-14 16:10 ` Re: Best open source monitoring tools for PostgreSQL? Mani Sankar <manisankar01695@gmail.com>
@ 2022-10-14 16:23   ` Keith Fiske <keith.fiske@crunchydata.com>
  2 siblings, 0 replies; 7+ messages in thread

From: Keith Fiske @ 2022-10-14 16:23 UTC (permalink / raw)
  To: Mani Sankar <manisankar01695@gmail.com>; +Cc: Sbob <sbob@quadratum-braccas.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>

Take a look at pgMonitor. It uses all open source components
(Prometheus/Grafana) and is fully customizable to monitor any part of your
application stack, not just PostgreSQL

https://github.com/CrunchyData/pgmonitor

On Fri, Oct 14, 2022 at 12:10 PM Mani Sankar <manisankar01695@gmail.com>
wrote:

> Hi Sbob,
>
> Maybe you can check tools like grafana, nagios, postgres_check, PMM etc.
>
> Regards,
> Mani.
>
> On Fri, Oct 14, 2022 at 7:44 PM Sbob <sbob@quadratum-braccas.com> wrote:
>
>> All;
>>
>>
>> I'm wanting to find a good open source monitoring & alerting tool for
>> PostgreSQL, it needs to have near real time alerting so tools like PG
>> Badger / PGCLUU are out.  What are you all using?
>>
>>
>> Thanks in advance for any suggestions
>>
>>
>>
>>
>>
>>

-- 
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Best open source monitoring tools for PostgreSQL?
  2022-10-14 15:44 Best open source monitoring tools for PostgreSQL? Sbob <sbob@quadratum-braccas.com>
  2022-10-14 16:10 ` Re: Best open source monitoring tools for PostgreSQL? Mani Sankar <manisankar01695@gmail.com>
@ 2022-10-14 16:25   ` Tomasz Sroka <tomasz.sroka@gmail.com>
  2 siblings, 0 replies; 7+ messages in thread

From: Tomasz Sroka @ 2022-10-14 16:25 UTC (permalink / raw)
  To: Mani Sankar <manisankar01695@gmail.com>; +Cc: Sbob <sbob@quadratum-braccas.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>


--Apple-Mail-3F8B2D3B-17DF-46B1-A354-4B7385A38E09
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto"><div dir=3D"ltr"></div><div dir=3D"ltr">Pgw=
atch2 also looks promising:&nbsp;<a href=3D"https://pgwatch2.readthedocs.io/=
">https://pgwatch2.readthedocs.io/</a></div><div dir=3D"ltr"><br><blockquote=
 type=3D"cite">On 14 Oct 2022, at 18:10, Mani Sankar &lt;manisankar01695@gma=
il.com&gt; wrote:<br><br></blockquote></div><blockquote type=3D"cite"><div d=
ir=3D"ltr">=EF=BB=BF<div dir=3D"ltr">Hi&nbsp;Sbob,<div><br></div><div>Maybe y=
ou can check tools like grafana, nagios, postgres_check, PMM etc.</div><div>=
<br></div><div>Regards,</div><div>Mani.</div></div><br><div class=3D"gmail_q=
uote"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, Oct 14, 2022 at 7:44 PM S=
bob &lt;<a href=3D"mailto:sbob@quadratum-braccas.com">sbob@quadratum-braccas=
.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"marg=
in:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex=
">All;<br>
<br>
<br>
I'm wanting to find a good open source monitoring &amp; alerting tool for <b=
r>
PostgreSQL, it needs to have near real time alerting so tools like PG <br>
Badger / PGCLUU are out.&nbsp; What are you all using?<br>
<br>
<br>
Thanks in advance for any suggestions<br>
<br>
<br>
<br>
<br>
<br>
</blockquote></div>
</div></blockquote></body></html>=

--Apple-Mail-3F8B2D3B-17DF-46B1-A354-4B7385A38E09--





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Best open source monitoring tools for PostgreSQL?
  2022-10-14 15:44 Best open source monitoring tools for PostgreSQL? Sbob <sbob@quadratum-braccas.com>
@ 2022-10-15 00:13 ` Edward J. Sabol <edwardjsabol@gmail.com>
  2022-10-15 01:26   ` Re: Best open source monitoring tools for PostgreSQL? Licio Matos <licio.matos@gmail.com>
  1 sibling, 1 reply; 7+ messages in thread

From: Edward J. Sabol @ 2022-10-15 00:13 UTC (permalink / raw)
  To: Pgsql-admin <pgsql-admin@lists.postgresql.org>

On Oct 14, 2022, at 11:44 AM, Sbob <sbob@quadratum-braccas.com> wrote:
> I'm wanting to find a good open source monitoring & alerting tool for PostgreSQL, it needs to have near real time alerting so tools like PG Badger / PGCLUU are out.  What are you all using?

check_postgres is great if you have a Nagios (or compatible alternative like Icinga) monitoring system. Even if you don't, you could use it with cron pretty easily, I imagine.

https://bucardo.org/check_postgres/
https://github.com/bucardo/check_postgres

Later,
Ed

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Best open source monitoring tools for PostgreSQL?
  2022-10-14 15:44 Best open source monitoring tools for PostgreSQL? Sbob <sbob@quadratum-braccas.com>
  2022-10-15 00:13 ` Re: Best open source monitoring tools for PostgreSQL? Edward J. Sabol <edwardjsabol@gmail.com>
@ 2022-10-15 01:26   ` Licio Matos <licio.matos@gmail.com>
  0 siblings, 0 replies; 7+ messages in thread

From: Licio Matos @ 2022-10-15 01:26 UTC (permalink / raw)
  To: Edward J. Sabol <edwardjsabol@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>

Hi Edward,

Take a look at PMM from percona.

https://www.percona.com/software/database-tools/percona-monitoring-and-management

Em sex., 14 de out. de 2022 às 21:13, Edward J. Sabol <
edwardjsabol@gmail.com> escreveu:

> On Oct 14, 2022, at 11:44 AM, Sbob <sbob@quadratum-braccas.com> wrote:
> > I'm wanting to find a good open source monitoring & alerting tool for
> PostgreSQL, it needs to have near real time alerting so tools like PG
> Badger / PGCLUU are out.  What are you all using?
>
> check_postgres is great if you have a Nagios (or compatible alternative
> like Icinga) monitoring system. Even if you don't, you could use it with
> cron pretty easily, I imagine.
>
> https://bucardo.org/check_postgres/
> https://github.com/bucardo/check_postgres
>
> Later,
> Ed
>
>
>
> --
Licio Matos

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

end of thread, other threads:[~2022-10-15 01:26 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-10-14 15:44 Best open source monitoring tools for PostgreSQL? Sbob <sbob@quadratum-braccas.com>
2022-10-14 16:10 ` Mani Sankar <manisankar01695@gmail.com>
2022-10-14 16:19   ` Evan Bauer <evanbauer@mac.com>
2022-10-14 16:23   ` Keith Fiske <keith.fiske@crunchydata.com>
2022-10-14 16:25   ` Tomasz Sroka <tomasz.sroka@gmail.com>
2022-10-15 00:13 ` Edward J. Sabol <edwardjsabol@gmail.com>
2022-10-15 01:26   ` Licio Matos <licio.matos@gmail.com>

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