| From: | Flávio Henrique <yoshimit(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Learning EXPLAIN |
| Date: | 2017-12-08 01:12:16 |
| Message-ID: | CAOGex3kbVDxLbbLqx1YhDoOtCGqE=p1eJPoCe-8CPiUL5JUUCQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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.
Can you kindly advise me a good reading about advanced EXPLAIN?
Thank you!
[1] http://www.dalibo.org/_media/understanding_explain.pdf
Flávio Henrique
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alex Tokarev | 2017-12-08 04:21:45 | Table with large number of int columns, very slow COPY FROM |
| Previous Message | Claudio Freire | 2017-12-07 17:56:37 | Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade |