tolbertam / sstable-tools

Tools for parsing, creating and doing other fun stuff with sstables
Apache License 2.0
162 stars 31 forks source link

[#65] Add --grace_grace_seconds (-g) option to describe #67

Closed tolbertam closed 7 years ago

tolbertam commented 7 years ago

Closes #65

Example:

without gc_grace_seconds passed in, simply only accounts for time of deletion:

Estimated droppable tombstones: 2.0
Estimated tombstone drop times:
   Drop Time                        | Count  (%)  Histogram 
   1500414744 (07/18/2017 16:52:24) |     1 ( 50) ▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉
   1500414751 (07/18/2017 16:52:31) |     1 ( 50) ▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉
   Percentiles
   50th      1663415872 (09/17/2022 06:57:52)
   75th      1663415872 (09/17/2022 06:57:52)
   95th      1663415872 (09/17/2022 06:57:52)
   98th      1663415872 (09/17/2022 06:57:52)
   99th      1663415872 (09/17/2022 06:57:52)
   Min       1386179894 (12/04/2013 11:58:14)
   Max       1663415872 (09/17/2022 06:57:52)

With gc_grace_seconds provided (864000, 10 days):

Estimated droppable tombstones: 0.0
Estimated tombstone drop times:
   Drop Time                        | Count  (%)  Histogram 
   1501278744 (07/28/2017 16:52:24) |     1 ( 50) ▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉
   1501278751 (07/28/2017 16:52:31) |     1 ( 50) ▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉▉
   Percentiles
   50th      1664279872 (09/27/2022 06:57:52)
   75th      1664279872 (09/27/2022 06:57:52)
   95th      1664279872 (09/27/2022 06:57:52)
   98th      1664279872 (09/27/2022 06:57:52)
   99th      1664279872 (09/27/2022 06:57:52)
   Min       1387043894 (12/14/2013 11:58:14)
   Max       1664279872 (09/27/2022 06:57:52)

One odd thing to me is that the percentiles don't really seem to make sense. Could just be that the data set is really small here (2 deletes) so it doesn't have enough data to be meaningful?