PolarDB-X Execution Plan Analysis

Analyze PolarDB-X execution plans (EXPLAIN / EXPLAIN COST / EXPLAIN ANALYZE output) and verify semantic equivalence between SQL and execution plans.

Scope

Applies to:

• Operator interpretation of EXPLAIN / EXPLAIN COST / EXPLAIN ANALYZE output
• EXPLAIN COST cost estimation (rowcount, cumulative cost) interpretation
• EXPLAIN ANALYZE runtime statistics (actual time, actual rowcount, instances) interpretation and bottleneck identification
• SQL-to-execution-plan semantic equivalence verification
• Foundation for phase/rule-level optimizer attribution analysis (operator interpretation capabilities)

Does NOT apply to: