cockroachdb / cockroachdb/cockroach

sql: include forecasted histograms in statement bundle

Open
#118,777 1 comment 0 reactions 0 assignees View on GitHub
A-sql-debug-bundle 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

**Is your feature request related to a problem? Please describe.**
In a recent customer escalation, I found that it was difficult to determine which placeholder values could cause a different version of a query plan since I could only see the present-time histogram in the statement bundle and not the forecasted histogram.

**Describe the solution you'd like**
It would help to include the forecasted histogram for each table in the statement bundle that uses forecasts.

**Describe alternatives you've considered**
Another option would be to print out all possible plans for different placeholder values and show the crossover points for each placeholder value. This would be better, but a lot more complicated than simply including the forecasted histogram in the bundle.

Jira issue: CRDB-35900

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.