cockroachdb / cockroachdb/cockroach

debug.zip: crdb_internal.index_usage_statistics.txt only has data for system database

Open
#94,714 0 comments 0 reactions 0 assignees View on GitHub
C-enhancement
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.**
The index usage statistics in a debug.zip (in the file crdb_internal.index_usage_statistics.txt) only contains information about indexes in the system database.

**Describe the solution you'd like**
crdb_internal.index_usage_statistics.txt should contain information about indexes in all databases.

**Describe alternatives you've considered**
The only alternative is to extract the index usage information from the running cluster.

**Additional context**
crdb_internal.create_statements.txt contains create statements for all databases (in a running cluster only the create statements or the current database are visible from crdb_internal.create_statements) so maybe the same mechanism can be used to gather index usage information into the debug.zip.

Jira issue: CRDB-23097

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.