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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxx )
www: https://johannes.truschnigg.info/
phone: +43 650 2 133337
xmpp: johannes@xxxxxxxxxxxxxxx
Please do not bother me with HTML-email or attachments. Thank you.
