Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Janes
Subject Re: Need help with slow query - postgres 12 on linux RHEL 8
Date
Msg-id CAMkU=1wueV+uzUKhk_XCWjfg7m2FHM0+V0jX8Yy_7K1+PDbXVw@mail.gmail.com
Whole thread Raw
In response to Need help with slow query - postgres 12 on linux RHEL 8  ("Wilson, Maria Louise (LARC-E301)[RSES]" <m.l.wilson@nasa.gov>)
List pgsql-admin
Tree view
You really need an index on  granule_file_1.granule_uuid, which it doesn't look like you have.  (In general you should have indexes on all foreign keys.)

pgsql-admin by date:

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