Re: Slow SELECT

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