overview |
job_id | 63311 |
num_levels | 7 |
output_level | 2 |
target_file_size | 64.000 MiB |
hoster_root | /storage |
instance_name | nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137 |
|
db |
dbname | /storage/mytopling/.rocksdb |
db_id | a007a635-5c0a-4b4a-be96-b9c695cb016b |
db_session_id | 90ZT1ZM5QNL093I8HHQG |
|
cf |
cf_id | 0 |
cf_name | default |
cf_paths |
/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb |
/storage/nfs/i-wz9deglxdazgiryp6ltb_10.57.5.137/mytopling/.rocksdb/job-63311/att-00 |
|
inputs |
all levels summary: version# 31860, file count = 7, total size = 0.140 GB, avg size = 0.020 GB
Name | ♻ | FileSize(GB) | Entries | B | ZipSize(GB) | RawSize(GB) | ZipRatio(Zip/Raw) | AvgKey | AvgValue | Zip Algo | Smallest SeqNum | Largest SeqNum | Co Pr | Smallest Key | Largest Key | FileTime | Avg File Zip Size | Avg File Raw Size |
---|
Zip | Raw | All | D | M | R | Key | Value | K/KTV | Key | Value | K/KTV | Key | Value | KTV | Zip | Raw | Zip | Raw | UserKey | Seq | T | UserKey | Seq | T |
L1 | 1 | 1 | 0.031035 | 0.031205 | 232777 | 0 | 0 | 0 | 1 | 0.005899 | 0.025135 | 19.0% | 0.006070 | 0.025135 | 19.5% | 97.2% | 100.0% | 99.5% | 27.2 | 28.0 | 115.9 | 115.9 | SngFast | 191384392748 | 191386111341 | 0 | 18263:8000001C800000018003ED2880000001 | 191384395008 | 1 | 18263:800000B9800000068003F78880000005 | 191384553406 | 1 | 2024-08-21 03:20:59 | 30.003 MiB | 31.954 MiB |
L2 | 6 | 6 | 0.108468 | 0.343700 | 2565357 | 0 | 0 | 0 | 6 | 0.012476 | 0.093182 | 11.8% | 0.066897 | 0.276803 | 19.5% | 18.6% | 33.7% | 30.7% | 5.2 | 28.0 | 39.0 | 115.9 | FlatZip | 190586022308 | 191384392683 | 0 | 18263:8000001C800000018003E74780000001 | 191373935969 | 1 | 18263:800000B9800000088003D76C8000000D | 191327834289 | 1 | 2024-08-21 03:19:01 | 16.679 MiB | 58.658 MiB |
sum | 7 | 7 | 0.139503 | 0.374905 | 2798134 | 0 | 0 | 0 | 7 | 0.018375 | 0.118317 | 13.4% | 0.072967 | 0.301938 | 19.5% | 25.2% | 39.2% | 36.5% | 7.1 | 28.0 | 45.4 | 115.9 | FlatZip=6 SngFast=1 | 190586022308 | 191386111341 | 0 | 18263:8000001C800000018003E74780000001 | 191373935969 | 1 | 18263:800000B9800000088003D76C8000000D | 191327834289 | 1 | 2024-08-21 03:19:01 | 18.583 MiB | 54.843 MiB |
level = 1, file count = 1, total zip = 0.031 GB, raw = 0.031 GB
Name | ♻ | FileSize(GB) | Entries | B | ZipSize(GB) | RawSize(GB) | ZipRatio(Zip/Raw) | AvgKey | AvgValue | Zip Algo | Smallest SeqNum | Largest SeqNum | Co Pr | Smallest Key | Largest Key | FileTime |
---|
Zip | Raw | All | D | M | R | Key | Value | K/KTV | Key | Value | K/KTV | Key | Value | KTV | Zip | Raw | Zip | Raw | UserKey | Seq | T | UserKey | Seq | T |
14702105 | 🟢 | 0.031035 | 0.031205 | 232777 | 0 | 0 | 0 | 1 | 0.005899 | 0.025135 | 19.0% | 0.006070 | 0.025135 | 19.5% | 97.2% | 100.0% | 99.5% | 27.2 | 28.0 | 115.9 | 115.9 | SngFast | 191384392748 | 191386111341 | 7 | 18263:8000001C800000018003ED2880000001 | 191384395008 | 1 | 18263:800000B9800000068003F78880000005 | 191384553406 | 1 | 2024-08-21 03:20:59 |
level = 2, file count = 6, total zip = 0.108 GB, raw = 0.344 GB, over prev level: zip = 3.495015, raw = 11.014238
Name | ♻ | FileSize(GB) | Entries | B | ZipSize(GB) | RawSize(GB) | ZipRatio(Zip/Raw) | AvgKey | AvgValue | Zip Algo | Smallest SeqNum | Largest SeqNum | Co Pr | Smallest Key | Largest Key | FileTime |
---|
Zip | Raw | All | D | M | R | Key | Value | K/KTV | Key | Value | K/KTV | Key | Value | KTV | Zip | Raw | Zip | Raw | UserKey | Seq | T | UserKey | Seq | T |
14702019 | 🟢 | 0.020180 | 0.062500 | 466244 | 0 | 0 | 0 | 1 | 0.002124 | 0.017545 | 10.8% | 0.012158 | 0.050342 | 19.5% | 17.5% | 34.9% | 31.5% | 4.9 | 28.0 | 40.4 | 115.9 | FlatZip | 191373924524 | 191384392339 | 7 | 18263:8000001C800000018003E74780000001 | 191373935969 | 1 | 18263:8000002280000005800452AF80000007 | 191379212405 | 1 | 2024-08-21 03:19:01 |
14702020 | 🟢 | 0.010512 | 0.031200 | 232367 | 0 | 0 | 0 | 1 | 0.001222 | 0.009028 | 11.9% | 0.006059 | 0.025141 | 19.4% | 20.2% | 35.9% | 32.9% | 5.6 | 28.0 | 41.7 | 116.2 | FlatZip | 190586022308 | 191384392683 | 7 | 18263:8000002280000005800452AF80000008 | 191379212406 | 1 | 18263:800000A380000002800461F48000000C | 191383743070 | 1 | 2024-08-21 03:19:06 |
14702046 | 🟢 | 0.020039 | 0.062500 | 466811 | 0 | 0 | 0 | 1 | 0.002235 | 0.017293 | 11.4% | 0.012173 | 0.050327 | 19.5% | 18.4% | 34.4% | 31.2% | 5.1 | 28.0 | 39.8 | 115.8 | FlatZip | 191349510038 | 191384392401 | 7 | 18263:800000A380000002800461F580000001 | 191383745857 | 1 | 18263:800000A8800000078006485B80000006 | 191375595482 | 1 | 2024-08-21 03:19:01 |
14702047 | 🟢 | 0.019142 | 0.062500 | 466781 | 0 | 0 | 0 | 1 | 0.002295 | 0.016337 | 12.3% | 0.012172 | 0.050328 | 19.5% | 18.9% | 32.5% | 29.8% | 5.3 | 28.0 | 37.6 | 115.8 | FlatZip | 191279770607 | 191384389524 | 7 | 18263:800000A8800000078006485B80000007 | 191375595483 | 1 | 18263:800000B9800000018003BEF580000001 | 191285159030 | 1 | 2024-08-21 03:19:06 |
14702048 | 🟢 | 0.019754 | 0.062500 | 464568 | 0 | 0 | 0 | 1 | 0.002290 | 0.016954 | 11.9% | 0.012115 | 0.050385 | 19.4% | 18.9% | 33.6% | 30.8% | 5.3 | 28.0 | 39.2 | 116.5 | FlatZip | 191271463728 | 191384392534 | 11 | 18263:800000B9800000018003BEF580000002 | 191285159031 | 1 | 18263:800000B980000005800428DA8000000E | 191277887048 | 1 | 2024-08-21 03:19:11 |
14702073 | 🟢 | 0.018842 | 0.062500 | 468586 | 0 | 0 | 0 | 1 | 0.002309 | 0.016025 | 12.6% | 0.012219 | 0.050281 | 19.6% | 18.9% | 31.9% | 29.3% | 5.3 | 28.0 | 36.7 | 115.2 | FlatZip | 191277887049 | 191384392075 | 11 | 18263:800000B980000005800428DA8000000F | 191277887049 | 1 | 18263:800000B9800000088003D76C8000000D | 191327834289 | 1 | 2024-08-21 03:19:23 |
sum | 6 | 0.108468 | 0.343700 | 2565357 | 0 | 0 | 0 | 6 | 0.012476 | 0.093182 | 11.8% | 0.066897 | 0.276803 | 19.5% | 18.6% | 33.7% | 30.7% | 5.2 | 28.0 | 39.0 | 115.9 | FlatZip | 190586022308 | 191384392683 | 0 | 18263:8000001C800000018003E74780000001 | 191373935969 | 1 | 18263:800000B9800000088003D76C8000000D | 191327834289 | 1 | 2024-08-21 03:19:01 |
|
grand parents | Name | Smallest SeqNum | Largest SeqNum | FileSize (GB) | Compensated FileSize(GB) | Smallest | Largest | Entries | Raw(GB) | Creation time |
---|
UserKey | Seq | Type | UserKey | Seq | Type | ALL | D | K | V |
---|
14701692 | 191279771067 | 191373924278 | 0.039810 | 0.039810 | 18263:8000001C800000018003DAA480000001 | 191351255149 | 1 | 18263:8000001C8000000780044F3B80000004 | 191351440264 | 1 | 932668 | 0 | 0.026115 | 0.108103 | 0 | 14701814 | 191291991203 | 191373923668 | 0.040743 | 0.040743 | 18263:8000001C8000000780044F3B80000005 | 191351440265 | 1 | 18263:800000228000000580044FAA80000003 | 191373880813 | 1 | 933795 | 0 | 0.026146 | 0.108071 | 0 | 14667818 | 189689290795 | 189988793070 | 0.042950 | 0.042950 | 18263:8000003C8000000380033DF380000001 | 189729517843 | 1 | 18263:800000A380000001800092B480000001 | 189988793070 | 1 | 930957 | 0 | 0.026067 | 0.108151 | 0 | 14701959 | 191335573614 | 191380934100 | 0.040193 | 0.040193 | 18263:800000A3800000018003E6EB80000007 | 191362631307 | 1 | 18263:800000A38000000780045F1C80000008 | 191375394325 | 1 | 933146 | 0 | 0.026128 | 0.108090 | 0 | 14701831 | 191102109402 | 191377434515 | 0.040046 | 0.040046 | 18263:800000A88000000180059BB680000006 | 191359255886 | 1 | 18263:800000A88000000680058B128000000A | 191323496150 | 1 | 932034 | 0 | 0.026097 | 0.108121 | 0 | 14701832 | 191040351368 | 191356443140 | 0.019715 | 0.019715 | 18263:800000A88000000680058B128000000B | 191323496151 | 1 | 18263:800000A8800000078005DF1B80000009 | 191173973134 | 1 | 467610 | 0 | 0.013093 | 0.054016 | 0 | 14700757 | 190813323488 | 191356447230 | 0.016590 | 0.016590 | 18263:800000A8800000078005DF1B8000000A | 191173973135 | 1 | 18263:800000A88000000880058F0580000006 | 191331875942 | 1 | 384768 | 0 | 0.010774 | 0.044426 | 0 | 14699175 | 189724223277 | 191326895100 | 0.035464 | 0.035464 | 18263:800000A8800000098006121C80000001 | 191272996577 | 1 | 18263:800000B98000000180002BC580000006 | 189842032365 | 1 | 863148 | 0 | 0.024168 | 0.099549 | 0 | 14700856 | 189842032366 | 191358205087 | 0.037537 | 0.037537 | 18263:800000B98000000180002BC580000007 | 189842032366 | 1 | 18263:800000B98000000280044ED480000007 | 191336128915 | 1 | 928427 | 0 | 0.025996 | 0.108222 | 0 | 14700962 | 191133418454 | 191358199387 | 0.018307 | 0.018307 | 18263:800000B9800000048004105780000008 | 191238549635 | 1 | 18263:800000B9800000058003CC2E80000001 | 191136164573 | 1 | 420723 | 0 | 0.011780 | 0.048825 | 0 | 14699760 | 190939908795 | 191335568483 | 0.037234 | 0.037234 | 18263:800000B9800000058003CC2E80000002 | 191136164574 | 1 | 18263:800000B9800000078003926B80000007 | 191207955497 | 1 | 930704 | 0 | 0.026060 | 0.108158 | 0 | 14699761 | 191080431869 | 191335568495 | 0.027182 | 0.027182 | 18263:800000B9800000078003926B80000008 | 191207955498 | 1 | 18263:800000B9800000088003D6CE8000000B | 191326757606 | 1 | 663214 | 0 | 0.018570 | 0.077075 | 0 |
|
compaction |
compaction_reason | kFilesMarkedForCompaction |
compaction_log_level | INFO_LEVEL |
max_compaction_bytes | 4294967296 |
max_subcompactions | 1 |
manual_compaction | false |
deletion_compaction | false |
compression_opts |
window_bits | -14 |
level | 32767 |
strategy | 0 |
max_dict_bytes | 0 |
zstd_max_train_bytes | 0 |
parallel_threads | 1 |
enabled | false |
max_dict_buffer_bytes | 0 |
|
level_compaction_dynamic_file_size | false |
|
Object RpcParam |
name | clazz | params |
compaction_filter_factory | Rdb_compact_filter_factory | {} |
merge_operator | | |
user_comparator | leveldb.BytewiseComparator | |
table_factory | DispatcherTable | {"default":"sng","mark_for_compaction_max_wamp":30,"readers":{"VecAutoSortTable":"auto_sort","BlockBasedTable":"bb","CSPPMemTabTable":"cspp_memtab_sst","SingleFastTable":"sng","ToplingFastTable":"fast","ToplingZipTable":"dzip"},"level_writers":["sng","sng","dzip","dzip","dzip","dzip","dzip"],"auto_compaction_max_wamp":10,"trivial_move_always_max_output_level":4} |
prefix_extractor | | |
sst_partitioner_factory | SstPartitionerFixedPrefixEx | {"user_key_at_least_prefix_len":true,"prefix_len":4} |
html_user_key_coder | HexUserKeyCoder | {"prefix_len":4} |
table_properties_collector_factories[0] | Rdb_tbl_prop_coll_factory | {} |
|
info_log |
LogFileSize | 1.825 KiB |
InfoLogLevel | INFO_LEVEL |
|
version set |
last_sequence | 191386122477 |
last_allocated_sequence | 191386122477 |
last_published_sequence | 189793095786 |
next_file_number | 14702125 |
min_log_number_to_keep | 14701969 |
manifest_file_number | 14629260 |
options_file_number | 0 |
prev_log_number | 0 |
current_version_number | 31858 |
|
Others |
allow_ingest_behind | false |
preserve_deletes | false |
bottommost_level | false |
is_deserialized | true |
score | 0.988622 |
preserve_deletes_seqnum | 0 |
smallest_seqno | 190586022308 |
earliest_write_conflict_snapshot | 191386122403 |
paranoid_file_checks | false |
full_history_ts_low | |
smallest_user_key | 18263:8000001C800000018003E74780000001 |
largest_user_key | 18263:800000B9800000088003D76C8000000D |
existing_snapshots |
191386122403 |
191386122429 |
191386122433 |
191386122444 |
191386122466 |
191386122477 |
extra_serde_files | |
shutting_down | |
|