Himanshu Pandey·Aug 18Reading ClickHouse EXPLAIN PlanClickHouse is a columnar database built for scanning and aggregating large datasets quickly. When a query is slower than expected, EXPLAIN…
InThe Table — Databases and SQLbyDbVisualizer·May 25Best SQL Clients for Query Plan Visualization 2026Understanding how queries run is key when working with databases. This article highlights a few SQL clients that help visualize execution…
InData, Chai & Dialogue (DC&D)byTharashasank D·Mar 18What Starburst Knows About Your Query Before It Runs a Single RowA practitioner’s guide to reading distributed query plans, spotting skew, confirming pushdown, and diagnosing failures — with six real…
Alexander Obregon·Jan 27Reading SQL Query Plans With EXPLAINReading query plans is one of the main ways people diagnose slow statements in relational databases. The EXPLAIN family of tools lays out…