Thread: Tools available to determine bad code in the testing phase

Tools available to determine bad code in the testing phase

From
Siraj G
Date:
Hello All!

I am new to PgSQL. I would like to know the tools available in PgSQL (similar to OEM, AWR/ASH, AppDynamics) using which we can determine the bad code performance wise and fix them timely during the development/soft go-live phases.

Thanks & Regards
Siraj

Re: Tools available to determine bad code in the testing phase

From
Julien Rouhaud
Date:
Hi,

On Wed, Oct 18, 2023 at 03:29:11PM -0400, Siraj G wrote:
> Hello All!
>
> I am new to PgSQL. I would like to know the tools available in PgSQL
> (similar to OEM, AWR/ASH, AppDynamics) using which we can determine the bad
> code performance wise and fix them timely during the development/soft
> go-live phases.

I think that the closest tool for postgres is PoWA, see
https://powa.readthedocs.io/en/latest/.