| From: | Frank Millman <frank(at)chagford(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Slow SELECT |
| Date: | 2020-05-26 10:26:12 |
| Message-ID: | e57c6bc9-8330-3f49-50fa-a7622da3d283@chagford.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frank Millman | 2020-05-26 10:30:47 | Re: Slow SELECT |
| Previous Message | Frank Millman | 2020-05-26 10:25:26 | Re: Slow SELECT |