Postgres Pro
Downloads
Home   >   mailing lists

Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8 - Mailing list pgsql-admin

From hubert depesz lubaczewski
Subject Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8
Date
Msg-id ZY21Anu3djWbVXWG@depesz.com
Whole thread Raw
In response to Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8  ("Wilson, Maria Louise (LARC-E301)[RSES]" <m.l.wilson@nasa.gov>)
Responses Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Need help with slow query - postgres 12 on linux RHEL 8
Next
From: "Wilson, Maria Louise (LARC-E301)[RSES]"
Date:
Subject: Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8