Need help with tuning a query

From: Siraj G <tosiraj(dot)g(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Need help with tuning a query
Date: 2024-02-27 15:50:36
Message-ID: CAC5iy63sBmNbG6PtJK9g9CvbN-P-QN5hhGPg7EkB1CzR-XhvnQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Attachment Content-Type Size
Postgres_plan.txt text/plain 223.4 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2024-02-27 15:58:39 Re: PostgreSQL Guard
Previous Message Jason Long 2024-02-27 15:08:04 Re: PostgreSQL Guard