Postgres – EXPLAIN explained

dexen · on Oct 1, 2015

The tool for highlighting EXPLAIN output is provided on http://explain.depesz.com/ (as mentioned in a later slide). It's commonly used when asking for help and discussing queries on #postgresql on Freenode.

cdman · on Oct 1, 2015

Can also warmly recommend the EXPLAIN visualizations generated by pgAdmin: http://www.pgadmin.org/

See an (simple) example here: http://www.pgadmin.org/images/screenshots/pgadmin3_macosx.pn...

jimktrains2 · on Oct 1, 2015

And I haven't completely finished my explanation of it! http://jimkeener.com/posts/explain-pg

I love EXPLAIN, it's such an amazing tool for figuring out how to get a query to run faster. It's much more detailed than MySQL's and often one of the reasons I list when people ask if they should checkout/switch to pg (which you should!)

skrause · on Oct 1, 2015

Another EXPLAIN documentation, probably easier to read since it's a PDF and not a slideshow: http://www.dalibo.org/_media/understanding_explain.pdf

hvo · on Oct 1, 2015

Thanks for this. I really like postgres community.They are vibrant and you will almost always learn one thing or the other from them.

iso8859-1 · on Oct 1, 2015

Where is the video for this?

stevenringo · on Oct 1, 2015

Nice one. Is there an offline/downloadable version available?

pmh · on Oct 1, 2015

You could grab the site (or just individual files) from github: https://github.com/jberkus/jberkus.github.io

The README on https://github.com/jberkus/jberkus.github.io/tree/master/exp... has instructions to get it running locally

onderkalaci · on Oct 1, 2015

I couldn't find either.