On Wed, Dec 27, 2023 at 09:40:41PM +0000, Wilson, Maria Louise (LARC-E301)[RSES] wrote: > Hello folks! > > I am having a complex query slowing over time increasing in duration. > If anyone has a few cycles that they could lend a hand or just point > me in the right direction with this – I would surely appreciate it! > Fairly beefy Linux server with Postgres 12 (latest) – this particular > query has been getting slower over time & seemingly slowing everything > else down. The server is dedicated entirely to this particular > database. Let me know if I can provide any additional information!! > Thanks in advance! Hi, we'd need `explain (analyze, buffers) select ...` for your query. Ideally, could you put it on https://explain.depesz.com/, with query and `\d`, and provide us with link? Best regards, depesz
