pg.ddx.io pgsql-general@postgresql.org mailing list archivehelp / 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