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 are 45 bytes in size, and 6467 rows have 45 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