[CASSANDRA-18498] Add option to sstablepartitions for aggregating stats

• Type: Improvement
• Status: Triage Needed
• Priority: Normal
• Resolution: Unresolved
• Component/s: Tool/sstable
• Platform: All
• Assignee: Unassigned
• Reporter: Andres de la Peña
• Created: 04/May/23 14:56
• Updated: 02/Jan/24 16:05

Description

The sstablepartitions offline tool added by CASSANDRA-8720 processes sstables one by one. If a partition is spread across multiple sstables, the tool will separately report the metrics of the partition fragment on each sstable. For example, if we are looking for partitions larger than 100MiB, and a partition has a 50MiB fragment in one table and 50MiB in another table, the partition won't be found.

It would be useful to add a kind of --aggregate option to sstablepartitions so it aggregates the results of all the analyzed sstables that belong to the same table.

Issue Links

• is a child of: CASSANDRA-8720 Provide tools for finding wide row/partition keys