Was this page helpful?
Caution
You're viewing documentation for a previous version. Switch to the latest stable version.
Nodetool tablestats¶
Provides statistics about one or more tables.
Syntax¶
nodetool tablestats [<keyspace.cfname>...]
Typically, the keyspace and cfname are separated by a dot character. However, if either of them contains a dot, you can
use a forward slash character (/) as a delimiter. For example:
nodetool tablestats my.keyspace/my.cfname
In addition, when you specify the keyspace without any cfname (to obtain statistics for all the tables in that keyspace),
and the keyspace name contains a dot, you need to add / to the keyspace name to indicate that the entire string before
the slash refers to a keyspace. For example:
nodetool tablestats my.keyspace/
If you don’t add /, nodetool will assume that “my” is the keyspace and “keyspace” is the cfname.
Example¶
nodetool tablestats
Example output:
Keyspace: keyspace1
Read Count: 0
Read Latency: NaN ms.
Write Count: 41656
Write Latency: 0.016199467063568274 ms.
Pending Flushes: 0
Table: standard1
SSTable count: 17
SSTables in each level: [ ]
Space used (live): 28331544
Space used (total): 38060888
Space used by snapshots (total): 0
Off heap memory used (total): 5505072
SSTable Compression Ratio: 0.0
Number of partitions (estimate): 26829
Memtable cell count: 4868
Memtable data size: 4128083
Memtable off heap memory used: 4980736
Memtable switch count: 0
Local read count: 0
Local read latency: NaN ms
Local write count: 41656
Local write latency: 0.014 ms
Pending flushes: 0
Bloom filter false positives: 0
Bloom filter false ratio: 0.00000
Bloom filter space used: 0
Bloom filter off heap memory used: 524336
Index summary off heap memory used: 0
Compression metadata off heap memory used: 0
Compacted partition minimum bytes: 259
Compacted partition maximum bytes: 310
Compacted partition mean bytes: 310
Average live cells per slice (last five minutes): 0.0
Maximum live cells per slice (last five minutes): 0.0
Average tombstones per slice (last five minutes): 0.0
Maximum tombstones per slice (last five minutes): 0.0
Parameter |
Description |
|---|---|
Keyspace |
The keyspace name |
Read Count |
The total number of reads count since last boot |
Read Latency |
The average read latency |
Write Count |
The total number of writes since last boot |
Write Latency |
The average read latency |
Pending Flushes |
Number of flushes that start but did not finished yet |
Table |
table name |
SSTable count |
The number of live sstable |
SSTables in each level |
In leveled compaction report the number of sstables and size per level |
Space used (live) |
The disk space of the live sstables |
Space used (total) |
The disk space of all sstables |
Space used by snapshots (total) |
The space on disk used by snapshots |
Off heap memory used (total) |
The memory used by memtable, bloom filter, index summary and compression metadata |
SSTable Compression Ratio |
The ratio of the SSTable compression |
Number of keys (estimate) |
The estimated row count (based on the estimated histogram) |
Memtable cell count |
memtable column count |
Memtable data size |
Used space of lived memetable |
Memtable off heap memory used |
Memory taken by all memtable. In syclla, all memory is off heap |
Memtable switch count |
The number sstable was switched (flushed) |
Local read count |
Number of read operations |
Local read latency |
Mean read operation time |
Local write count |
Number of write operation |
Local write latency |
Mean write operation time |
Pending flushes |
Number of sstables waiting to be flushed |
Bloom filter false positives |
Number of false positive made by the bloom filter |
Bloom filter false ratio |
The ratio between the false positive and overall attempts |
Bloom filter space used |
Memory taken by the bloom filter |
Bloom filter off heap memory used |
In scylla all memory is off heap |
Index summary off heap memory used |
Memory taken by the Index summary |
Compression metadata off heap memory used |
Off heap memory used for metadata compression |
Compacted partition minimum bytes |
Minimum bytes used for partition compression |
Compacted partition maximum bytes |
Maximum bytes used for partition compression |
Compacted partition mean bytes |
Mean bytes used for partition compression |
Average live cells per slice (last five minutes) |
Average live cells per slice |
Maximum live cells per slice (last five minutes) |
Maximum live cells per slice |
Average tombstones per slice (last five minutes) |
Average tombstones per slice |
Maximum tombstones per slice (last five minutes) |
Maximum tombstones per slice |