| overview |
| job_id | 28697 |
| 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 | 465QC0QPK7Q93426EREI |
|
|---|
| 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-28697/att-00 |
|
|---|
| inputs |
all levels summary: version# 15110, file count = 6, total size = 0.099 GB, avg size = 0.017 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.021604 | 0.021669 | 161775 | 0 | 0 | 0 | 1 | 0.004153 | 0.017450 | 19.2% | 0.004219 | 0.017450 | 19.5% | 98.4% | 100.0% | 99.7% | 27.6 | 28.0 | 115.8 | 115.8 | SngFast | 147894607703 | 147896199829 | 0 | 18263:800000298000000A80021BB880000001 | 147895730148 | 1 | 18263:800001178000000A80025C3A8000000E | 147896182084 | 1 | 2024-07-09 03:25:57 | 20.887 MiB | 22.189 MiB |
|---|
| L2 | 5 | 5 | 0.077703 | 0.241053 | 1797974 | 0 | 0 | 0 | 5 | 0.008591 | 0.067128 | 11.3% | 0.046886 | 0.194168 | 19.5% | 18.3% | 34.6% | 31.4% | 5.1 | 28.0 | 40.1 | 116.0 | FlatZip | 147818912916 | 147894607483 | 0 | 18263:8000002980000004800255E280000008 | 147889264621 | 1 | 18263:800001178000000A80025B1980000008 | 147894605480 | 1 | 2024-07-09 03:24:06 | 14.402 MiB | 49.368 MiB |
|---|
| sum | 6 | 6 | 0.099307 | 0.262722 | 1959749 | 0 | 0 | 0 | 6 | 0.012744 | 0.084579 | 13.1% | 0.051104 | 0.211618 | 19.5% | 24.9% | 40.0% | 37.0% | 7.0 | 28.0 | 46.3 | 115.9 | FlatZip=5
SngFast=1 | 147818912916 | 147896199829 | 0 | 18263:8000002980000004800255E280000008 | 147889264621 | 1 | 18263:800001178000000A80025C3A8000000E | 147896182084 | 1 | 2024-07-09 03:24:06 | 15.483 MiB | 44.838 MiB |
|---|
level = 1, file count = 1, total zip = 0.022 GB, raw = 0.022 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 |
|---|
| 12658393 | 🟢 | 0.021604 | 0.021669 | 161775 | 0 | 0 | 0 | 1 | 0.004153 | 0.017450 | 19.2% | 0.004219 | 0.017450 | 19.5% | 98.4% | 100.0% | 99.7% | 27.6 | 28.0 | 115.8 | 115.8 | SngFast | 147894607703 | 147896199829 | 6 | 18263:800000298000000A80021BB880000001 | 147895730148 | 1 | 18263:800001178000000A80025C3A8000000E | 147896182084 | 1 | 2024-07-09 03:25:57 |
|---|
level = 2, file count = 5, total zip = 0.078 GB, raw = 0.241 GB, over prev level: zip = 3.596714, raw = 11.124332
| 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 |
|---|
| 12658378 | 🟢 | 0.010268 | 0.031209 | 232904 | 0 | 0 | 0 | 1 | 0.001035 | 0.008972 | 10.3% | 0.006073 | 0.025136 | 19.5% | 17.0% | 35.7% | 32.1% | 4.8 | 28.0 | 41.4 | 115.9 | FlatZip | 147887586633 | 147894606836 | 7 | 18263:8000002980000004800255E280000008 | 147889264621 | 1 | 18263:800000358000000380025DF180000007 | 147892658434 | 1 | 2024-07-09 03:24:35 |
|---|
| 12658361 | 🟢 | 0.019564 | 0.062500 | 465485 | 0 | 0 | 0 | 1 | 0.002294 | 0.016760 | 12.0% | 0.012138 | 0.050362 | 19.4% | 18.9% | 33.3% | 30.5% | 5.3 | 28.0 | 38.7 | 116.2 | FlatZip | 147818912916 | 147894607349 | 11 | 18263:800000358000000380025DF180000008 | 147892658435 | 1 | 18263:8000003580000009800256AC80000001 | 147880275744 | 1 | 2024-07-09 03:24:06 |
|---|
| 12658362 | 🟢 | 0.020508 | 0.062500 | 466576 | 0 | 0 | 0 | 1 | 0.002234 | 0.017764 | 11.2% | 0.012167 | 0.050333 | 19.5% | 18.4% | 35.3% | 32.0% | 5.1 | 28.0 | 40.9 | 115.8 | FlatZip | 147844977525 | 147894607141 | 7 | 18263:8000003580000009800256AC80000002 | 147880275745 | 1 | 18263:8000007D8000000380188D8C80000005 | 147876708635 | 1 | 2024-07-09 03:24:08 |
|---|
| 12658363 | 🟢 | 0.020093 | 0.062500 | 465788 | 0 | 0 | 0 | 1 | 0.002242 | 0.017339 | 11.4% | 0.012146 | 0.050354 | 19.4% | 18.5% | 34.4% | 31.3% | 5.2 | 28.0 | 40.0 | 116.1 | FlatZip | 147837937725 | 147894607483 | 6 | 18263:8000007D8000000380188D8C80000006 | 147876708636 | 1 | 18263:800001178000000580024B5E80000005 | 147875648904 | 1 | 2024-07-09 03:24:13 |
|---|
| 12658364 | 🟢 | 0.007270 | 0.022344 | 167221 | 0 | 0 | 0 | 1 | 0.000786 | 0.006293 | 11.1% | 0.004361 | 0.017984 | 19.5% | 18.0% | 35.0% | 31.7% | 5.0 | 28.0 | 40.4 | 115.5 | FlatZip | 147875648905 | 147894605917 | 11 | 18263:800001178000000580024B5E80000006 | 147875648905 | 1 | 18263:800001178000000A80025B1980000008 | 147894605480 | 1 | 2024-07-09 03:24:15 |
|---|
| sum | 5 | 0.077703 | 0.241053 | 1797974 | 0 | 0 | 0 | 5 | 0.008591 | 0.067128 | 11.3% | 0.046886 | 0.194168 | 19.5% | 18.3% | 34.6% | 31.4% | 5.1 | 28.0 | 40.1 | 116.0 | FlatZip | 147818912916 | 147894607483 | 0 | 18263:8000002980000004800255E280000008 | 147889264621 | 1 | 18263:800001178000000A80025B1980000008 | 147894605480 | 1 | 2024-07-09 03:24:06 |
|---|
|
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 |
|---|
| 12657992 | 147449856108 | 147887586168 | 0.036673 | 0.036673 | 18263:8000002980000006800226F780000003 | 147826004481 | 1 | 18263:800000298000000A80020C138000000F | 147872582082 | 1 | 845328 | 0 | 0.023669 | 0.098576 | 0 | | 12657999 | 147744786845 | 147887586187 | 0.040047 | 0.040047 | 18263:800000298000000A80020C1480000001 | 147872588801 | 1 | 18263:80000035800000058001D66880000007 | 147787061204 | 1 | 930787 | 0 | 0.026062 | 0.108156 | 0 | | 12658000 | 147744786856 | 147887585296 | 0.031131 | 0.031131 | 18263:80000035800000058001D66880000008 | 147787061205 | 1 | 18263:80000035800000078001C73A80000005 | 147764873061 | 1 | 749136 | 0 | 0.020976 | 0.087239 | 0 | | 12656970 | 147741630068 | 147866047061 | 0.039252 | 0.039252 | 18263:80000035800000078001C73A80000006 | 147764873062 | 1 | 18263:800000358000000A8002089C80000002 | 147861026052 | 1 | 930450 | 0 | 0.026053 | 0.108165 | 0 | | 12657616 | 147444602089 | 147880277924 | 0.041367 | 0.041367 | 18263:80000072800000038011A3D380000005 | 147877813571 | 1 | 18263:8000007D800000018015DB1A80000003 | 147674588411 | 1 | 933219 | 0 | 0.026130 | 0.108088 | 0 | | 12657617 | 147657346074 | 147880278993 | 0.026285 | 0.026285 | 18263:8000007D800000018015DB1A80000004 | 147674588412 | 1 | 18263:8000007D8000000380187B9880000002 | 147807644462 | 1 | 582400 | 0 | 0.016307 | 0.067662 | 0 | | 12657873 | 147762688010 | 147883894970 | 0.042048 | 0.042048 | 18263:8000007D8000000380187B9880000003 | 147807644463 | 1 | 18263:80000117800000018001C4A580000003 | 147768201483 | 1 | 933266 | 0 | 0.026131 | 0.108086 | 0 | | 12657875 | 147666406358 | 147883896464 | 0.011193 | 0.011193 | 18263:80000117800000038001F79480000004 | 147843653085 | 1 | 18263:8000011780000004800199B080000009 | 147705564321 | 1 | 246813 | 0 | 0.006911 | 0.028694 | 0 | | 12657497 | 147576087509 | 147878488654 | 0.040013 | 0.040013 | 18263:8000011780000004800199B08000000A | 147705564322 | 1 | 18263:800001178000000880018D7480000002 | 147688032957 | 1 | 930997 | 0 | 0.026068 | 0.108150 | 0 | | 12658285 | 147688032958 | 147892796840 | 0.026436 | 0.026436 | 18263:800001178000000880018D7480000003 | 147688032958 | 1 | 18263:800001178000000A800259B28000000E | 147892793871 | 1 | 613133 | 0 | 0.017168 | 0.071654 | 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 | 147896282268 |
| last_allocated_sequence | 147896282268 |
| last_published_sequence | 147176466927 |
| next_file_number | 12658417 |
| min_log_number_to_keep | 12658336 |
| manifest_file_number | 12625661 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 15108 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.996040 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 147818912916 |
| earliest_write_conflict_snapshot | 147896281875 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18263:8000002980000004800255E280000008 |
| largest_user_key | 18263:800001178000000A80025C3A8000000E |
| existing_snapshots |
147896281875 |
|---|
| 147896281985 |
| 147896281996 |
| 147896282069 |
| 147896282091 |
| 147896282102 |
| 147896282173 |
| 147896282220 |
| 147896282242 |
| 147896282268 |
| extra_serde_files | |
| shutting_down | |
|
|---|