Skip to main content

How to use physical explain plans

In this Cockroach University lesson titled “How to use physical explain plans”, you will learn how a cluster finds information, you’ll see an explain plan diagram, and you’ll get to look at a very complicated explain plan broken down into its parts. In this lesson, you will learn: •00:00 How to use the EXPLAIN ANALYZE statement •0:20 How CockroachDB responds to a query •0:54 How to understand the nodes and indexes involved in a query •1:32 How to interpret the results *This video is an exceprt from our course, "CockroachDB for Python Developers". Learn more about CockroachDB by signing up for free training at Cockroach University: https://university.cockroachlabs.com/ ---------- Reference Links •SQL Performance Best Practices: https://www.cockroachlabs.com/docs/v19.2/performance-best-practices-overview.html (CockroachDB Docs) •Indexes: https://www.cockroachlabs.com/docs/v19.2/indexes.html (CockroachDB Docs) ---------- Careers: https://www.cockroachlabs.com/careers CockroachCloud: https://www.cockroachlabs.com/product/cockroachcloud/ Blog: https://www.cockroachlabs.com/blog/ Docs: https://www.cockroachlabs.com/docs/stable/ Community Slack: https://cockroa.ch/Welcome-to-Slack Twitter: https://twitter.com/CockroachDB