query-plan-reader

What problem does it solve?

This Skill helps you diagnose why a single SQL query is slow by reading its execution plan, identifying the dominant cost node, and separating real bottlenecks from misleading assumptions.

Core Features & Use Cases

• Plan interpretation: Explains scans, joins, sorts, spills, and row-estimate mismatches in plain language.
• Evidence-based tuning: Ranks fixes such as statistics refresh, query rewrite, index changes, or schema adjustments by cost and likely impact.
• Multi-tenant awareness: Accounts for tenant predicates and row-security filters that affect the plan and index choice.
• Use cases: Interpreting EXPLAIN ANALYZE output, deciding whether an index is justified, and verifying that a fix changes the plan as expected.

Quick Start

Use the query-plan-reader skill to analyze this query’s execution plan, identify the dominant cost, and recommend the cheapest fix with a re-verification method.