Date: Thu, 28 Dec 2023 13:49:39 +0100
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: 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
Message-ID: <ZY1u452aNH-r6xvW@depesz.com>
Reply-To: depesz@depesz.com
References: <902F274D-3E26-4D7C-BF7F-07536C3857E6@nasa.gov>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <902F274D-3E26-4D7C-BF7F-07536C3857E6@nasa.gov>
Archived-At: 
 <https://www.postgresql.org/message-id/ZY1u452aNH-r6xvW%40depesz.com>
Precedence: bulk

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