Postgres Pro
Downloads
Home   >   mailing lists

Re: Learning EXPLAIN - Mailing list pgsql-performance

From Guillaume Lelarge
Subject Re: Learning EXPLAIN
Date
Msg-id CAECtzeXxj8Oi7dqVKTD3b9RSydxMxZ2XvGnZaXkMA37fWVdJaA@mail.gmail.com
Whole thread Raw
In response to Learning EXPLAIN  (Flávio Henrique <yoshimit@gmail.com>)
Responses Re: Learning EXPLAIN  (Flavio Henrique Araque Gurgel <fhagur@gmail.com>)
List pgsql-performance
Tree view
Hi,

2017-12-08 2:12 GMT+01:00 Flávio Henrique <yoshimit@gmail.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.

pgsql-performance by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Table with large number of int columns, very slow COPY FROM
Next
From: Flavio Henrique Araque Gurgel
Date:
Subject: Re: Learning EXPLAIN