Re: Need help with slow query - postgres 12 on linux RHEL 8

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