public inbox for [email protected]  

help / color / mirror / Atom feed

From: phb07 <[email protected]>
To: Ravi Tammineni <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Monitoring tool for Postgres Database
Date: Sat, 27 May 2017 17:42:54 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAK17Jm=8rfsASAgdTv7Xz33FrTL-jF3pP8=2fw824CBcQ5v0Ag@mail.gmail.com>
References: <DM5PR02MB2651EEE74D84F7F1AD07413F80FF0@DM5PR02MB2651.namprd02.prod.outlook.com>
	<CA+wvBw0WwodLuM97xxvoLGa_qBq99oqAqvH3f0LPnkSKPcpS9g@mail.gmail.com>
	<CAK17Jm=8rfsASAgdTv7Xz33FrTL-jF3pP8=2fw824CBcQ5v0Ag@mail.gmail.com>
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgsql-performance>

Hi Ravi,

We, at Dalibo, are contributing to the postgres community mostly through 
open source administration tools development.

Among them :
- pgBadger, from Gilles Darold, extracts a lot of data from the postgres 
logs and restitutes them via a web interface 
(https://github.com/dalibo/pgbadger and http://dalibo.github.io/pgbadger/),
- OPM - Open PostgreSQL Monitoring - monitors the activity of instances 
and sends alerts if needed (http://opm.io/, https://github.com/OPMDG and 
http://opm.readthedocs.io/index.html). It uses the check_pgactivity agent,
- PoWA - PostgreSQL Workload Analyzer - captures and stores the SQL 
activity of instances (using the pg_stat_statements extension) and 
reports it through a web interface. 
(http://powa.readthedocs.io/en/latest/ and 
https://github.com/dalibo/powa). Several plugins help the DBA in 
understanding and improving SQL statements performance:
    - pg_qualstats evaluates the selectivity of predicates or where 
clause encountered in SQL statements,
    - pg_stat_kcache captures additional statistics from the OS, like 
CPU and physical I/Os,
    - HypoPG allows to create hypothetical indexes and shows the access 
plan that the postgres optimizer would choose if these indexes would exist.
- PgCluu, from Gilles Darold, performs a full audit of a PostgreSQL 
Cluster performances. A collector grabs statistics on the PostgreSQL 
cluster using psql and sar, a grapher generates all HTML and charts 
output. (http://pgcluu.darold.net/ and https://github.com/darold/pgcluu)

FYI, we are also working on a new project named TemBoard 
(http://temboard.io/ and https://github.com/dalibo/temboard). It is not 
yet production ready. But it has been presented at the latest postgres 
conference in Russia (https://pgconf.ru/en/2017/93881).

Philippe Beaudoin.

Le 27/05/2017 à 06:58, Dave Stibrany a écrit :
> We've found pghero to be a good first line of defence. It doesn't have 
> alerting yet, but it's great for a quick high level healthcheck.
>
> Also +1 for Datadog. Extremely flexible and elegant UI + powerful 
> alerting capabilities.
>
> On Fri, May 26, 2017 at 10:32 AM, Sunkara, Amrutha 
> <[email protected] <mailto:[email protected]>> wrote:
>
>     We have been using Nagios to monitor the system level stats. The
>     database level stats that we gather are custom scripts that we
>     have nagios poll to get the database health. You could use pg
>     badger to generate reports against your database logs as well.
>     Pg_badger reports are your bffs for performance related specs..
>     very close to AWR reports that oracle provides.
>
>     Sotrage/Disk latencies -- we have oracle's os watcher we running
>     regularly on these hosts to generate iostats as well.
>
>     Thanks.
>     -Amrutha.
>
>     On Thu, May 25, 2017 at 3:48 PM, Ravi Tammineni
>     <[email protected]
>     <mailto:[email protected]>> wrote:
>
>         Hi,
>
>         What is the best monitoring tool for Postgres database?
>         Something like Oracle Enterprise Manager.
>
>         Specifically I am interested in tools to help:
>
>         Alert DBAs to problems with both configuration and performance
>         issues
>
>         Deadlocks, Long running queries etc.,
>
>         Monitoring of overall system performance
>
>         General performance tuning
>
>         Storage/Disk latencies
>
>         Thanks
>
>         ravi
>
>
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Monitoring tool for Postgres Database
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox