Is there an easy way to find out the average row size of a table in DSE Cassandra?
Hi! You can gather some information from sstablemetadata:
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!
7 People are following this question.