Need help with tuning a query
Hello All!
Can you please assist me with highlighting the bad area in the execution
plan attached. I am kind of new to PgSQL and trying to get some help with
troubleshooting a query.
Little background. DB was migrated from Oracle to AlloyDB. The SQL that
used to take 2 seconds is now taking around 8 - 10secs in AlloyDB. We are
trying to close this gap. Any help would be appreciated.
Regards
Siraj
Attachments:
Postgres_plan.txttext/plain; charset=US-ASCII; name=Postgres_plan.txtDownload
On 2/27/24 07:50, Siraj G wrote:
Hello All!
Can you please assist me with highlighting the bad area in the execution
plan attached. I am kind of new to PgSQL and trying to get some help
with troubleshooting a query.
Little background. DB was migrated from Oracle to AlloyDB. The SQL that
used to take 2 seconds is now taking around 8 - 10secs in AlloyDB. We
are trying to close this gap. Any help would be appreciated.
https://wiki.postgresql.org/wiki/Slow_Query_Questions
Regards
Siraj
--
Adrian Klaver
adrian.klaver@aklaver.com