Postgres Pro
Downloads
Home   >   mailing lists

Re: Suggestion to Monitoring Tool - Mailing list pgsql-admin

From Rene Romero Benavides
Subject Re: Suggestion to Monitoring Tool
Date
Msg-id CANaGW0-iiKvQevrPdv+qz1cFfFykAxLfeskfohYRAu+y5iRQBw@mail.gmail.com
Whole thread Raw
In response to Suggestion to Monitoring Tool  (postgann2020 s <postgann2020@gmail.com>)
List pgsql-admin
Tree view
Give pgwatch2 a try: 

On Wed, May 27, 2020 at 11:46 AM postgann2020 s <postgann2020@gmail.com> wrote:
Hi Team,

Thanks for your support.

Environment Details:
OS: RHEL 7.2
Postgres: 9.5.15
Master-Slave with Streaming replication

We are planning to implement the monitoring tool for our environment.

Could someone please suggest the Monitoring Tool based on your experience.

We are looking to cover the below areas.

1. Monitoring metrics and alerting.
2. Monitoring events and alerting.
3. Consolidate all the PROD DB logs and provide insights on log data.
4. logging explain plan and insights on explain plans. (Something like store explain plan and compare plans and send alerts on deviations)
5. Logging audit data and insights from audit data.


Thanks & Regards,
Postgann.


--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Policy function not working (IN parameter not passed)
Next
From: Achilleas Mantzios
Date:
Subject: pg_stat_database.xact_commit + pg_stat_database.xact_rollback as areliable metric for xid consumption ?