From: hubert depesz lubaczewski <depesz@depesz.com>
To: Wilson, Maria Louise (LARC-E301)[RSES] <m.l.wilson@nasa.gov>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Need help with slow query - postgres 12 on linux RHEL 8
Date: Thu, 28 Dec 2023 13:49:39 +0100
Message-ID: <ZY1u452aNH-r6xvW@depesz.com> (raw)
In-Reply-To: <902F274D-3E26-4D7C-BF7F-07536C3857E6@nasa.gov>
References: <902F274D-3E26-4D7C-BF7F-07536C3857E6@nasa.gov>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: depesz@depesz.com, m.l.wilson@nasa.gov, pgsql-admin@lists.postgresql.org
Subject: Re: Need help with slow query - postgres 12 on linux RHEL 8
In-Reply-To: <ZY1u452aNH-r6xvW@depesz.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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