pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Need help with tuning a query
2+ messages / 2 participants
[nested] [flat]

* Need help with tuning a query
@ 2024-02-27 15:50  Siraj G <tosiraj.g@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Siraj G @ 2024-02-27 15:50 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

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

Attachments:

  Postgres_plan.txt (text/plain, 223.4K) download

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Need help with tuning a query
@ 2024-02-27 16:00  Adrian Klaver <adrian.klaver@aklaver.com>
  parent: Siraj G <tosiraj.g@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Adrian Klaver @ 2024-02-27 16:00 UTC (permalink / raw)
  To: Siraj G <tosiraj.g@gmail.com>; pgsql-general@lists.postgresql.org

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






^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2024-02-27 16:00 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-02-27 15:50 Need help with tuning a query Siraj G <tosiraj.g@gmail.com>
2024-02-27 16:00 ` Adrian Klaver <adrian.klaver@aklaver.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox