[ https://issues.apache.org/jira/browse/CASSANDRA-11483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15223655#comment-15223655 ]
Chris Lohfink commented on CASSANDRA-11483: ------------------------------------------- While at it, included ansi colors and some extra info !Screen Shot 2016-04-03 at 11.40.32 PM.png|width=500! Boring example: {code} SSTable: /Users/clohfink/git/sstable-tools/src/test/resources/ma-2-big Partitions: 1 Rows: 1 Tombstones: 0 Cells: 4 Widest Partitions: [frodo] 1 Largest Partitions: [frodo] 104 Partitioner: org.apache.cassandra.dht.Murmur3Partitioner Bloom Filter FP chance: 0.01 Minimum timestamp: 1455937221199050 (02/19/2016 21:00:21) Maximum timestamp: 1455937221199050 (02/19/2016 21:00:21) SSTable min local deletion time: 2147483647 (01/18/2038 21:14:07) SSTable max local deletion time: 2147483647 (01/18/2038 21:14:07) Compressor: org.apache.cassandra.io.compress.LZ4Compressor Compression ratio: -1.0 TTL min: 0 (0 milliseconds) TTL max: 0 (0 milliseconds) First token: 6564497868996989420 (frodo) Last token: 6564497868996989420 (frodo) minClustringValues: [] maxClustringValues: [] Estimated droppable tombstones: 0.0 SSTable Level: 0 Repaired at: 0 (12/31/1969 18:00:00) ReplayPosition(segmentId=1455937219425, position=41561) totalColumnsSet: 4 totalRows: 1 Estimated tombstone drop times: Drop Time | Count (%) Histogram 2147483647 (01/18/2038 21:14:07) | 4 (100) ██████████████████████████████ Percentiles 50th 2395318855 (11/26/2045 08:20:55) 75th 2395318855 (11/26/2045 08:20:55) 95th 2395318855 (11/26/2045 08:20:55) 98th 2395318855 (11/26/2045 08:20:55) 99th 2395318855 (11/26/2045 08:20:55) Min 1996099047 (04/02/2033 18:57:27) Max 2395318855 (11/26/2045 08:20:55) Partition Size: Size (bytes) | Count (%) Histogram 50 (50 B) | 1 (100) ██████████████████████████████ Percentiles 50th 50 (50 B) 75th 50 (50 B) 95th 50 (50 B) 98th 50 (50 B) 99th 50 (50 B) Min 43 (43 B) Max 50 (50 B) Column Count: Columns | Count (%) Histogram 4 | 1 (100) ██████████████████████████████ Percentiles 50th 4 75th 4 95th 4 98th 4 99th 4 Min 4 Max 4 Estimated cardinality: 1 EncodingStats minTTL: 0 (0 milliseconds) EncodingStats minLocalDeletionTime: 1442880000 (01/17/1970 10:48:00) EncodingStats minTimestamp: 1455937221199050 (02/19/2016 21:00:21) KeyType: org.apache.cassandra.db.marshal.UTF8Type ClusteringTypes: [] StaticColumns: RegularColumns: password:org.apache.cassandra.db.marshal.UTF8Type, gender:org.apache.cassandra.db.marshal.UTF8Type, state:org.apache.cassandra.db.marshal.UTF8Type, birth_year:org.apache.cassandra.db.marshal.LongType {code} Slightly more interesting: {code} SSTable: /Users/clohfink/git/sstable-tools/ma-119-big Partitions: 22515 Rows: 13579337 Tombstones: 0 Cells: 13579337 Widest Partitions: [12345] 999999 [99049] 62664 [99007] 60437 [99017] 59728 [99010] 59555 Largest Partitions: [12345] 189888705 [99049] 2965017 [99007] 2860391 [99017] 2826094 [99010] 2818038 Partitioner: org.apache.cassandra.dht.Murmur3Partitioner Bloom Filter FP chance: 0.01 Minimum timestamp: 1456554952195298 (02/27/2016 00:35:52) Maximum timestamp: 1456594562846756 (02/27/2016 11:36:02) SSTable min local deletion time: 2147483647 (01/18/2038 21:14:07) SSTable max local deletion time: 2147483647 (01/18/2038 21:14:07) Compressor: org.apache.cassandra.io.compress.LZ4Compressor Compression ratio: 0.3068105022732033 TTL min: 0 (0 milliseconds) TTL max: 0 (0 milliseconds) First token: 286432166153517 (21139) Last token: 9223106912315136675 (21299) minClustringValues: [1] maxClustringValues: [999999] Estimated droppable tombstones: 0.0 SSTable Level: 0 Repaired at: 0 (12/31/1969 18:00:00) ReplayPosition(segmentId=1456414025108, position=16709244) totalColumnsSet: 13579337 totalRows: 13579337 Estimated tombstone drop times: Drop Time | Count (%) Histogram 2147483647 (01/18/2038 21:14:07) | 27158674 (100) ██████████████████████████████ Percentiles 50th 2395318855 (11/26/2045 08:20:55) 75th 2395318855 (11/26/2045 08:20:55) 95th 2395318855 (11/26/2045 08:20:55) 98th 2395318855 (11/26/2045 08:20:55) 99th 2395318855 (11/26/2045 08:20:55) Min 1996099047 (04/02/2033 18:57:27) Max 2395318855 (11/26/2045 08:20:55) Partition Size: Size (bytes) | Count (%) Histogram 258 (258 B) | 6 ( 0) 310 (310 B) | 20 ( 0) ▏ 372 (372 B) | 50 ( 0) ▍ 446 (446 B) | 45 ( 0) ▍ 535 (535 B) | 66 ( 0) ▌ 642 (642 B) | 62 ( 0) ▌ 770 (770 B) | 120 ( 0) █ 924 (924 B) | 116 ( 0) ▉ 1109 (1.1 kB) | 144 ( 0) █▏ 1331 (1.3 kB) | 175 ( 0) █▍ 1597 (1.6 kB) | 210 ( 0) █▊ 1916 (1.9 kB) | 248 ( 1) ██ 2299 (2.2 kB) | 324 ( 1) ██▋ 2759 (2.7 kB) | 356 ( 1) ███ 3311 (3.2 kB) | 460 ( 2) ███▉ 3973 (3.9 kB) | 534 ( 2) ████▌ 4768 (4.7 kB) | 569 ( 2) ████▊ 5722 (5.6 kB) | 667 ( 2) █████▋ 6866 (6.7 kB) | 786 ( 3) ██████▋ 8239 (8.0 kB) | 1002 ( 4) ████████▍ 9887 (9.7 kB) | 1266 ( 5) ██████████▋ 11864 (11.6 kB) | 1446 ( 6) ████████████▏ 14237 (13.9 kB) | 1779 ( 7) ███████████████ 17084 (16.7 kB) | 2081 ( 9) █████████████████▌ 20501 (20.0 kB) | 2598 ( 11) █████████████████████▉ 24601 (24.0 kB) | 3089 ( 13) ██████████████████████████ 29521 (28.8 kB) | 3555 ( 15) ██████████████████████████████ 35425 (34.6 kB) | 681 ( 3) █████▋ 42510 (41.5 kB) | 4 ( 0) 51012 (49.8 kB) | 3 ( 0) 61214 (59.8 kB) | 1 ( 0) 73457 (71.7 kB) | 2 ( 0) 88148 (86.1 kB) | 1 ( 0) 105778 (103.3 kB) | 3 ( 0) 126934 (124.0 kB) | 4 ( 0) 152321 (148.8 kB) | 3 ( 0) 182785 (178.5 kB) | 2 ( 0) 219342 (214.2 kB) | 3 ( 0) 263210 (257.0 kB) | 2 ( 0) 315852 (308.4 kB) | 3 ( 0) 454826 (444.2 kB) | 2 ( 0) 545791 (533.0 kB) | 3 ( 0) 654949 (639.6 kB) | 4 ( 0) 785939 (767.5 kB) | 3 ( 0) 943127 (921.0 kB) | 5 ( 0) 1131752 (1.1 MB) | 3 ( 0) 1358102 (1.3 MB) | 4 ( 0) 1629722 (1.6 MB) | 4 ( 0) 186563160 (177.9 MB) | 1 ( 0) Percentiles 50th 17084 (16.7 kB) 75th 24601 (24.0 kB) 95th 29521 (28.8 kB) 98th 35425 (34.6 kB) 99th 35425 (34.6 kB) Min 216 (216 B) Max 186563160 (177.9 MB) Column Count: Columns | Count (%) Histogram 10 | 41 ( 0) ▎ 12 | 39 ( 0) ▎ 14 | 32 ( 0) ▎ 17 | 63 ( 0) ▌ 20 | 64 ( 0) ▌ 24 | 102 ( 0) ▉ 29 | 120 ( 0) █ 35 | 123 ( 0) █ 42 | 165 ( 0) █▍ 50 | 189 ( 0) █▋ 60 | 220 ( 0) █▉ 72 | 313 ( 1) ██▋ 86 | 326 ( 1) ██▊ 103 | 429 ( 1) ███▋ 124 | 493 ( 2) ████▎ 149 | 566 ( 2) ████▉ 179 | 643 ( 2) █████▌ 215 | 765 ( 3) ██████▋ 258 | 949 ( 4) ████████▏ 310 | 1197 ( 5) ██████████▍ 372 | 1382 ( 6) ████████████ 446 | 1722 ( 7) ██████████████▉ 535 | 1971 ( 8) █████████████████ 642 | 2469 ( 10) █████████████████████▍ 770 | 2908 ( 12) █████████████████████████▎ 924 | 3455 ( 15) ██████████████████████████████ 1109 | 1708 ( 7) ██████████████▊ 1331 | 1 ( 0) 1916 | 3 ( 0) 2299 | 1 ( 0) 2759 | 2 ( 0) 3311 | 3 ( 0) 3973 | 1 ( 0) 4768 | 1 ( 0) 5722 | 3 ( 0) 6866 | 3 ( 0) 8239 | 3 ( 0) 9887 | 9 ( 0) 11864 | 1 ( 0) 14237 | 1 ( 0) 17084 | 1 ( 0) 20501 | 1 ( 0) 24601 | 3 ( 0) 29521 | 5 ( 0) 35425 | 4 ( 0) 42510 | 3 ( 0) 51012 | 4 ( 0) 61214 | 6 ( 0) 73457 | 1 ( 0) 1131752 | 1 ( 0) Percentiles 50th 535 75th 770 95th 1109 98th 1109 99th 1109 Min 9 Max 1131752 Estimated cardinality: 22873 EncodingStats minTTL: 0 (0 milliseconds) EncodingStats minLocalDeletionTime: 1442880000 (01/17/1970 10:48:00) EncodingStats minTimestamp: 1456554952195298 (02/27/2016 00:35:52) KeyType: org.apache.cassandra.db.marshal.UTF8Type ClusteringTypes: [org.apache.cassandra.db.marshal.UTF8Type] StaticColumns: RegularColumns: val:org.apache.cassandra.db.marshal.UTF8Type {code} > Enhance sstablemetadata > ----------------------- > > Key: CASSANDRA-11483 > URL: https://issues.apache.org/jira/browse/CASSANDRA-11483 > Project: Cassandra > Issue Type: Improvement > Components: Observability > Reporter: Chris Lohfink > Priority: Minor > Attachments: Screen Shot 2016-04-03 at 11.40.32 PM.png > > > sstablemetadata provides quite a bit of useful information but theres a few > hiccups I would like to see addressed: > * Does not use client mode > * Units are not provided (or anything for that matter). There is data in > micros, millis, seconds as durations and timestamps from epoch. But there is > no way to tell what one is without a non-trival code dive > * in general pretty frustrating to parse -- This message was sent by Atlassian JIRA (v6.3.4#6332)