github.com/cockroachdb/pebble@v1.1.1-0.20240513155919-3622ade60459/tool/testdata/sstable_scan (about) 1 sstable scan 2 --start=arm 3 --end=aside 4 ../sstable/testdata/h.sst 5 ---- 6 h.sst 7 arm#0,SET [32] 8 armed#0,SET [32] 9 armour#0,SET [31] 10 arms#0,SET [32] 11 arrant#0,SET [31] 12 art#0,SET [36] 13 artery#0,SET [31] 14 article#0,SET [31] 15 articles#0,SET [31] 16 as#0,SET [3536] 17 18 sstable scan 19 --end=abused 20 ../sstable/testdata/h.sst 21 ---- 22 h.sst 23 a-a#0,RANGEDEL 24 a#0,SET [3937] 25 aboard#0,SET [32] 26 about#0,SET [32] 27 above#0,SET [31] 28 abroad#0,SET [31] 29 absurd#0,SET [31] 30 31 sstable scan 32 --start=you 33 ../sstable/testdata/h.sst 34 ---- 35 h.sst 36 you#0,SET [313130] 37 young#0,SET [36] 38 your#0,SET [3439] 39 yourself#0,SET [37] 40 youth#0,SET [35] 41 42 sstable scan 43 --key=%x 44 --value=null 45 --start=you 46 ../sstable/testdata/h.sst 47 ---- 48 h.sst 49 796f75#0,SET 50 796f756e67#0,SET 51 796f7572#0,SET 52 796f757273656c66#0,SET 53 796f757468#0,SET 54 55 sstable scan 56 --key=%q 57 --value=null 58 --start=hex:796f75 59 --end=raw:yourself 60 ../sstable/testdata/h.sst 61 ---- 62 h.sst 63 "you"#0,SET 64 "young"#0,SET 65 "your"#0,SET 66 67 sstable scan 68 --key=null 69 --value=[%x] 70 --start=hex:796f75 71 --end=raw:yourself 72 ../sstable/testdata/h.sst 73 ---- 74 h.sst 75 [313130] 76 [36] 77 [3439] 78 79 sstable scan 80 --key=pretty 81 --value=[%x] 82 --start=hex:796f75 83 --end=raw:yourself 84 ../sstable/testdata/h.sst 85 ---- 86 h.sst 87 you#0,SET [313130] 88 young#0,SET [36] 89 your#0,SET [3439] 90 91 sstable scan 92 --key=pretty 93 --value=[%x] 94 --start=hex:796f75 95 --end=raw:yourself 96 ../sstable/testdata/h.sst 97 ---- 98 h.sst 99 you#0,SET [313130] 100 young#0,SET [36] 101 your#0,SET [3439] 102 103 sstable scan 104 --key=pretty 105 --value=pretty 106 --start=hex:796f75 107 --end=raw:yourself 108 ../sstable/testdata/h.sst 109 ---- 110 h.sst 111 you#0,SET 110 112 young#0,SET 6 113 your#0,SET 49 114 115 sstable scan 116 --key=pretty:test-comparer 117 --value=pretty:test-comparer 118 --start=hex:796f75 119 --end=raw:yourself 120 ../sstable/testdata/h.sst 121 ---- 122 h.sst 123 test formatter: you#0,SET test value formatter: 110 124 test formatter: young#0,SET test value formatter: 6 125 test formatter: your#0,SET test value formatter: 49 126 127 # Start and end scan keys lie within range tombstones. 128 sstable scan 129 --start=beards 130 --end=carrying 131 ../sstable/testdata/h.sst 132 ---- 133 h.sst 134 beard-bearers#0,RANGEDEL 135 bearers#0,SET [31] 136 bears#0,SET [31] 137 beast#0,SET [32] 138 beating#0,SET [31] 139 beauty#0,SET [31] 140 beaver#0,SET [31] 141 beckons#0,SET [32] 142 bed#0,SET [34] 143 been#0,SET [34] 144 beetles#0,SET [31] 145 befitted#0,SET [31] 146 before#0,SET [36] 147 beg#0,SET [31] 148 beguile#0,SET [31] 149 behold#0,SET [31] 150 behoves#0,SET [31] 151 being#0,SET [34] 152 belief#0,SET [31] 153 believe#0,SET [36] 154 bell#0,SET [31] 155 bend#0,SET [32] 156 beneath#0,SET [35] 157 benefit#0,SET [31] 158 bernardo#0,SET [3330] 159 beseech#0,SET [32] 160 besmirch#0,SET [31] 161 best#0,SET [35] 162 beteem#0,SET [31] 163 bethought#0,SET [31] 164 better#0,SET [32] 165 between#0,SET [32] 166 beware#0,SET [32] 167 beyond#0,SET [31] 168 bid#0,SET [32] 169 bird#0,SET [32] 170 birth#0,SET [33] 171 bites#0,SET [31] 172 bitter#0,SET [31] 173 black#0,SET [31] 174 blast#0,SET [31] 175 blastments#0,SET [31] 176 blasts#0,SET [31] 177 blazes#0,SET [31] 178 blazon#0,SET [31] 179 blessing#0,SET [33] 180 blood#0,SET [37] 181 blossoms#0,SET [31] 182 blows#0,SET [31] 183 bodes#0,SET [31] 184 body#0,SET [35] 185 bonds#0,SET [31] 186 bones#0,SET [31] 187 book#0,SET [31] 188 books#0,SET [31] 189 born#0,SET [32] 190 borrower#0,SET [31] 191 borrowing#0,SET [31] 192 bosom#0,SET [31] 193 both#0,SET [33] 194 bound#0,SET [32] 195 bounteous#0,SET [31] 196 bow#0,SET [31] 197 boy#0,SET [32] 198 brain#0,SET [32] 199 bray#0,SET [31] 200 brazen#0,SET [31] 201 breach#0,SET [31] 202 break#0,SET [33] 203 breaking#0,SET [31] 204 breath#0,SET [31] 205 breathing#0,SET [31] 206 brief#0,SET [31] 207 bring#0,SET [31] 208 brokers#0,SET [31] 209 brother#0,SET [36] 210 brow#0,SET [31] 211 bruit#0,SET [31] 212 bulk#0,SET [31] 213 buried#0,SET [31] 214 burns#0,SET [32] 215 burnt#0,SET [31] 216 burst#0,SET [32] 217 business#0,SET [34] 218 but#0,SET [3538] 219 buttons#0,SET [31] 220 buy#0,SET [31] 221 by#0,SET [3331] 222 call#0,SET [34] 223 calumnious#0,SET [31] 224 came#0,SET [32] 225 can#0,SET [35] 226 canker#0,SET [31] 227 cannon#0,SET [32] 228 cannot#0,SET [33] 229 canon#0,SET [31] 230 canonized#0,SET [31] 231 canst#0,SET [32] 232 cap#0,SET [31] 233 carefully#0,SET [31] 234 carriage-carve#0,RANGEDEL 235 carriage#0,SET [31] 236 237 # Start scan key lies on range tombstone end key. 238 sstable scan 239 --start=bearers 240 --end=bears 241 ../sstable/testdata/h.sst 242 ---- 243 h.sst 244 bearers#0,SET [31] 245 246 # End scan key lies on range tombstone start key. 247 sstable scan 248 --start=bear 249 --end=beard 250 ../sstable/testdata/h.sst 251 ---- 252 h.sst 253 bear#0,SET [35] 254 255 # Count that only includes point records. 256 sstable scan 257 --start=armed 258 --count=3 259 ../sstable/testdata/h.sst 260 ---- 261 h.sst 262 armed#0,SET [32] 263 armour#0,SET [31] 264 arms#0,SET [32] 265 266 # Count that includes point records and range tombstones. 267 sstable scan 268 --start=beards 269 --count=2 270 ../sstable/testdata/h.sst 271 ---- 272 h.sst 273 beard-bearers#0,RANGEDEL 274 bearers#0,SET [31] 275 276 sstable scan 277 testdata/out-of-order.sst 278 ---- 279 out-of-order.sst 280 a#0,SET [] 281 c#0,SET [] 282 b#0,SET [] 283 WARNING: OUT OF ORDER KEYS! 284 285 sstable scan 286 --filter=arms 287 ../sstable/testdata/h.sst 288 ---- 289 h.sst: arms#0,SET [32] 290 291 sstable scan 292 --filter=bear 293 ../sstable/testdata/h.sst 294 ---- 295 h.sst: bear#0,SET [35] 296 h.sst: beard-bearers#0,RANGEDEL 297 h.sst: beard#0,SET [31] 298 h.sst: bearers#0,SET [31] 299 h.sst: bears#0,SET [31] 300 301 sstable scan 302 --filter=beards 303 ../sstable/testdata/h.sst 304 ---- 305 h.sst: beard-bearers#0,RANGEDEL 306 307 sstable scan 308 --filter=beard 309 ../sstable/testdata/ 310 ---- 311 testdata/h.block-bloom.no-compression.sst: beard-bearers#0,RANGEDEL 312 testdata/h.block-bloom.no-compression.sst: beard#0,SET [31] 313 testdata/h.ldb: beard-bearers#0,RANGEDEL 314 testdata/h.ldb: beard#0,SET [31] 315 testdata/h.no-compression.sst: beard-bearers#0,RANGEDEL 316 testdata/h.no-compression.sst: beard#0,SET [31] 317 testdata/h.no-compression.two_level_index.sst: beard-bearers#0,RANGEDEL 318 testdata/h.no-compression.two_level_index.sst: beard#0,SET [31] 319 testdata/h.sst: beard-bearers#0,RANGEDEL 320 testdata/h.sst: beard#0,SET [31] 321 testdata/h.table-bloom.no-compression.prefix_extractor.no_whole_key_filter.sst: beard-bearers#0,RANGEDEL 322 testdata/h.table-bloom.no-compression.prefix_extractor.no_whole_key_filter.sst: beard#0,SET [31] 323 testdata/h.table-bloom.no-compression.sst: beard-bearers#0,RANGEDEL 324 testdata/h.table-bloom.no-compression.sst: beard#0,SET [31] 325 testdata/h.table-bloom.sst: beard-bearers#0,RANGEDEL 326 testdata/h.table-bloom.sst: beard#0,SET [31] 327 testdata/h.zstd-compression.sst: beard-bearers#0,RANGEDEL 328 testdata/h.zstd-compression.sst: beard#0,SET [31] 329 330 sstable scan 331 --filter=beard 332 --start=boar 333 ../sstable/testdata/h.sst 334 ---- 335 336 sstable scan 337 ./testdata/mixed/000005.sst 338 ---- 339 000005.sst 340 a@1#1,SET [] 341 b@1#2,SET [] 342 c@1#3,SET [] 343 d@1#4,SET [] 344 e@1#5,SET [] 345 f@1#6,SET [] 346 g@1#7,SET [] 347 h@1#8,SET [] 348 i@1#9,SET [] 349 j@1#10,SET [] 350 k@1#11,SET [] 351 l@1#12,SET [] 352 m@1#13,SET [] 353 n@1#14,SET [] 354 o@1#15,SET [] 355 p@1#16,SET [] 356 q@1#17,SET [] 357 r@1#18,SET [] 358 s@1#19,SET [] 359 t@1#20,SET [] 360 u@1#21,SET [] 361 v@1#22,SET [] 362 w@1#23,SET [] 363 x@1#24,SET [] 364 y@1#25,SET [] 365 z@1#26,SET [] 366 [a-b): 367 #29,RANGEKEYDEL 368 [b-z): 369 #28,RANGEKEYUNSET: @2 370 #27,RANGEKEYSET: @1 [] 371 372 sstable scan 373 --start=b 374 --end=e 375 ./testdata/mixed/000005.sst 376 ---- 377 000005.sst 378 b@1#2,SET [] 379 c@1#3,SET [] 380 d@1#4,SET [] 381 [b-z): 382 #28,RANGEKEYUNSET: @2 383 #27,RANGEKEYSET: @1 [] 384 385 sstable scan 386 --filter=a 387 ./testdata/mixed/000005.sst 388 ---- 389 000005.sst: a@1#1,SET [] 390 000005.sst: [a-b): 391 #29,RANGEKEYDEL 392 393 sstable scan 394 --filter=b 395 --start=b 396 --end=d 397 ./testdata/mixed/000005.sst 398 ---- 399 000005.sst: b@1#2,SET [] 400 000005.sst: [b-z): 401 #28,RANGEKEYUNSET: @2 402 #27,RANGEKEYSET: @1 []