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…
InJudy’s database sharingbyJudy Huang·Jan 9PostgreSQL Query Planner：如何決定 scan 的方式當執行一個看似簡單的 SQL 查詢時，PostgreSQL 的 Planner 在背後做了大量的決策，你會不會有疑惑，為什麼 PostgreSQL 不選擇 index scan 卻選擇 seq scan？為什麼是這張表先做 scan ，而不是另外一張表？
InSnowflake Builders Blog: Data Engineers, App Developers, AI, & Data SciencebyEmber Crooks·Oct 23, 2025Introducing the Query ProfileThe Query Profile is a component of the Snowflake web UI that lets you view various logical and statistical aspects of a single query…
Manish Lath·May 26, 2025Unlocking SQL Performance: A Practical Guide to EXPLAIN ANALYZEMany of us have been in situations where our APIs or processes have a high latency owing to inefficient queries to the database. We try to…
Nikhilesh Joshi·May 11, 2025The Cost of the Road TakenWhen you run a query in a DBMS, you’re writing in a non-procedural language: SQL. You’re telling the system what you want, not how to get…
Arun Seetharaman·Mar 3, 2025Understanding the Response from an EXPLAIN Plan in PostgreSQL: A Deep DiveIn PostgreSQL, the EXPLAIN command is an indispensable tool for analyzing query performance. It provides a detailed execution plan that…
