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: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8
Date: Thu, 28 Dec 2023 18:48:50 +0100
Message-ID: <ZY21Anu3djWbVXWG@depesz.com> (raw)
In-Reply-To: <A52A2FE8-52C8-4924-925B-F913E8DEF26B@nasa.gov>
References: <902F274D-3E26-4D7C-BF7F-07536C3857E6@nasa.gov>
<ZY1u452aNH-r6xvW@depesz.com>
<A52A2FE8-52C8-4924-925B-F913E8DEF26B@nasa.gov>
On Thu, Dec 28, 2023 at 04:25:41PM +0000, Wilson, Maria Louise (LARC-E301)[RSES] wrote:
> Here is also the link from explain.depesz.com
> https://explain.depesz.com/s/p89J#html
Any chance you can also provide the query that you used in this case,
and `\d` of all tables:
- collection
- file
- granule
- granule_file
- visibility
Here you have example explain that contains all the information:
https://explain.depesz.com/s/S5Rd
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: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8
In-Reply-To: <ZY21Anu3djWbVXWG@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