Skip to content

Add index create_date to crdb_internal.table_indexes #72626

@kevin-v-ngo

Description

@kevin-v-ngo

Knowing when an index was created will help developers determine whether they should drop the index if there has been no reads on that index. If the index was created 'far' in the past with no reads, it's a definite signal to drop. If it was recently created, the developer may want to hold off until they run their workload to see if the index will be used. This would complement crdb_internal.index_usage_statistics.

Epic: CRDB-9075

Metadata

Metadata

Assignees

Labels

C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions