| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Flávio Henrique <yoshimit(at)gmail(dot)com> |
| Cc: | postgres performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Learning EXPLAIN |
| Date: | 2017-12-08 13:20:16 |
| Message-ID: | CAECtzeXxj8Oi7dqVKTD3b9RSydxMxZ2XvGnZaXkMA37fWVdJaA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi,
2017-12-08 2:12 GMT+01:00 Flávio Henrique <yoshimit(at)gmail(dot)com>:
> 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 are not covered by the article.
>
> I need/want to know EXPLAIN better.
>
> Can you kindly advise me a good reading about advanced EXPLAIN?
>
>
There's not much out there. This document was written after reading this
list, viewing some talks (you may find a lot of them on youtube), and
reading the code.
I intend to update this document, since I learned quite more since 2012.
Though I didn't find the time yet :-/
Anyway, thanks.
--
Guillaume.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Flavio Henrique Araque Gurgel | 2017-12-08 13:32:06 | Re: Learning EXPLAIN |
| Previous Message | Andreas Kretschmer | 2017-12-08 07:20:40 | Re: Table with large number of int columns, very slow COPY FROM |