github.com/cockroachdb/pebble@v1.1.2/testdata/metrics (about) 1 example 2 ---- 3 | | | | ingested | moved | written | | amp | multilevel 4 level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w | top in read 5 ------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+----------+------------------ 6 0 | 101 102B 0B 101 | 103.0 | 104B | 112 104B | 113 106B | 221 217B | 107B | 1 2.1 | 104B 104B 104B 7 1 | 201 202B 0B 201 | 203.0 | 204B | 212 204B | 213 206B | 421 417B | 207B | 2 2.0 | 204B 204B 204B 8 2 | 301 302B 0B 301 | 303.0 | 304B | 312 304B | 313 306B | 621 617B | 307B | 3 2.0 | 304B 304B 304B 9 3 | 401 402B 0B 401 | 403.0 | 404B | 412 404B | 413 406B | 821 817B | 407B | 4 2.0 | 404B 404B 404B 10 4 | 501 502B 0B 501 | 503.0 | 504B | 512 504B | 513 506B | 1.0K 1017B | 507B | 5 2.0 | 504B 504B 504B 11 5 | 601 602B 0B 601 | 603.0 | 604B | 612 604B | 613 606B | 1.2K 1.2KB | 607B | 6 2.0 | 604B 604B 604B 12 6 | 701 702B 0B 701 | - | 704B | 712 704B | 713 706B | 1.4K 1.4KB | 707B | 7 2.0 | 704B 704B 704B 13 total | 2.8K 2.7KB 0B 2.8K | - | 2.8KB | 2.9K 2.8KB | 2.9K 2.8KB | 5.7K 8.4KB | 2.8KB | 28 3.0 | 2.8KB 2.8KB 2.8KB 14 --------------------------------------------------------------------------------------------------------------------------------------- 15 WAL: 22 files (24B) in: 25B written: 26B (4% overhead) 16 Flushes: 8 17 Compactions: 5 estimated debt: 6B in progress: 2 (7B) 18 default: 27 delete: 28 elision: 29 move: 30 read: 31 rewrite: 32 multi-level: 33 19 MemTables: 12 (11B) zombie: 14 (13B) 20 Zombie tables: 16 (15B) 21 Backing tables: 1 (2.0MB) 22 Virtual tables: 2807 (2.8KB) 23 Block cache: 2 entries (1B) hit rate: 42.9% 24 Table cache: 18 entries (17B) hit rate: 48.7% 25 Secondary cache: 0 entries (0B) hit rate: 0.0% 26 Snapshots: 4 earliest seq num: 1024 27 Table iters: 21 28 Filter utility: 47.4% 29 Ingestions: 27 as flushable: 36 (34B in 35 tables) 30 31 batch 32 set a 1 33 ---- 34 35 iter-new a 36 ---- 37 38 flush 39 ---- 40 0.0: 41 000005:[a#10,SET-a#10,SET] 42 43 # iter b references both a memtable and sstable 5. 44 45 iter-new b 46 ---- 47 48 metrics 49 ---- 50 | | | | ingested | moved | written | | amp 51 level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w 52 ------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+--------- 53 0 | 1 661B 0B 0 | 0.25 | 28B | 0 0B | 0 0B | 1 661B | 0B | 1 23.6 54 1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 55 2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 56 3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 57 4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 58 5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 59 6 | 0 0B 0B 0 | - | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 60 total | 1 661B 0B 0 | - | 28B | 0 0B | 0 0B | 1 689B | 0B | 1 24.6 61 ------------------------------------------------------------------------------------------------------------------- 62 WAL: 1 files (0B) in: 17B written: 28B (65% overhead) 63 Flushes: 1 64 Compactions: 0 estimated debt: 0B in progress: 0 (0B) 65 default: 0 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0 66 MemTables: 1 (256KB) zombie: 1 (256KB) 67 Zombie tables: 0 (0B) 68 Backing tables: 0 (0B) 69 Virtual tables: 0 (0B) 70 Block cache: 3 entries (556B) hit rate: 0.0% 71 Table cache: 1 entries (808B) hit rate: 0.0% 72 Secondary cache: 0 entries (0B) hit rate: 0.0% 73 Snapshots: 0 earliest seq num: 0 74 Table iters: 1 75 Filter utility: 0.0% 76 Ingestions: 0 as flushable: 0 (0B in 0 tables) 77 78 disk-usage 79 ---- 80 1.9KB 81 82 batch 83 set b 2 84 ---- 85 86 flush 87 ---- 88 0.0: 89 000005:[a#10,SET-a#10,SET] 90 000007:[b#11,SET-b#11,SET] 91 92 # iter c references both a memtable and sstables 5 and 7. 93 94 iter-new c 95 ---- 96 97 compact a-z 98 ---- 99 6: 100 000008:[a#0,SET-b#0,SET] 101 102 metrics 103 ---- 104 | | | | ingested | moved | written | | amp 105 level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w 106 ------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+--------- 107 0 | 0 0B 0B 0 | 0.00 | 56B | 0 0B | 0 0B | 2 1.3KB | 0B | 0 23.6 108 1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 109 2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 110 3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 111 4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 112 5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 113 6 | 1 667B 0B 0 | - | 1.3KB | 0 0B | 0 0B | 1 667B | 1.3KB | 1 0.5 114 total | 1 667B 0B 0 | - | 56B | 0 0B | 0 0B | 3 2.0KB | 1.3KB | 1 36.5 115 ------------------------------------------------------------------------------------------------------------------- 116 WAL: 1 files (0B) in: 34B written: 56B (65% overhead) 117 Flushes: 2 118 Compactions: 1 estimated debt: 0B in progress: 0 (0B) 119 default: 1 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0 120 MemTables: 1 (256KB) zombie: 2 (512KB) 121 Zombie tables: 2 (1.3KB) 122 Backing tables: 0 (0B) 123 Virtual tables: 0 (0B) 124 Block cache: 5 entries (1.1KB) hit rate: 42.9% 125 Table cache: 2 entries (1.6KB) hit rate: 66.7% 126 Secondary cache: 0 entries (0B) hit rate: 0.0% 127 Snapshots: 0 earliest seq num: 0 128 Table iters: 2 129 Filter utility: 0.0% 130 Ingestions: 0 as flushable: 0 (0B in 0 tables) 131 132 disk-usage 133 ---- 134 3.3KB 135 136 # Closing iter a will release one of the zombie memtables. 137 138 iter-close a 139 ---- 140 141 metrics 142 ---- 143 | | | | ingested | moved | written | | amp 144 level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w 145 ------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+--------- 146 0 | 0 0B 0B 0 | 0.00 | 56B | 0 0B | 0 0B | 2 1.3KB | 0B | 0 23.6 147 1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 148 2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 149 3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 150 4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 151 5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 152 6 | 1 667B 0B 0 | - | 1.3KB | 0 0B | 0 0B | 1 667B | 1.3KB | 1 0.5 153 total | 1 667B 0B 0 | - | 56B | 0 0B | 0 0B | 3 2.0KB | 1.3KB | 1 36.5 154 ------------------------------------------------------------------------------------------------------------------- 155 WAL: 1 files (0B) in: 34B written: 56B (65% overhead) 156 Flushes: 2 157 Compactions: 1 estimated debt: 0B in progress: 0 (0B) 158 default: 1 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0 159 MemTables: 1 (256KB) zombie: 2 (512KB) 160 Zombie tables: 2 (1.3KB) 161 Backing tables: 0 (0B) 162 Virtual tables: 0 (0B) 163 Block cache: 5 entries (1.1KB) hit rate: 42.9% 164 Table cache: 2 entries (1.6KB) hit rate: 66.7% 165 Secondary cache: 0 entries (0B) hit rate: 0.0% 166 Snapshots: 0 earliest seq num: 0 167 Table iters: 2 168 Filter utility: 0.0% 169 Ingestions: 0 as flushable: 0 (0B in 0 tables) 170 171 # Closing iter c will release one of the zombie sstables. The other 172 # zombie sstable is still referenced by iter b. 173 174 iter-close c 175 ---- 176 177 metrics 178 ---- 179 | | | | ingested | moved | written | | amp 180 level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w 181 ------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+--------- 182 0 | 0 0B 0B 0 | 0.00 | 56B | 0 0B | 0 0B | 2 1.3KB | 0B | 0 23.6 183 1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 184 2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 185 3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 186 4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 187 5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 188 6 | 1 667B 0B 0 | - | 1.3KB | 0 0B | 0 0B | 1 667B | 1.3KB | 1 0.5 189 total | 1 667B 0B 0 | - | 56B | 0 0B | 0 0B | 3 2.0KB | 1.3KB | 1 36.5 190 ------------------------------------------------------------------------------------------------------------------- 191 WAL: 1 files (0B) in: 34B written: 56B (65% overhead) 192 Flushes: 2 193 Compactions: 1 estimated debt: 0B in progress: 0 (0B) 194 default: 1 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0 195 MemTables: 1 (256KB) zombie: 2 (512KB) 196 Zombie tables: 1 (661B) 197 Backing tables: 0 (0B) 198 Virtual tables: 0 (0B) 199 Block cache: 3 entries (556B) hit rate: 42.9% 200 Table cache: 1 entries (808B) hit rate: 66.7% 201 Secondary cache: 0 entries (0B) hit rate: 0.0% 202 Snapshots: 0 earliest seq num: 0 203 Table iters: 1 204 Filter utility: 0.0% 205 Ingestions: 0 as flushable: 0 (0B in 0 tables) 206 207 disk-usage 208 ---- 209 2.7KB 210 211 # Closing iter b will release the last zombie sstable and the last zombie memtable. 212 213 iter-close b 214 ---- 215 216 metrics 217 ---- 218 | | | | ingested | moved | written | | amp 219 level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w 220 ------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+--------- 221 0 | 0 0B 0B 0 | 0.00 | 56B | 0 0B | 0 0B | 2 1.3KB | 0B | 0 23.6 222 1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 223 2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 224 3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 225 4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 226 5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 227 6 | 1 667B 0B 0 | - | 1.3KB | 0 0B | 0 0B | 1 667B | 1.3KB | 1 0.5 228 total | 1 667B 0B 0 | - | 56B | 0 0B | 0 0B | 3 2.0KB | 1.3KB | 1 36.5 229 ------------------------------------------------------------------------------------------------------------------- 230 WAL: 1 files (0B) in: 34B written: 56B (65% overhead) 231 Flushes: 2 232 Compactions: 1 estimated debt: 0B in progress: 0 (0B) 233 default: 1 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0 234 MemTables: 1 (256KB) zombie: 1 (256KB) 235 Zombie tables: 0 (0B) 236 Backing tables: 0 (0B) 237 Virtual tables: 0 (0B) 238 Block cache: 0 entries (0B) hit rate: 42.9% 239 Table cache: 0 entries (0B) hit rate: 66.7% 240 Secondary cache: 0 entries (0B) hit rate: 0.0% 241 Snapshots: 0 earliest seq num: 0 242 Table iters: 0 243 Filter utility: 0.0% 244 Ingestions: 0 as flushable: 0 (0B in 0 tables) 245 246 disk-usage 247 ---- 248 2.0KB 249 250 additional-metrics 251 ---- 252 block bytes written: 253 __level___data-block__value-block 254 0 54B 0B 255 1 0B 0B 256 2 0B 0B 257 3 0B 0B 258 4 0B 0B 259 5 0B 0B 260 6 33B 0B 261 262 batch 263 set c@20 c20 264 set c@19 c19 265 set c@18 c18 266 set c@17 c17 267 set c@16 c16 268 set c@15 c15 269 set c@14 c14 270 ---- 271 272 flush 273 ---- 274 0.0: 275 000010:[c@20#12,SET-c@18#14,SET] 276 000011:[c@17#15,SET-c@15#17,SET] 277 000012:[c@14#18,SET-c@14#18,SET] 278 6: 279 000008:[a#0,SET-b#0,SET] 280 281 metrics 282 ---- 283 | | | | ingested | moved | written | | amp 284 level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w 285 ------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+--------- 286 0 | 3 2.2KB 38B 0 | 0.25 | 149B | 0 0B | 0 0B | 5 3.5KB | 0B | 1 24.2 287 1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 288 2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 289 3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 290 4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 291 5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 292 6 | 1 667B 0B 0 | - | 1.3KB | 0 0B | 0 0B | 1 667B | 1.3KB | 1 0.5 293 total | 4 2.9KB 38B 0 | - | 149B | 0 0B | 0 0B | 6 4.3KB | 1.3KB | 2 29.7 294 ------------------------------------------------------------------------------------------------------------------- 295 WAL: 1 files (0B) in: 116B written: 149B (28% overhead) 296 Flushes: 3 297 Compactions: 1 estimated debt: 2.9KB in progress: 0 (0B) 298 default: 1 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0 299 MemTables: 1 (256KB) zombie: 1 (256KB) 300 Zombie tables: 0 (0B) 301 Backing tables: 0 (0B) 302 Virtual tables: 0 (0B) 303 Block cache: 0 entries (0B) hit rate: 42.9% 304 Table cache: 0 entries (0B) hit rate: 66.7% 305 Secondary cache: 0 entries (0B) hit rate: 0.0% 306 Snapshots: 0 earliest seq num: 0 307 Table iters: 0 308 Filter utility: 0.0% 309 Ingestions: 0 as flushable: 0 (0B in 0 tables) 310 311 additional-metrics 312 ---- 313 block bytes written: 314 __level___data-block__value-block 315 0 198B 38B 316 1 0B 0B 317 2 0B 0B 318 3 0B 0B 319 4 0B 0B 320 5 0B 0B 321 6 33B 0B 322 323 compact a-z 324 ---- 325 6: 326 000008:[a#0,SET-b#0,SET] 327 000013:[c@20#0,SET-c@16#0,SET] 328 000014:[c@15#0,SET-c@14#0,SET] 329 330 metrics 331 ---- 332 | | | | ingested | moved | written | | amp 333 level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w 334 ------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+--------- 335 0 | 0 0B 0B 0 | 0.00 | 149B | 0 0B | 0 0B | 5 3.5KB | 0B | 0 24.2 336 1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 337 2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 338 3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 339 4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 340 5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 341 6 | 3 2.2KB 41B 0 | - | 3.5KB | 0 0B | 0 0B | 3 2.2KB | 3.5KB | 1 0.6 342 total | 3 2.2KB 41B 0 | - | 149B | 0 0B | 0 0B | 8 5.9KB | 3.5KB | 1 40.5 343 ------------------------------------------------------------------------------------------------------------------- 344 WAL: 1 files (0B) in: 116B written: 149B (28% overhead) 345 Flushes: 3 346 Compactions: 2 estimated debt: 0B in progress: 0 (0B) 347 default: 2 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0 348 MemTables: 1 (256KB) zombie: 1 (256KB) 349 Zombie tables: 0 (0B) 350 Backing tables: 0 (0B) 351 Virtual tables: 0 (0B) 352 Block cache: 0 entries (0B) hit rate: 27.3% 353 Table cache: 0 entries (0B) hit rate: 58.3% 354 Secondary cache: 0 entries (0B) hit rate: 0.0% 355 Snapshots: 0 earliest seq num: 0 356 Table iters: 0 357 Filter utility: 0.0% 358 Ingestions: 0 as flushable: 0 (0B in 0 tables) 359 360 additional-metrics 361 ---- 362 block bytes written: 363 __level___data-block__value-block 364 0 198B 38B 365 1 0B 0B 366 2 0B 0B 367 3 0B 0B 368 4 0B 0B 369 5 0B 0B 370 6 143B 41B 371 372 # Flushable ingestion metrics. This requires there be data in a memtable that 373 # would overlap with the ingested table(s). Delayed flushes are disabled here to 374 # prevent the ingestion from immediately triggering a flush of the memtable. 375 # Instead, we wish to flush manually _after_ the ingestion of the two tables has 376 # completed, linking the two tables into the flushable queue. 377 378 delay-flush 379 enable 380 ---- 381 382 batch 383 set d d 384 set e e 385 set f f 386 ---- 387 388 build ext1.sst 389 set d d 390 ---- 391 392 build ext2.sst 393 set e e 394 ---- 395 396 ingest ext1.sst ext2.sst 397 ---- 398 399 build ext3.sst 400 set f f 401 ---- 402 403 ingest ext3.sst 404 ---- 405 406 delay-flush 407 disable 408 ---- 409 410 flush 411 ---- 412 0.1: 413 000015:[d#22,SET-d#22,SET] 414 000016:[e#23,SET-e#23,SET] 415 000019:[f#24,SET-f#24,SET] 416 0.0: 417 000023:[d#19,SET-f#21,SET] 418 6: 419 000008:[a#0,SET-b#0,SET] 420 000013:[c@20#0,SET-c@16#0,SET] 421 000014:[c@15#0,SET-c@14#0,SET] 422 423 # We expect the ingested-as-flushable count to be three (one for each ingested 424 # table). 425 metrics 426 ---- 427 | | | | ingested | moved | written | | amp 428 level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w 429 ------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+--------- 430 0 | 4 2.8KB 0B 0 | 0.50 | 187B | 3 2.1KB | 0 0B | 6 4.2KB | 0B | 2 22.9 431 1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 432 2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 433 3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 434 4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 435 5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0 436 6 | 3 2.2KB 41B 0 | - | 3.5KB | 0 0B | 0 0B | 3 2.2KB | 3.5KB | 1 0.6 437 total | 7 5.0KB 41B 0 | - | 2.3KB | 3 2.1KB | 0 0B | 9 8.7KB | 3.5KB | 3 3.8 438 ------------------------------------------------------------------------------------------------------------------- 439 WAL: 1 files (0B) in: 176B written: 187B (6% overhead) 440 Flushes: 8 441 Compactions: 2 estimated debt: 5.0KB in progress: 0 (0B) 442 default: 2 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0 443 MemTables: 1 (1.0MB) zombie: 1 (1.0MB) 444 Zombie tables: 0 (0B) 445 Backing tables: 0 (0B) 446 Virtual tables: 0 (0B) 447 Block cache: 12 entries (2.4KB) hit rate: 31.1% 448 Table cache: 3 entries (2.4KB) hit rate: 57.9% 449 Secondary cache: 0 entries (0B) hit rate: 0.0% 450 Snapshots: 0 earliest seq num: 0 451 Table iters: 0 452 Filter utility: 0.0% 453 Ingestions: 0 as flushable: 2 (2.1KB in 3 tables) 454 455 batch 456 set g g 457 set h h 458 set i i 459 set j j 460 set k k 461 set l l 462 set m m 463 ---- 464 465 flush 466 ---- 467 0.1: 468 000015:[d#22,SET-d#22,SET] 469 000016:[e#23,SET-e#23,SET] 470 000019:[f#24,SET-f#24,SET] 471 0.0: 472 000023:[d#19,SET-f#21,SET] 473 000025:[g#25,SET-i#27,SET] 474 000026:[j#28,SET-l#30,SET] 475 000027:[m#31,SET-m#31,SET] 476 6: 477 000008:[a#0,SET-b#0,SET] 478 000013:[c@20#0,SET-c@16#0,SET] 479 000014:[c@15#0,SET-c@14#0,SET] 480 481 build ext1 482 set z z 483 ---- 484 485 ingest-and-excise ext1 excise=i-k 486 ---- 487 488 # sstable 29, 30 were created as virtual when i-k was excised. 489 lsm 490 ---- 491 0.1: 492 000015:[d#22,SET-d#22,SET] 493 000016:[e#23,SET-e#23,SET] 494 000019:[f#24,SET-f#24,SET] 495 0.0: 496 000023:[d#19,SET-f#21,SET] 497 000029:[g#25,SET-h#26,SET] 498 000030:[k#29,SET-l#30,SET] 499 000027:[m#31,SET-m#31,SET] 500 6: 501 000008:[a#0,SET-b#0,SET] 502 000013:[c@20#0,SET-c@16#0,SET] 503 000014:[c@15#0,SET-c@14#0,SET] 504 000028:[z#32,SET-z#32,SET] 505 506 # There should be 2 backing tables. Note that tiny sstables have inaccurate 507 # virtual sstable sizes. 508 metrics-value 509 num-backing 510 backing-size 511 num-virtual 512 num-virtual 0 513 virtual-size 514 ---- 515 2 516 1.3KB 517 2 518 2 519 102B 520 521 # Virtualize a virtual sstable. 522 build ext1 523 set zz zz 524 ---- 525 526 ingest-and-excise ext1 excise=k-l 527 ---- 528 529 # sstable 32 created when k-l was excised, but no new backing file should be 530 # created. 531 lsm 532 ---- 533 0.1: 534 000015:[d#22,SET-d#22,SET] 535 000016:[e#23,SET-e#23,SET] 536 000019:[f#24,SET-f#24,SET] 537 0.0: 538 000023:[d#19,SET-f#21,SET] 539 000029:[g#25,SET-h#26,SET] 540 000032:[l#30,SET-l#30,SET] 541 000027:[m#31,SET-m#31,SET] 542 6: 543 000008:[a#0,SET-b#0,SET] 544 000013:[c@20#0,SET-c@16#0,SET] 545 000014:[c@15#0,SET-c@14#0,SET] 546 000028:[z#32,SET-z#32,SET] 547 000031:[zz#33,SET-zz#33,SET] 548 549 metrics-value 550 num-backing 551 backing-size 552 num-virtual 553 num-virtual 0 554 virtual-size 555 ---- 556 2 557 1.3KB 558 2 559 2 560 102B 561 562 compact a-z 563 ---- 564 6: 565 000008:[a#0,SET-b#0,SET] 566 000013:[c@20#0,SET-c@16#0,SET] 567 000014:[c@15#0,SET-c@14#0,SET] 568 000033:[d#0,SET-m#0,SET] 569 000028:[z#32,SET-z#32,SET] 570 000031:[zz#33,SET-zz#33,SET] 571 572 # Virtual sstables metrics should be gone after the compaction. 573 metrics-value 574 num-backing 575 backing-size 576 num-virtual 577 num-virtual 0 578 virtual-size 579 ---- 580 0 581 0B 582 0 583 0 584 0B