Re: Slow SELECT

Поиск
Список
Период
Сортировка
От Christian Ramseyer
Тема Re: Slow SELECT
Дата
Msg-id 06c641a3-cd43-79f7-9e00-ed5d9f10028f@networkz.ch
обсуждение исходный текст
Ответ на Slow SELECT  (Frank Millman <frank@chagford.com>)
Ответы Re: Slow SELECT
Список pgsql-general
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






В списке pgsql-general по дате отправления:

Предыдущее
От: Frank Millman
Дата:
Сообщение: Re: Slow SELECT
Следующее
От: David Rowley
Дата:
Сообщение: Re: Slow SELECT