query
Installation
SKILL.md
Query Troubleshooting
Investigation guide for query hangs, slow queries, profile analysis, scan performance, join performance, and bug localization.
Three root causes account for the vast majority of cases:
- Cause A — Network/connection issue (TCP backlog, accept queue saturation)
- Cause B — FE lock / GC blocking (deadlock, full GC pause)
- Cause C — Scan bottleneck (data skew, no predicate pushdown, rowset accumulation)
- Cause D — Join bottleneck (broadcast OOM, missing statistics)
- Cause E — Bug localization (wrong results, executor crash)
Metric Taxonomy — Read This First
Before using any metrics, understand the two-layer observability structure: