Re: Need help with slow query - postgres 12 on linux RHEL 8

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: "Wilson, Maria Louise (LARC-E301)[RSES]" <m(dot)l(dot)wilson(at)nasa(dot)gov>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Need help with slow query - postgres 12 on linux RHEL 8
Date: 2023-12-28 17:02:17
Message-ID: CAMkU=1wueV+uzUKhk_XCWjfg7m2FHM0+V0jX8Yy_7K1+PDbXVw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.)

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message hubert depesz lubaczewski 2023-12-28 17:48:50 Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8
Previous Message Wilson, Maria Louise (LARC-E301)[RSES] 2023-12-28 16:25:41 Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8