I've seen references to a
‘Number of key(estimate) from running
nodetool cfstats, but at least in my system (Cassandra version 3.11.3), I don't see it:
Table: XXXXXX SSTable count: 4 Space used (live): 2393755943 Space used (total): 2393755943 Space used by snapshots (total): 0 Off heap memory used (total): 2529880 SSTable Compression Ratio: 0.11501749368144083 Number of partitions (estimate): 1146 Memtable cell count: 296777 Memtable data size: 147223380 Memtable off heap memory used: 0 Memtable switch count: 127 Local read count: 9 Local read latency: NaN ms Local write count: 44951572 Local write latency: 0.043 ms Pending flushes: 0 Percent repaired: 0.0 Bloom filter false positives: 0 Bloom filter false ratio: 0.00000 Bloom filter space used: 2144 Bloom filter off heap memory used: 2112 Index summary off heap memory used: 240 Compression metadata off heap memory used: 2527528 Compacted partition minimum bytes: 447 Compacted partition maximum bytes: 43388628 Compacted partition mean bytes: 13547448 Average live cells per slice (last five minutes): NaN Maximum live cells per slice (last five minutes): 0 Average tombstones per slice (last five minutes): NaN Maximum tombstones per slice (last five minutes): 0 Dropped Mutations: 0
Is there some way to approximate
select count(*) from XXXXXX with this version of Cassandra?