Subject: Re: Performance Reports
To: pgsql-admin@lists.postgresql.org
References: 
 <CAOY8JhCy4=9MQmpMXrm=kNoRTk=U8iYxOBCohZVzzkfe2QzkbA@mail.gmail.com>
From: "Radoulov, Dimitre" <cichomitiko@gmail.com>
Message-ID: <2350d881-ba45-da66-9d4d-b024ff066f2b@gmail.com>
Date: Thu, 30 Apr 2020 14:08:28 +0200
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:68.0) Gecko/20100101
 Thunderbird/68.7.0
MIME-Version: 1.0
In-Reply-To: 
 <CAOY8JhCy4=9MQmpMXrm=kNoRTk=U8iYxOBCohZVzzkfe2QzkbA@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: en-US
Precedence: bulk


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