Re: How to practice on EXPLAIN/optimizing queries/constructing indices

Поиск
Список
Период
Сортировка
От Keith
Тема Re: How to practice on EXPLAIN/optimizing queries/constructing indices
Дата
Msg-id CAHw75vsi=suDrGO1CgUsKA8D_nrhYthojcc2+iZ_3frBUyUy9g@mail.gmail.com
обсуждение исходный текст
Ответ на How to practice on EXPLAIN/optimizing queries/constructing indices  (Magnus Persson <magnus.e.persson@gmail.com>)
Список pgsql-novice
Дерево обсуждения
Frequent postgresql blogger, depesz, did a great series on understanding the query planner. It helped me a lot

http://www.depesz.com/?s=explaining+the+unexplainable


On Wed, Jul 9, 2014 at 4:24 PM, Magnus Persson <magnus.e.persson@gmail.com> wrote:
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)?




--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

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

Предыдущее
От: Magnus Persson
Дата:
Сообщение: How to practice on EXPLAIN/optimizing queries/constructing indices
Следующее
От: Sergey Konoplev
Дата:
Сообщение: Re: How to practice on EXPLAIN/optimizing queries/constructing indices