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 1ojk5C-0005vX-It for pgsql-admin@arkaria.postgresql.org; Sat, 15 Oct 2022 16:32:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ojk5B-0001Pd-EX for pgsql-admin@arkaria.postgresql.org; Sat, 15 Oct 2022 16:32:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ojNPw-0002Xy-Rw for pgsql-admin@lists.postgresql.org; Fri, 14 Oct 2022 16:20:12 +0000 Received: from ms11p00im-qufo17291901.me.com ([17.58.38.48]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ojNPu-0006iM-3J for pgsql-admin@lists.postgresql.org; Fri, 14 Oct 2022 16:20:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mac.com; s=1a1hai; t=1665764406; bh=JMbiBRdKtqjJuAffvoJA/XNvP+34zR8/1FWPuZtFGn0=; h=Content-Type:From:Mime-Version:Subject:Date:Message-Id:To; b=j4TOKsa61kavN/19mdfFrpr+p1dapC671mvRIbZJsb4+1Bg3f8I78CxrA0WmY63tb zJouXYjZUbMtN65/5RLMzZc95AslS6JCcKh0hl9b86/sAgcOh7DhoEYc5/TWncdjAu kfKvdl+/cyoMBvGHQl7OPR41VVy6FAyoGRCnBa68MoUTUDkp+SLNoSzA74ThNvxmic fV8zNj+Ss1PCLwnLRqOHhPEPOgxky5A5GRB36mENUvKu4rSDITfcGlvqqFxoSdSg2E dTi3vh6NbJ1xj8UPa7XK14AC2pnYW9SOuif+Qd5Aahs9Xyx10CbTH+LlvfWEi7oMSX JjOqiawu/Y/9w== Received: from smtpclient.apple (ms11p00im-dlb-asmtpmailmevip.me.com [17.57.154.19]) by ms11p00im-qufo17291901.me.com (Postfix) with ESMTPSA id 646A8BC0661; Fri, 14 Oct 2022 16:20:06 +0000 (UTC) Content-Type: multipart/alternative; boundary=Apple-Mail-F7C2FA92-462E-4051-94EE-5AFF87C0D1AD Content-Transfer-Encoding: 7bit From: Evan Bauer Mime-Version: 1.0 (1.0) Subject: Re: Best open source monitoring tools for PostgreSQL? Date: Fri, 14 Oct 2022 10:19:55 -0600 Message-Id: <0C513889-731A-4E45-BE31-204048D38869@mac.com> References: Cc: Sbob , Pgsql-admin In-Reply-To: To: Mani Sankar X-Mailer: iPhone Mail (20A380) X-Proofpoint-GUID: SzNMu90CNziEyPEec1TYMp3sQ0ll1pak X-Proofpoint-ORIG-GUID: SzNMu90CNziEyPEec1TYMp3sQ0ll1pak X-Proofpoint-Virus-Version: =?UTF-8?Q?vendor=3Dfsecure_engine=3D1.1.170-22c6f66c430a71ce266a39bfe25bc?= =?UTF-8?Q?2903e8d5c8f:6.0.425,18.0.572,17.11.62.513.0000000_definitions?= =?UTF-8?Q?=3D2022-01-14=5F01:2022-01-14=5F01,2020-02-14=5F11,2021-12-02?= =?UTF-8?Q?=5F01_signatures=3D0?= X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 phishscore=0 malwarescore=0 suspectscore=0 mlxlogscore=999 clxscore=1011 bulkscore=0 adultscore=0 mlxscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2209130000 definitions=main-2210140090 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --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 Snob,

Zabbix is an optio= n worth looking at as well. PostgreSQL capability is good and you can u= se it to monitor the rest of your stack as well.

Postgresql monitoring and integration with Zabbix

3D"apple-touc=

Cheers,

Evan

Sent from my iPhone

On= Oct 14, 2022, at 10:11, Mani Sankar <manisankar01695@gmail.com> wrote= :

=EF=BB= =BF
Hi Sbob,

Maybe you can check too= ls like grafana, nagios, postgres_check, PMM etc.

R= egards,
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

= --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: 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--