Debugging SQL Queries: Understanding Execution Plans and Query Flow

Discover techniques for debugging SQL queries in this 18-minute conference talk from Conf42 Observability 2023. Explore the challenges of identifying query flaws, understand the concept of democratizing execution plans, and learn about query execution flow. Dive into the anatomy of EXPLAIN statements and see how ChatGPT can assist in query analysis. Examine practical examples, including troubleshooting empty result sets, and compare different debugging approaches. Gain insights into query flow, weigh the pros and cons of various debugging methods, and glimpse an optimistic future for SQL query optimization.

intro
preface
identify flaws in queries is tough
buzzword alert! democratization of execution plans
query execution flow
let's explain explain
explain anatomy
chat gpt
example: empty results
aren't there easier ways?
query flow
pros and cons
optimistic future