Hi
On 26.05.20 09:22, Frank Millman wrote:
>
> I have looked at the EXPLAIN, but I don't really know what to look for.
> I can supply it if that would help.
>
My favorite approach to tuning Postgres queries is:
1. Run EXPLAIN ANALYZE <query>
2. Copy/Paste the output into the fantastic https://explain.depesz.com/
This will turn the somewhat hard-to-understand explain output into a
nice colored structure. If it's not obvious from the orange-reddish
boxes where the slowness comes from, please post the link here and
somebody will certainly have some advice.
Cheers
Christian
--
Christian Ramseyer, netnea ag
Network Management. Security. OpenSource.
https://www.netnea.com