EXPLAIN Explained
Streamed live on Jan 22, 2016
Talk by Josh Berkus
Do you have slow queries, but you're not sure why? Are you confused by terms like "merge join" and "bitmap heap scan"? Don't you wish there was a version of EXPLAIN for mere mortals?
EXPLAIN is a powerful tool to see what's going on when you execute a PostgreSQL query. It provides such dense information, though, that it's barely comprehensible. But don't dispair! In an hour, you can learn enough to start figuring out what those explain plans mean.
This session will cover:
What the query planner does
Types of query plan nodes
Reading an explain plan
Performance data included with Explain
Explain and query troubleshooting
More tools
Come have explain explained.
More info at: http://www.socallinuxexpo.org/scale/1...
Watch video EXPLAIN Explained online without registration, duration hours minute second in high quality. This video was added by user Southern California Linux Expo 05 February 2016, don't forget to share it with your friends and acquaintances, it has been viewed on our site 16,510 once and liked it 278 people.