How to practice on EXPLAIN/optimizing queries/constructing indices

Поиск
Список
Период
Сортировка
От Magnus Persson
Тема How to practice on EXPLAIN/optimizing queries/constructing indices
Дата
Msg-id 53BDA4FF.4010301@gmail.com
обсуждение исходный текст
Ответы Re: How to practice on EXPLAIN/optimizing queries/constructing indices  (Keith <keith@keithf4.com>)
Re: How to practice on EXPLAIN/optimizing queries/constructing indices  (Sergey Konoplev <gray.ru@gmail.com>)
Список pgsql-novice
Дерево обсуждения 
So I found https://wiki.postgresql.org/wiki/Using_EXPLAIN but still I
feel there should be more to it.
What methods can I use to actually get better at spotting issues with a
query? How can I go from looking at a fancy EXPLAIN graph produced by
PgAdmin and realize what the problem is (if there is one)?

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: collation from an external file
Следующее
От: Keith
Дата:
Сообщение: Re: How to practice on EXPLAIN/optimizing queries/constructing indices