Analyzing Range Distribution

Analyzes CockroachDB range distribution, leaseholder placement, and zone configuration compliance using SHOW RANGES and SHOW ZONE CONFIGURATIONS commands. Identifies range count anomalies, size imbalances, leaseholder hotspots, and replication issues - entirely via SQL without requiring DB Console access.

Complement to profiling skills: This skill analyzes range-level data distribution; for query performance patterns, see profiling-statement-fingerprints. For schema change storage planning, see analyzing-schema-change-storage-risk.

When to Use This Skill

• Identify tables/indexes with excessive range counts indicating fragmentation
• Detect range size imbalances or uneven data distribution across nodes
• Investigate leaseholder concentration causing read hotspots
• Validate zone configuration effects on range placement and replica distribution
• Diagnose range-level replication issues (under-replicated or unavailable ranges)
• Analyze range split patterns from high write volume
• SQL-only range analysis without DB Console access

For schema change planning: Use analyzing-schema-change-storage-risk to estimate storage requirements before CREATE INDEX or ADD COLUMN operations.

Prerequisites