| From: | Johannes Truschnigg <johannes(at)truschnigg(dot)info> |
|---|---|
| To: | Ankush Chawla <ankushchawla03(at)gmail(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Performance Reports |
| Date: | 2020-04-30 10:49:03 |
| Message-ID: | 20200430104903.GA28955@vault.lan |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)truschnigg(dot)info )
www: https://johannes.truschnigg.info/
phone: +43 650 2 133337
xmpp: johannes(at)truschnigg(dot)info
Please do not bother me with HTML-email or attachments. Thank you.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Priancka Chatz | 2020-04-30 11:03:08 | Re: Performance Reports |
| Previous Message | Ankush Chawla | 2020-04-30 09:14:40 | Performance Reports |