Обсуждение: Performance Reports
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 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
Best Regards,
Ankush Chawla
Ankush Chawla
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,
You can also explore the use of third party tools like pgbadger report or pgstatspack report.
Cheers,
Priyanka
On Thu, 30 Apr 2020 at 4:19 PM, Johannes Truschnigg <johannes@truschnigg.info> wrote:
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.
In addition to the above, you can also use pg_profile extention. https://github.com/zubkov-andrei/pg_profile
Julien Rouhaud <rjuju123@gmail.com>, 30 Nis 2020 Per, 14:31 tarihinde şunu yazdı:
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 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
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