📣

TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

Explain Commands

This page provides reference information for the explain-related commands in TiDB Cloud Lake.

Commands Overview

Command	Use Case
`EXPLAIN`	Understanding query structure and optimization
`EXPLAIN ANALYZE`	Performance analysis with runtime statistics
`EXPLAIN ANALYZE GRAPHICAL`	Visual performance analysis (LakeSQL only)
`EXPLAIN AST`	SQL parsing and syntax analysis
`EXPLAIN PERF`	Query performance profiling (LakeSQL only)
`EXPLAIN RAW`	Internal query processing analysis
`EXPLAIN SYNTAX`	SQL code formatting and standardization