How do I get the size of a Cassandra table using the Python driver?

Question

To archive this using Cassendra Shell :

nodetool cfstats -- <keyspace>.<tablename>

Python Package - cassendra-driver

Docs - cassendra

score 1 · Answer 1 · answered Mar 24 '22 at 10:28

1

The metrics in nodetool tablestats (formerly cfstats) is not exposed to the drivers so you cannot get this information via CQL.

These metrics are only exposed via JMX. Cheers!

answered Mar 24 '22 at 10:28

Erick Ramirez

13,964
1
18
23

Is there any feasible way to get size something like exporting into JSON and find size ? – abhinit21 Mar 24 '22 at 13:41

score 1 · Accepted Answer · answered Mar 24 '22 at 15:06

1

Actually, if you're running on Cassandra 4.0+, you can use Virtual Tables to achieve this:

SELECT * FROM system_views.disk_usage
WHERE keyspace_name='stackoverflow' AND table_name='baseball_stats';


 keyspace_name | table_name     | mebibytes
---------------+----------------+-----------
 stackoverflow | baseball_stats |         1

(1 rows)

I wrote an article on Virtual Tables early last month, if you'd like more information:

Leveraging Virtual Tables in Apache Cassandra 4.0

answered Mar 24 '22 at 15:06

Aaron

55,518
11
116
132

1

You're right, I didn't realise it was recorded in the virtual tables. Since they're local to a node, do you aggregate the values from all nodes? – Erick Ramirez Mar 24 '22 at 20:44
@ErickRamirez yes, that's right. – Aaron Mar 24 '22 at 21:27

How do I get the size of a Cassandra table using the Python driver?

2 Answers2