explain EXPLAIN?

Поиск
Список
Период
Сортировка
От David Olbersen
Тема explain EXPLAIN?
Дата
Msg-id Pine.LNX.4.31.0103081517580.31922-100000@bubbles.electricutopia.net
обсуждение исходный текст
Список pgsql-sql
Hello, I'm looking for a better tutorial of how EXPLAIN works. I know Mr. Tom Lane wrote a "quick & dirty explanation"
andthat "plan-reading is an art that deserves a tutorial, and I haven't had time to write one". In which case I'd like
toknow if there's any other tutorials/resources.
 
 I think I get the jist of it (an index scan is better than a seq scan?) but I'd like to read more. Does anybody have
anysuggestions?
 

-- Dave



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

Предыдущее
От: Michael Davis
Дата:
Сообщение: Access tables inside pl/pgsql functions
Следующее
От: Kyle
Дата:
Сообщение: Re: A query that doesn't work on 7.1