nodetool tablehistograms

Provides statistics about a table that could be used to plot a frequency function.

Provides statistics about a table that could be used to plot a frequency function.

Synopsis

nodetool <options> tablehistograms -- <keyspace> <table>
  • Options are:
    • ( -h | --host ) <host name> | <ip address>
    • ( -p | --port ) <port number>
    • ( -pw | --password ) <password >
    • ( -u | --username ) <user name>
    • ( -pwf <passwordFilePath | --password-file <passwordFilePath> )
  • -- separates an option from an argument that could be mistaken for a option.
  • keyspace is the name of a keyspace.
  • table is the name of a table.

Description

The nodetool tablehistograms command provides statistics about a table, including read/write latency, partition size, column count, and number of SSTables. The report covers all operations since the last time nodetool tablehistograms was run in the current session. The use of the metrics-core library in Cassandra 2.1 and later makes the output more informative and easier to understand.

Example

For example, to get statistics about the libout table in the libdata keyspace on Linux, use this command:

install_location nodetool tablehistograms libdata libout

Output is:

libdata/libout histograms
Percentile  SSTables     Write Latency      Read Latency    Partition Size        Cell Count
                              (micros)          (micros)           (bytes)                  
50%             0.00             39.50             36.00              1597                42
75%             0.00             49.00             55.00              1597                42
95%             0.00             95.00             82.00              8239               258
98%             0.00            126.84            110.42             17084               446
99%             0.00            155.13            123.71             24601               770
Min             0.00              3.00              3.00              1110                36
Max             0.00          50772.00            314.00            126934              3973

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