cockroachdb / cockroachdb/cockroach
Provide a way to correlate the sql_full_scan_count metric with the ofending schema.table
Open
C-enhancement
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
It's difficult to identify and troubleshoot full scans over time. This issue tracks correlating the sql_full_scan_count metric with the offending schema.table that quickly guides to prevent the full scan (e.g., update statistics). For instance,
- Adding a metric label with the schema.object
Jira issue: CRDB-33529
Epic: [CRDB-32139](https://cockroachlabs.atlassian.net/browse/CRDB-32139)
Epic CRDB-32139
Contributor guide
Assessment
This issue has not been assessed yet.