The table has 24 sstables with size tiered compaction, when I run nodetool
tablehistograms I see 99% percentile of the queries are showing up 24 as
the number of sstables. But the read latency is very low, my understanding
from the tableshistograms's sstable column is - it shows how many sstables
were read to complete the query. If so reading 24 sstables should take
sometime, at least maybe couple of seconds. Am I missing something here?
Does checking against index/bloom filters count towards sstable counter as
well?
Percentile SSTables Write Latency Read Latency Partition
Size Cell Count
(micros) (micros) (bytes)
50% 24.00 17.08 17436.92
310 6
75% 24.00 24.60 20924.30
446 6
95% 24.00 42.51 62479.63
770 10
98% 24.00 51.01 74975.55
1597 17
99% 24.00 61.21 74975.55
3311 24
Min 18.00 2.30 4866.32
87 0
Max 24.00 943.13 89970.66
545791 17084
