Re: Performance Reports - Mailing list pgsql-admin

From Johannes Truschnigg
Subject Re: Performance Reports
Date
Msg-id 20200430104903.GA28955@vault.lan
Whole thread Raw
In response to Performance Reports  (Ankush Chawla <ankushchawla03@gmail.com>)
Responses Re: Performance Reports  (Priancka Chatz <pc9926@gmail.com>)
List 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@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.

Attachment

pgsql-admin by date:

Previous
From: Ankush Chawla
Date:
Subject: Performance Reports
Next
From: Priancka Chatz
Date:
Subject: Re: Performance Reports