Re: Suggestion to Monitoring Tool

From: Rene Romero Benavides <rene(dot)romero(dot)b(at)gmail(dot)com>
To: postgann2020 s <postgann2020(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Suggestion to Monitoring Tool
Date: 2020-06-01 00:06:10
Message-ID: CANaGW0-iiKvQevrPdv+qz1cFfFykAxLfeskfohYRAu+y5iRQBw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Give pgwatch2 a try:
https://pgwatch.com/

On Wed, May 27, 2020 at 11:46 AM postgann2020 s <postgann2020(at)gmail(dot)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/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2020-06-01 10:02:19 pg_stat_database.xact_commit + pg_stat_database.xact_rollback as a reliable metric for xid consumption ?
Previous Message Laurenz Albe 2020-05-29 16:06:34 Re: Policy function not working (IN parameter not passed)

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-06-01 00:29:05 Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
Previous Message Stefan Keller 2020-05-31 22:35:21 Re: Oracle vs. PostgreSQL - a comment