Skip to content

nodetool refreshsizeestimates

Refreshes the size estimates table.

Synopsis

nodetool [connection_options] refreshsizeestimates

Description

nodetool refreshsizeestimates updates the system.size_estimates table with current partition count and data size estimates for each table. These estimates are used by drivers for query planning and range scans.

Examples

Basic Usage

nodetool refreshsizeestimates

When to Use

After Major Data Changes

# After bulk load
nodetool refreshsizeestimates

Before Capacity Planning

# Get fresh estimates for planning
nodetool refreshsizeestimates

# Query estimates
cqlsh -e "SELECT * FROM system.size_estimates LIMIT 10;"

After Compaction

# Update estimates after major compaction
nodetool refreshsizeestimates

Size Estimates Table

SELECT keyspace_name, table_name, range_start, range_end,
       mean_partition_size, partitions_count
FROM system.size_estimates;
Command Relationship
tablestats Detailed table statistics
ring Token range information