question

Hi! You can gather some information from sstablemetadata:

https://docs.datastax.com/en/dse/5.1/dse-dev/datastax_enterprise/tools/toolsSStables/toolsSSTableMetadata.html

As the example given in the link above:

Count               Row Size        Cell Count
1                          0          10237522
22                         0               189
24                         0               636
45                      2148              6467
56                      1256              5679
78                       570             15803

The output varies by version though, so it depends on what version of Cassandra or dse you're on.

You can run this command to get statistics on a table:

$ nodetool tablestats ks_name.table_name

One of the statistics collected for tables is the Compacted partition mean size which shows the average partition size for a table.

Note that almost all nodetool commands only provide information about a specific node. If you want the average for the whole cluster, you will need to run the command on all nodes.

For more info, see the nodetool tablestats page in the Docs. Cheers!