cockroachdb / cockroachdb/cockroach

opt: add EXPLAIN (STATS)

Open
#104,632 3 comments 0 reactions 0 assignees View on GitHub
A-sql-explain A-sql-observability A-sql-optimizer A-sql-table-stats C-enhancement O-support P-3 T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

Sometimes it is difficult to understand how `statisticsBuilder` arrived at its estimate for a query. It would be nice to have an `EXPLAIN (STATS)` or `EXPLAIN (OPT, STATS)` that showed how the statistics estimate for each node in the plan was derived.

Jira issue: CRDB-28646
Epic CRDB-37757

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.