skills.rest
cockroachlabs
cockroachlabsOFFICIAL
Explore all skills by this author →
WebsiteGitHub

analyzing-range-distribution

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

18|8|Updated Feb 19, 2026
Search Tags:#cockroachdb#range-distribution#fragmentation#leaseholders#replication-health#zone-configurations
One-click install
npx skills add https://github.com/cockroachlabs/cockroachdb-skills --skill analyzing-range-distribution
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: analyzing-range-distribution
Source: https://github.com/cockroachlabs/cockroachdb-skills/tree/main/skills/observability-and-diagnostics/analyzing-range-distribution
Command: npx skills add https://github.com/cockroachlabs/cockroachdb-skills --skill analyzing-range-distribution

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Identify and diagnose range distribution and fragmentation across tables and indexes in CockroachDB without DB Console access, surfacing hotspots and replication health issues.

Core Features & Use Cases

  • Identify fragmentation and range counts per table/index using SHOW RANGES
  • Detect leaseholder hotspots and replication health issues to guide zone-config changes
  • Validate zone configurations against observed range placement and replication patterns

Quick Start

Run SHOW RANGES FROM TABLE your_table_name to view range distribution and identify hotspots, then compare with zone configurations.

Frequently Asked Questions about analyzing-range-distribution

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

FAQPage Schema
How do I check CockroachDB range distribution and fragmentation without DB Console access?▼

You can analyze CockroachDB range distribution by querying SHOW RANGES FROM TABLE to surface range counts, fragmentation, and leaseholder hotspots without requiring DB Console access. This approach validates zone configurations and replication health.

How do I detect leaseholder hotspots in CockroachDB tables and indexes?▼

Detect CockroachDB leaseholder hotspots by running SHOW RANGES queries to analyze range distribution and identify uneven leaseholder placement. This surfaces replication health issues and guides zone configuration changes for better balance.

Do I need admin privileges to run CockroachDB range and zone configuration queries?▼

Yes, you need admin privileges to run CockroachDB range and zone configuration queries. These permissions are required to execute SHOW RANGES commands and validate zone configurations against observed range placement and replication patterns.

Why does my CockroachDB table have range fragmentation across indexes?▼

CockroachDB range fragmentation occurs when tables and indexes split into excessive ranges. Querying SHOW RANGES FROM TABLE analyzes range counts and distribution to identify fragmentation issues and zone config placement problems.

Can I validate CockroachDB zone configurations against observed range placement?▼

Yes, you can validate CockroachDB zone configurations by comparing them against observed range placement and replication patterns. Querying SHOW RANGES reveals distribution data to confirm whether zone configs are applied correctly.

Related Skills

Explore More Data & Analytics Skills→
cockroachdbcockroachdb
3

analyzing-range-distribution

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

Official
Advanced
interflownexinterflownex
2

alloydb-postgres-replication

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

Community
Advanced
AltinityAltinity
16

altinity-expert-clickhouse-overview

Aggregate ClickHouse health data by executing predefined SQL system queries.

Official
Intermediate
GDSDNGDSDN
3

db-explain

Analyze PostgreSQL query plans with EXPLAIN ANALYZE to identify bottlenecks.

Community
Advanced