Обсуждение: Need help with tuning a query

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