cockroachdb / cockroachdb/cockroach
insights: recommends dropping indexes for db/tables not used any more
Open
A-sql-observability
C-bug
T-observability
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
The schema recommendations should ignore any table that has 0 reads in the last 7 days.
1. It's a new table and they have not migrated workloads over to yet, and removing the indexes could causes issues once the table starts to be used.
2. The customer migrated to a new table so dropping the indexes will not be useful, and could cause issue if they ever need to go back to that table to verify data.
Jira issue: CRDB-23953
Contributor guide
Assessment
This issue has not been assessed yet.