Postgres Pro
Downloads
Home   >   mailing lists

Need help with tuning a query - Mailing list pgsql-general

From Siraj G
Subject Need help with tuning a query
Date
Msg-id CAC5iy63sBmNbG6PtJK9g9CvbN-P-QN5hhGPg7EkB1CzR-XhvnQ@mail.gmail.com
Whole thread Raw
Responses Re: Need help with tuning a query  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Jason Long
Date:
Subject: Re: PostgreSQL Guard
Next
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL Guard