| overview |
| job_id | 38009 |
| 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-38009/att-00 |
|
|---|
| inputs |
all levels summary: version# 19410, file count = 6, total size = 0.120 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.031252 | 233224 | 0 | 0 | 0 | 1 | 0.005863 | 0.025171 | 18.9% | 0.006082 | 0.025171 | 19.5% | 96.4% | 100.0% | 99.3% | 27.0 | 28.0 | 115.9 | 115.9 | SngFast | 190740535125 | 190744109441 | 0 | 18263:800000B98000000380027D2D80000005 | 190743153529 | 1 | 18263:800000F780000006800EA80380000008 | 190743374734 | 1 | 2024-08-20 15:50:15 | 29.999 MiB | 32.002 MiB |
|---|
| L2 | 5 | 5 | 0.089458 | 0.281188 | 2099675 | 0 | 0 | 0 | 5 | 0.010257 | 0.076900 | 11.8% | 0.054753 | 0.226434 | 19.5% | 18.7% | 34.0% | 31.0% | 5.2 | 28.0 | 39.3 | 115.8 | FlatZip | 190663877521 | 190744109263 | 0 | 18263:800000A8800000058004F1DF80000004 | 190714177539 | 1 | 18263:8000010B800000028002BB9680000002 | 190735150905 | 1 | 2024-08-20 15:47:20 | 16.515 MiB | 57.587 MiB |
|---|
| sum | 6 | 6 | 0.120493 | 0.312440 | 2332899 | 0 | 0 | 0 | 6 | 0.016120 | 0.102071 | 13.6% | 0.060835 | 0.251605 | 19.5% | 26.5% | 40.6% | 37.8% | 7.4 | 28.0 | 47.0 | 115.8 | FlatZip=5
SngFast=1 | 190663877521 | 190744109441 | 0 | 18263:800000A8800000058004F1DF80000004 | 190714177539 | 1 | 18263:8000010B800000028002BB9680000002 | 190735150905 | 1 | 2024-08-20 15:47:20 | 18.762 MiB | 53.323 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 |
|---|
| 14672959 | 🟢 | 0.031035 | 0.031252 | 233224 | 0 | 0 | 0 | 1 | 0.005863 | 0.025171 | 18.9% | 0.006082 | 0.025171 | 19.5% | 96.4% | 100.0% | 99.3% | 27.0 | 28.0 | 115.9 | 115.9 | SngFast | 190740535125 | 190744109441 | 7 | 18263:800000B98000000380027D2D80000005 | 190743153529 | 1 | 18263:800000F780000006800EA80380000008 | 190743374734 | 1 | 2024-08-20 15:50:15 |
|---|
level = 2, file count = 5, total zip = 0.089 GB, raw = 0.281 GB, over prev level: zip = 2.882533, raw = 8.997335
| 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 |
|---|
| 14673002 | 🟢 | 0.020151 | 0.062500 | 466749 | 0 | 0 | 0 | 1 | 0.002246 | 0.017395 | 11.4% | 0.012171 | 0.050329 | 19.5% | 18.5% | 34.6% | 31.4% | 5.2 | 28.0 | 40.0 | 115.8 | FlatZip | 190694182453 | 190744109043 | 7 | 18263:800000A8800000058004F1DF80000004 | 190714177539 | 1 | 18263:800000DC80000001800278CA80000002 | 190735797646 | 1 | 2024-08-20 15:50:25 |
|---|
| 14673003 | 🟢 | 0.009961 | 0.031187 | 232845 | 0 | 0 | 0 | 1 | 0.001121 | 0.008579 | 11.6% | 0.006072 | 0.025115 | 19.5% | 18.5% | 34.2% | 31.1% | 5.2 | 28.0 | 39.6 | 115.8 | FlatZip | 190706604287 | 190740533136 | 11 | 18263:800000DC80000001800278CA80000003 | 190735797647 | 1 | 18263:800000DC800000038002B4BA80000001 | 190718128963 | 1 | 2024-08-20 15:50:30 |
|---|
| 14672919 | 🟢 | 0.019346 | 0.062500 | 467179 | 0 | 0 | 0 | 1 | 0.002297 | 0.016540 | 12.2% | 0.012183 | 0.050317 | 19.5% | 18.9% | 32.9% | 30.1% | 5.3 | 28.0 | 38.0 | 115.6 | FlatZip | 190663877521 | 190740534747 | 11 | 18263:800000DC800000038002B4BA80000002 | 190718128964 | 1 | 18263:800000DC800000078002B6E080000007 | 190717178591 | 1 | 2024-08-20 15:47:20 |
|---|
| 14672920 | 🟢 | 0.019991 | 0.062500 | 466486 | 0 | 0 | 0 | 1 | 0.002294 | 0.017186 | 11.8% | 0.012165 | 0.050335 | 19.5% | 18.9% | 34.1% | 31.2% | 5.3 | 28.0 | 39.6 | 115.9 | FlatZip | 190663882500 | 190740534530 | 7 | 18263:800000DC800000078002B6E080000008 | 190717178592 | 1 | 18263:800000F780000005800EA4CC8000000C | 190730435252 | 1 | 2024-08-20 15:47:22 |
|---|
| 14672971 | 🟢 | 0.020010 | 0.062500 | 466416 | 0 | 0 | 0 | 1 | 0.002299 | 0.017200 | 11.8% | 0.012163 | 0.050337 | 19.5% | 18.9% | 34.2% | 31.2% | 5.3 | 28.0 | 39.6 | 115.9 | FlatZip | 190668917374 | 190744109263 | 6 | 18263:800000F780000005800EA4CC8000000D | 190730435253 | 1 | 18263:8000010B800000028002BB9680000002 | 190735150905 | 1 | 2024-08-20 15:50:17 |
|---|
| sum | 5 | 0.089458 | 0.281188 | 2099675 | 0 | 0 | 0 | 5 | 0.010257 | 0.076900 | 11.8% | 0.054753 | 0.226434 | 19.5% | 18.7% | 34.0% | 31.0% | 5.2 | 28.0 | 39.3 | 115.8 | FlatZip | 190663877521 | 190744109263 | 0 | 18263:800000A8800000058004F1DF80000004 | 190714177539 | 1 | 18263:8000010B800000028002BB9680000002 | 190735150905 | 1 | 2024-08-20 15:47:20 |
|---|
|
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 |
|---|
| 14672824 | 190646072190 | 190699514193 | 0.009384 | 0.009384 | 18263:800000A8800000058004E41D80000002 | 190686867240 | 1 | 18263:800000A8800000078004643380000004 | 190690158447 | 1 | 202462 | 0 | 0.005669 | 0.023543 | 0 | | 14672912 | 189724223277 | 190740533517 | 0.040064 | 0.040064 | 18263:800000A88000000780047A3980000001 | 190737428449 | 1 | 18263:800000B98000000180025EDB8000000A | 190693698799 | 1 | 931253 | 0 | 0.026075 | 0.108143 | 0 | | 14672913 | 190671008577 | 190740534886 | 0.039661 | 0.039661 | 18263:800000B98000000180025EDB8000000B | 190693698800 | 1 | 18263:800000B98000000680026A4480000005 | 190712412802 | 1 | 932484 | 0 | 0.026110 | 0.108108 | 0 | | 14672914 | 190712412803 | 190727306493 | 0.001353 | 0.001353 | 18263:800000B98000000680026A4480000006 | 190712412803 | 1 | 18263:800000B9800000068002735880000003 | 190727306493 | 1 | 23052 | 0 | 0.000645 | 0.002720 | 0 | | 14672685 | 189706194419 | 190735174565 | 0.040387 | 0.040387 | 18263:800000B9800000088002B09D80000003 | 190705969774 | 1 | 18263:800000DC80000001800212E580000004 | 190570897303 | 1 | 929199 | 0 | 0.026018 | 0.108200 | 0 | | 14672686 | 190570897304 | 190587204050 | 0.001473 | 0.001473 | 18263:800000DC80000001800212E580000005 | 190570897304 | 1 | 18263:800000DC8000000180021CD980000009 | 190587204050 | 1 | 25362 | 0 | 0.000710 | 0.002993 | 0 | | 14671668 | 190472317207 | 190713755016 | 0.038555 | 0.038555 | 18263:800000DC8000000180021CD98000000A | 190587204051 | 1 | 18263:800000DC8000000580022FFA80000002 | 190618055849 | 1 | 928729 | 0 | 0.026004 | 0.108213 | 0 | | 14671669 | 190593978453 | 190713752766 | 0.038066 | 0.038066 | 18263:800000DC8000000580022FFA80000003 | 190618055850 | 1 | 18263:800000DC8000000780028E618000000D | 190657607624 | 1 | 932362 | 0 | 0.026106 | 0.108112 | 0 | | 14671679 | 190552812354 | 190715551180 | 0.037750 | 0.037750 | 18263:800000DC8000000780028E618000000E | 190657607625 | 1 | 18263:800000DC8000000A8002357A80000004 | 190626831549 | 1 | 930282 | 0 | 0.026048 | 0.108170 | 0 | | 14671875 | 190521617981 | 190719118656 | 0.041060 | 0.041060 | 18263:800000F78000000180104FB680000004 | 190702376877 | 1 | 18263:800000F7800000068010499D80000004 | 190670094357 | 1 | 933497 | 0 | 0.026138 | 0.108080 | 0 | | 14671876 | 190566830641 | 190719117728 | 0.028297 | 0.028297 | 18263:800000F7800000068010499D80000005 | 190670094358 | 1 | 18263:800000F78000000A8010413980000004 | 190668917373 | 1 | 624245 | 0 | 0.017479 | 0.072402 | 0 | | 14672178 | 190579064108 | 190726270066 | 0.039207 | 0.039207 | 18263:800000F78000000A8010451780000003 | 190682491136 | 1 | 18263:8000010B800000048002516B80000002 | 190675175745 | 1 | 929861 | 0 | 0.026036 | 0.108182 | 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 | 190744395272 |
| last_allocated_sequence | 190744395272 |
| last_published_sequence | 189793095786 |
| next_file_number | 14673004 |
| min_log_number_to_keep | 14672927 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 19408 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.985282 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 190663877521 |
| earliest_write_conflict_snapshot | 190744395220 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18263:800000A8800000058004F1DF80000004 |
| largest_user_key | 18263:8000010B800000028002BB9680000002 |
| existing_snapshots |
190744395220 |
|---|
| 190744395242 |
| 190744395257 |
| 190744395272 |
| extra_serde_files | |
| shutting_down | |
|
|---|