Re: Need help with slow query - postgres 12 on linux RHEL 8
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
To
: "Wilson, Maria Louise (LARC-E301)[RSES]" <m.l.wilson@xxxxxxxx>
Subject
: Re: Need help with slow query - postgres 12 on linux RHEL 8
From
: Jeff Janes <jeff.janes@xxxxxxxxx>
Date
: Thu, 28 Dec 2023 12:02:17 -0500
Cc
: "pgsql-admin@xxxxxxxxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
In-reply-to
: <
902F274D-3E26-4D7C-BF7F-07536C3857E6@nasa.gov
>
References
: <
902F274D-3E26-4D7C-BF7F-07536C3857E6@nasa.gov
>
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.)
References
:
Need help with slow query - postgres 12 on linux RHEL 8
From:
Wilson, Maria Louise (LARC-E301)[RSES]
Prev by Date:
Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8
Next by Date:
Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8
Previous by thread:
Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8
Next by thread:
VPS Offers
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Home]
[Postgresql General]
[Postgresql Performance]
[Postgresql PHP]
[Postgresql Jobs]
[PHP Users]
[PHP Databases]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Databases]
[Yosemite Forum]
