analyzing-schema-change-storage-risk - Estimate storage requirements for online schema changes
Estimates storage requirements for CockroachDB online schema change backfills using SHOW RANGES WITH DETAILS to avoid disk exhaustion.
Tags
Updated: 2026-09-19Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Check store free space
- Estimate table index size
- Calculate required storage headroom
- Check paused schema change jobs
Inputs
- Target table name
- CockroachDB SQL access
- Prometheus status endpoint URL
Outputs
- Index size aggregation statistics
- Paused schema change job details
Requirements
- CockroachDB SQL access