Thread: Performance Tool - PostgreSQL

Performance Tool - PostgreSQL

From

Gambhir Singh

Date:

01 February 2023, 21:02:32

Hi,

I'm migrating Oracle Database to AWS Aurora PostgreSQL Cluster. There are certain queries which are performing badly in PostgreSQL after migration. Is there any tool which will give advise, how to improve the performance, like suggestions of indexes?

Thanks & Regards
Gambhir Singh

Fwd: Performance Tool - PostgreSQL

From

Gambhir Singh

Date:

03 February 2023, 18:09:38

Hi,

Thanks and Regards

Gambhir Singh

Re: Performance Tool - PostgreSQL

From

Daniel RC

Date:

03 February 2023, 18:12:59

Hey Gambhir.

Check pg_hero.
https://github.com/ankane/pghero

See ya!

Em sex., 3 de fev. de 2023 às 12:09, Gambhir Singh <gambhir.singh05@gmail.com> escreveu:

Hi,

I'm migrating Oracle Database to AWS Aurora PostgreSQL Cluster. There are certain queries which are performing badly in PostgreSQL after migration. Is there any tool which will give advise, how to improve the performance, like suggestions of indexes?

Thanks and Regards
Gambhir Singh