'How to check keyspace and table size in Amazon Keyspaces
We recently migrated from Cassandra to AWS Keyspaces and I am just wondering how to check for table and keyspace total size in AWS keyspaces. Any help or suggestions are much appreciated.
Solution 1:[1]
currently there is no direct way to get the keyspace/table storage metrics, but you can certainly calculate the storage size if you are aware of no.of rows in the table
size of each row is calculate based on
partition key columns + clustering columns + regular columns + row metadata = total encoded size of row
for more info on how to calculate refer
https://docs.aws.amazon.com/keyspaces/latest/devguide/working-with-rows.html#calculating-row-size
https://docs.aws.amazon.com/keyspaces/latest/devguide/cql.elements.html#cql.data-types
FYI you will be able to see the storage in the cost explorer
Solution 2:[2]
i guess you have multiply number of rows * row_size https://docs.aws.amazon.com/keyspaces/latest/devguide/working-with-rows.html#calculating-row-size
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Rathan |
| Solution 2 | user6238251 |