Was this page helpful?
Caution
You're viewing documentation for an unstable version of ScyllaDB Manual. Switch to the latest stable version.
Nodetool cfhistograms (tablehistograms)¶
cfhistograms <keyspace> <cfname>- This command provides statistics about a table, including number of SSTables, read/write latency, partition size and column count. Read/write latencies are computed over a recent moving window. Note that this command can also be used for tablehistograms. This command uses the following syntax:
nodetool cfhistograms keyspaces cfname
For example: to get statistics about the standard1 table in the keyspaces1 keyspace, use this command:
nodetool cfhistograms keyspaces1 standard1
Percentile |
SSTables |
Write Latency |
Read Latency |
Partition Size |
Cell Count |
|---|---|---|---|---|---|
50% |
10.00 |
42.00 |
20.00 |
210 |
5 |
75% |
20.00 |
42.00 |
24.00 |
280 |
5 |
95% |
25.00 |
42.00 |
42.00 |
300 |
5 |
98% |
25.00 |
42.00 |
770.00 |
310 |
5 |
99% |
26.00 |
42.00 |
2759.00 |
310 |
5 |
Min |
00.00 |
36.00 |
7.00 |
210 |
5 |
Max |
26.00 |
42.00 |
35425.00 |
310 |
5 |
In this example, 95% of the write latency measurements were 42 microseconds (μs) or less, 95% of the read latencies were 42 μs or less, and 95% of the partitions are 300 bytes or less. The SSTables column means that the 95% of all single-key read requests touched at most 25 SSTables.
Parameter |
Description |
|---|---|
SSTables |
Distribution number of sstable per read |
Write Latency |
Distribution of the Write Latency |
Read Latency |
Distribution of the Read Latency |
Partition Size |
Estimated row size |
Cell Count |
Estimated column count |