| NAME |
| nodetool tablestats - Print statistics on tables |
| |
| SYNOPSIS |
| nodetool [(-h <host> | --host <host>)] [(-p <port> | --port <port>)] |
| [(-pp | --print-port)] [(-pw <password> | --password <password>)] |
| [(-pwf <passwordFilePath> | --password-file <passwordFilePath>)] |
| [(-u <username> | --username <username>)] tablestats |
| [(-F <format> | --format <format>)] [(-H | --human-readable)] [-i] |
| [(-l | --sstable-location-check)] [(-s <sort_key> | --sort <sort_key>)] |
| [(-t <top> | --top <top>)] [--] [<keyspace.table>...] |
| |
| OPTIONS |
| -F <format>, --format <format> |
| Output format (json, yaml) |
| |
| -h <host>, --host <host> |
| Node hostname or ip address |
| |
| -H, --human-readable |
| Display bytes in human readable form, i.e. KiB, MiB, GiB, TiB |
| |
| -i |
| Ignore the list of tables and display the remaining tables |
| |
| -l, --sstable-location-check |
| Check whether or not the SSTables are in the correct location. |
| |
| -p <port>, --port <port> |
| Remote jmx agent port number |
| |
| -pp, --print-port |
| Operate in 4.0 mode with hosts disambiguated by port number |
| |
| -pw <password>, --password <password> |
| Remote jmx agent password |
| |
| -pwf <passwordFilePath>, --password-file <passwordFilePath> |
| Path to the JMX password file |
| |
| -s <sort_key>, --sort <sort_key> |
| Sort tables by specified sort key |
| (average_live_cells_per_slice_last_five_minutes, |
| average_tombstones_per_slice_last_five_minutes, |
| bloom_filter_false_positives, bloom_filter_false_ratio, |
| bloom_filter_off_heap_memory_used, bloom_filter_space_used, |
| compacted_partition_maximum_bytes, compacted_partition_mean_bytes, |
| compacted_partition_minimum_bytes, |
| compression_metadata_off_heap_memory_used, full_name, |
| index_summary_off_heap_memory_used, local_read_count, |
| local_read_latency_ms, local_write_latency_ms, |
| maximum_live_cells_per_slice_last_five_minutes, |
| maximum_tombstones_per_slice_last_five_minutes, |
| memtable_cell_count, memtable_data_size, |
| memtable_off_heap_memory_used, memtable_switch_count, |
| number_of_partitions_estimate, off_heap_memory_used_total, |
| pending_flushes, percent_repaired, read_latency, reads, |
| space_used_by_snapshots_total, space_used_live, space_used_total, |
| sstable_compression_ratio, sstable_count, table_name, |
| write_latency, writes, max_sstable_size, local_read_write_ratio, |
| twcs_max_duration, sai_local_query_latency_ms, |
| sai_post_filtering_read_latency, sai_disk_used_bytes, |
| sai_sstable_indexes_hit, sai_index_segments_hit sai_rows_filtered, |
| sai_total_query_timeouts, sai_total_queryable_index_ratio) |
| |
| -t <top>, --top <top> |
| Show only the top K tables for the sort key (specify the number K |
| of tables to be shown |
| |
| -u <username>, --username <username> |
| Remote jmx agent username |
| |
| -- |
| This option can be used to separate command-line options from the |
| list of argument, (useful when arguments might be mistaken for |
| command-line options |
| |
| [<keyspace.table>...] |
| List of tables (or keyspace) names |