Re: Learning EXPLAIN

2017-12-08 Thread Sam Gendler
Ah, I see now that the article you linked to in the OP is written by the same author and is maybe the very same content. If so, that sure seems pretty comprehensive to me, though I've also been reading this list, off and on, for many years, which has probably filled a lot of the gaps left by the or

Re: Learning EXPLAIN

2017-12-08 Thread Sam Gendler
What about the many-part explanation posted on the blog that accompanies explain.depesz.com. Here is the first installment. I seem to remember that there are 5 or 6 installments. https://www.depesz.com/2013/04/16/explaining-the-unexplainable/ On Fri, Dec 8, 2017 at 8:44 AM, Gustavo Velasquez wr

Re: Learning EXPLAIN

2017-12-08 Thread Gustavo Velasquez
Dude, You can rest assured that at least the Brazilians members will always know based on your last name you are not the same :-). What's the point of explaining that anyways? Got curious. As to what pertains to the topic: This is another simple yet effective doc: https://wiki.postgresql.org/i

Re: Learning EXPLAIN

2017-12-08 Thread Flavio Henrique Araque Gurgel
Em sex, 8 de dez de 2017 às 14:20, Guillaume Lelarge escreveu: > Hi, > > 2017-12-08 2:12 GMT+01:00 Flávio Henrique : > >> Hi experts! >> >> I read this nice article about Understanding EXPLAIN [1] weeks ago that >> opened my mind about the tool, but it seems no enough to explain a lot of >> plans

Re: Learning EXPLAIN

2017-12-08 Thread Guillaume Lelarge
Hi, 2017-12-08 2:12 GMT+01:00 Flávio Henrique : > Hi experts! > > I read this nice article about Understanding EXPLAIN [1] weeks ago that > opened my mind about the tool, but it seems no enough to explain a lot of > plans that I see in this list. > Thanks. I often read responses to a plan that

Learning EXPLAIN

2017-12-07 Thread Flávio Henrique
Hi experts! I read this nice article about Understanding EXPLAIN [1] weeks ago that opened my mind about the tool, but it seems no enough to explain a lot of plans that I see in this list. I often read responses to a plan that are not covered by the article. I need/want to know EXPLAIN better.