cockroachdb / cockroachdb/cockroach
sql: include forecasted histograms in statement bundle
- 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
Assessment
This issue has not been assessed yet.