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

From Adrian Klaver
Subject Re: Need help with tuning a query
Date
Msg-id 2d9d2a2a-8873-4bfa-ba97-a0f77efa77dc@aklaver.com
Whole thread Raw
In response to Need help with tuning a query  (Siraj G <tosiraj.g@gmail.com>)
List pgsql-general
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




pgsql-general by date:

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