On 2020-05-26 12:02 PM, Christian Ramseyer wrote:
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.
Thanks, Christian. I will definitely look into that.
Frank
