cockroachdb / cockroachdb/cockroach

opt: add optsteps or something like it to statement bundle

Open
#99,687 0 comments 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

Lifting complicated customer queries out of the statement bundle env to the opt_tester env is hard and some things aren't supported (materialized views). But we frequently have to do this to gain an understanding of what plans were considered and discarded and what was driving the cost tradeoffs.

Ideally we would be able to get list of all exploration steps and decisions are statement bundle create time and then also generate this from the statement bundle and diff them. This might help us to understand where/why we sometimes pick a different plan in the prod env than we do using explain from statement bundle recreate env.

Jira issue: CRDB-26024

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.