cockroachdb / cockroachdb/cockroach
sql/stats: automatically collect partial statistics on arbitrary constraints
Open
A-sql-table-stats
C-enhancement
O-support
P-2
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
Building on #93998, we should automatically trigger constrained stats collections based on feedback from query execution. Whenever a scan in a query reads massively more rows than it expects, we should trigger partial stats collection for the spans in that scan. This should help the system quickly react to bad query plans by gathering more accurate statistics.
Jira issue: CRDB-54141
Epic CRDB-55121
Contributor guide
Assessment
This issue has not been assessed yet.