From: Radoulov, Dimitre <cichomitiko@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Performance Reports
Date: Thu, 30 Apr 2020 14:08:28 +0200
Message-ID: <2350d881-ba45-da66-9d4d-b024ff066f2b@gmail.com> (raw)
In-Reply-To: <CAOY8JhCy4=9MQmpMXrm=kNoRTk=U8iYxOBCohZVzzkfe2QzkbA@mail.gmail.com>
References: <CAOY8JhCy4=9MQmpMXrm=kNoRTk=U8iYxOBCohZVzzkfe2QzkbA@mail.gmail.com>
On 30/04/2020 11.14, Ankush Chawla wrote:
> [...]
> I am wondering if there is any thing such as AWR report which can give
> a generic picture of events happening in the database causing
> performance issues
> or any kind of snapshots for particular time period
> Statistics from table are generally a summarized detail since cluster
> startup
> Issue faced at particular time interval is not
Not exactly what you're asking for, but you could check PMM (Percona
Monitoring and Management): an open source monitoring tool that supports
PostgreSQL.
It's very easy to install, there's even an option to set it up as a
docker image. You'll have historical charts for various OS and database
metrics and with Query Analytics you could analyze your current and
historical workload (you'll need to install and configure
pg_stat_statements).
There's an online demo at: https://pmmdemo.percona.com/graph/
For more info:
https://www.percona.com/software/database-tools/percona-monitoring-and-management
Regards
Dimitre
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: pgsql-admin@postgresql.org
Cc: cichomitiko@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Performance Reports
In-Reply-To: <2350d881-ba45-da66-9d4d-b024ff066f2b@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox