Postgres – EXPLAIN explained

http://jberkus.github.io/explain_explained/index.html?utm_source=postgresweekly&utm_medium=email#1

by onderkalaci • 11 years ago

105 9 11 years ago

jberkus.github.io

skrause• 11 years ago

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

iso8859-1• 11 years ago

Where is the video for this?

dexen• 11 years ago

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• 11 years ago

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...

stevenringo• 11 years ago

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

onderkalaci• 11 years ago

I couldn't find either.

pmh• 11 years ago

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

hvo• 11 years ago

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

jimktrains2• 11 years ago

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!)

Postgres – EXPLAIN explained

Related Stories