nodetool tablehistograms

Provides current performance metrics for read and write operations during the past fifteen minutes.

Initial troubleshooting and performance metrics that provide current performance statics for read and write latency on a table during the past fifteen minutes.

Synopsis

nodetool options tablehistograms 
[--] keyspace_name table_name
Tarball and Installer No-Services path:
installation_location/resources/cassandra/bin
Table 1. Options
Short Long Description
-h --host Hostname or IP address.
-p --port Port number.
-pwf --password-file Password file path.
-pw --password Password.
-u --username Remote JMX agent username.
keyspace_name Name of keyspace.
table_name Name of table.
-- Separates an option from an argument that could be mistaken for a option.

Description

nodetool tablehistograms shows table performance statistics over the past fifteen minutes, including read/write latency, partition size, cell count, and number of SSTables. Use this tool to analyze performance and tune individual tables and ensure that the percent latency level meets the SLA for the data stored in the table.

Example

For example, to get statistics for the DSE Search wiki demo solr table, use this command:

nodetool tablehistograms wiki solr

Output:

wiki/solr histograms
Percentile  SSTables     Write Latency      Read Latency    Partition Size        Cell Count
                              (micros)          (micros)           (bytes)
50%             1.00            126.93            654.95              2759                 3
75%             1.00            152.32           1358.10              5722                 3
95%             1.00            785.94           5839.59             17084                 3
98%             1.00           1629.72          12108.97             29521                 3
99%             1.00           2346.80          12108.97             42510                 3
Min             1.00             73.46            219.34               104                 3
Max             1.00           2346.80          12108.97            219342                 3

The output shows the percentile rank of read and write latency values, the partition size, and the cell count for the table.