skills.rest
cockroachdb
cockroachdbOFFICIAL
Explore all skills by this author →
WebsiteGitHub

analyzing-range-distribution

Analyze CockroachDB range distribution to detect fragmentation, leaseholder hotspots, and replication health.

3|3|Updated Mar 11, 2026
Search Tags:#hotspots#cockroachdb#range-distribution#fragmentation#replication-health#show-ranges#zone-config
One-click install
npx skills add https://github.com/cockroachdb/claude-plugin --skill analyzing-range-distribution-cockroachdb
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: analyzing-range-distribution
Source: https://github.com/cockroachdb/claude-plugin/tree/main/skills/observability-and-diagnostics/analyzing-range-distribution
Command: npx skills add https://github.com/cockroachdb/claude-plugin --skill analyzing-range-distribution-cockroachdb

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Analyzes CockroachDB range distribution across tables and indexes using SHOW RANGES to identify range counts, fragmentation patterns, leaseholder placement, and replication health. It helps diagnose hotspots and verify zone configuration effects without DB Console access.

Core Features & Use Cases

  • Provides production-safe range analysis using targeted queries with LIMIT.
  • Detects fragmentation, leaseholder hotspots, and under- or over-replication to guide remediation.
  • Validates zone configurations and replication health as part of cluster observability.

Quick Start

Run a targeted SHOW RANGES query against a specific table to begin analyzing its range distribution.

Frequently Asked Questions about analyzing-range-distribution

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I identify leaseholder hotspots in CockroachDB?▼

Analyze CockroachDB range distribution using SHOW RANGES to detect leaseholder hotspots and fragmentation. Targeted LIMIT-based queries safely reveal uneven leaseholder placement causing write load concentration across multi-node clusters.

What is the best way to check range fragmentation without DB Console access?▼

Check range fragmentation without DB Console by executing targeted SHOW RANGES queries against specific tables. This reveals range counts and fragmentation patterns directly via SQL, avoiding the need for administrative UI access.

How do I validate zone configuration effects on range replication health?▼

Validate zone configuration effects on replication health by running SHOW ZONE CONFIGURATIONS alongside SHOW RANGES. This verifies whether configured replica constraints properly enforce under- or over-replication status across multi-node clusters.

Do I need ZONECONFIG privileges to run SHOW RANGES for per-table analysis?▼

Yes, ZONECONFIG privileges are required to run SHOW RANGES and SHOW ZONE CONFIGURATIONS for per-table range analysis. These permissions allow you to validate replication health and inspect leaseholder placement securely across multi-node clusters.

Are there limitations when running SHOW RANGES queries in production clusters?▼

SHOW RANGES queries in production clusters risk performance impact if executed broadly. Apply LIMIT-based guardrails to target specific tables, preventing system overload while diagnosing hotspots and replication health safely.

Related Skills

Explore More Data & Analytics Skills→
cockroachlabscockroachlabs
18

analyzing-range-distribution

Diagnose range distribution and fragmentation in CockroachDB using SHOW RANGES queries.

Official
Advanced
interflownexinterflownex
2

alloydb-postgres-replication

Monitors PostgreSQL replication health and manages synchronization states in AlloyDB clusters.

Community
Advanced
cockroachdbcockroachdb
3

reviewing-cluster-health

Diagnose CockroachDB cluster health with read-only crdb_internal queries.

Official
Advanced
cockroachdbcockroachdb
3

configuring-sso-and-scim

Configure SSO and SCIM integration for CockroachDB across Cloud Console, DB Console, and SQL/Cluster.

Official
Advanced