Обсуждение: Performance Reports

Hi Ankush!

I am not familiar with Oracle databases in general, or the tools you
mentioned, but if you want to assess your PostgreSQL database's performance on
a per-query level, you should check out pgbadger[0] (a performance-oriented
log analysis tool) and pg_stat_statements[1] (an extension that records
aggregate query performance characteristics), for starters.

Hth!

[0]: http://pgbadger.darold.net/
[1]: https://www.postgresql.org/docs/current/pgstatstatements.html

--
with best regards:
- Johannes Truschnigg ( johannes@truschnigg.info )

www:   https://johannes.truschnigg.info/
phone: +43 650 2 133337
xmpp:  johannes@truschnigg.info

Please do not bother me with HTML-email or attachments. Thank you.

Hi,

On Thu, Apr 30, 2020 at 11:15 AM Ankush Chawla <ankushchawla03@gmail.com> wrote:
>
> hi Team
>
> newbie to postgres from Oracle
> I am wondering if there is any thing such as AWR report which can give a generic picture of events happening in the
databasecausing 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

If you're interested in the wait events you should also look at
pg_wait_sampling (https://github.com/postgrespro/pg_wait_sampling/).
You can also look at powa (https://powa.readthedocs.io/en/latest/) to
take regular snapshot of various datasources (pg_stat_statements,
pg_wait_sampling and others, depending on your needs) and display some
reports on a custom UI.

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