Скачать с ютуб EXPLAIN Explained в хорошем качестве

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