nodetool tablehistograms

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


nodetool options tablehistograms
[--] keyspace_name table_name

Tarball and Installer No-Services path:

Short Long Description



Hostname or IP address.



Port number.



Password file path.






Remote JMX agent username.


Name of keyspace.


Name of table.


Separates an option from an argument that could be mistaken for an option.


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.


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

nodetool tablehistograms wiki solr


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.

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000,