Re: Need help with tuning a query

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Siraj G <tosiraj(dot)g(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Need help with tuning a query
Date: 2024-02-27 16:00:16
Message-ID: 2d9d2a2a-8873-4bfa-ba97-a0f77efa77dc@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

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