From: | Priancka Chatz <pc9926(at)gmail(dot)com> |
---|---|
To: | Johannes Truschnigg <johannes(at)truschnigg(dot)info> |
Cc: | Ankush Chawla <ankushchawla03(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Performance Reports |
Date: | 2020-04-30 11:03:08 |
Message-ID: | CANnOdgYT7WfepF3=t-KUJ9guS7DCRRCSHun3zQk01z+n1V=teQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)truschnigg(dot)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(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 | Julien Rouhaud | 2020-04-30 11:30:54 | Re: Performance Reports |
Previous Message | Johannes Truschnigg | 2020-04-30 10:49:03 | Re: Performance Reports |