nodetool tablehistograms

Get 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.

Synopsis

nodetool options tablehistograms
[--] keyspace_name table_name

Tarball and Installer No-Services path:

<installation_location>/resources/cassandra/bin

Options

Short Long Description

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 an option.

-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 an option.

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.

nodetool tablehistograms

Synopsis

Options

Example

See also

Was this helpful?

Give Feedback