sstablemetadata
Utility for printing metadata about a specified SSTable.
The
sstablemetadata
utility prints metadata about a specified
SSTable, including:- SSTable name
- Partitioner
- SSTable level (for LeveledCompactionStrategy (LCS) only)
- Timestamps (in epoch time) indicating the number of tombstones that are estimated to be dropped at that time
- Information on row sizes and number of cells in a row, where Count is either
the size in bytes when correlated with the Row Size column (number of rows
with the size in Count), or number of cells when correlated with the value
in the Cell Count column (number of rows with that number of cells). For
example, given the following output, for the Count column value of
45
,2148
rows are45
bytes in size, and6467
rows have45
cells:Count Row Size Cell Count 1 0 10237522 22 0 189 24 0 636 45 2148 6467 56 1256 5679 78 570 15803
Note: The Row Size and Cell Count columns are independent and unrelated.
Use this report to troubleshoot wide rows or performance-degrading tombstones.
Procedure
Enter the command
sstablemetadata
followed by the filenames of
one or more SSTables.
sstablemetadata sstable_name filenames
Tarball and Installer No-Services path:
installation_location/resources/cassandra/tools/bin
tools/bin/sstablemetadata data/data/autogeneratedtest/transaction_by_retailer-f27e4d5078dc11e59d629d03f52e8a2b/ma-203-big-Data.db
SSTable: data/data/autogeneratedtest/transaction_by_retailer-f27e4d5078dc11e59d629d03f52e8a2b/ma-203-big
Partitioner: org.apache.cassandra.dht.Murmur3Partitioner
Bloom Filter FP chance: 0.010000
Minimum timestamp: 1445871871053006
Maximum timestamp: 1445871953354005
SSTable max local deletion time: 2147483647
Compression ratio: -1.0
Estimated droppable tombstones: 0.0
SSTable Level: 0
Repaired at: 0
ReplayPosition(segmentId=1445871179392, position=18397674)
Estimated tombstone drop times:
2147483647: 7816721
Count Row Size Cell Count
1 0 0
2 0 0
3 0 0
4 0 710611
5 0 0
6 0 0
7 81 0
8 710530 0
10 0 0
12 0 0
...
1179032288322 0
1414838745986 0
Estimated cardinality: 722835