cassandra_table_size.py

#!/usr/bin/env python
import re
import sys

keyspace, table, size_in_gb = 'unknown', 'unknown', 0.0

for line in sys.stdin.readlines():
  if 'Keyspace:' in line:
    m = re.search(r'Keyspace: (?P<keyspace>\w+)', line)
    keyspace = m.group('keyspace')
    continue
  if 'Table:' in line:
    m = re.search(r'Table: (?P<table>\w+)', line)
    table = m.group('table')
    continue
  if 'Space used (total):' in line:
    m = re.search(r'Space used \(total\): (?P<size>\d+)', line)
    size_in_bytes = int(m.group('size'))
    size_in_gb = size_in_bytes / 1024.0 / 1024.0 / 1024.0
    print(keyspace, table, size_in_gb)
    continue