Re: Suggestion to Monitoring Tool

[Rene Romero Benavides <rene.romero.b@xxxxxxxxx>]

Give pgwatch2 a try: 

https://pgwatch.com/

On Wed, May 27, 2020 at 11:46 AM postgann2020 s <postgann2020@xxxxxxxxx> 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/