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
