nodetool refreshsizeestimates
Refreshes the size estimates table.
Synopsis
Section titled “Synopsis”nodetool [connection_options] refreshsizeestimatesSee connection options for connection options.
Description
Section titled “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
Section titled “Examples”Basic Usage
Section titled “Basic Usage”nodetool refreshsizeestimatesWhen to Use
Section titled “When to Use”After Major Data Changes
Section titled “After Major Data Changes”# After bulk loadnodetool refreshsizeestimatesBefore Capacity Planning
Section titled “Before Capacity Planning”# Get fresh estimates for planningnodetool refreshsizeestimates
# Query estimatescqlsh -e "SELECT * FROM system.size_estimates LIMIT 10;"After Compaction
Section titled “After Compaction”# Update estimates after major compactionnodetool refreshsizeestimatesSize Estimates Table
Section titled “Size Estimates Table”SELECT keyspace_name, table_name, range_start, range_end, mean_partition_size, partitions_countFROM system.size_estimates;Related Commands
Section titled “Related Commands”| Command | Relationship |
|---|---|
| tablestats | Detailed table statistics |
| ring | Token range information |