| overview |
| job_id | 39120 |
| 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-39120/att-00 |
|
|---|
| inputs |
all levels summary: version# 19979, file count = 4, total size = 0.091 GB, avg size = 0.023 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.031266 | 233296 | 0 | 0 | 0 | 1 | 0.005851 | 0.025183 | 18.9% | 0.006084 | 0.025183 | 19.5% | 96.2% | 100.0% | 99.3% | 26.9 | 28.0 | 115.9 | 115.9 | SngFast | 190768977666 | 190772554505 | 0 | 18263:800000B98000000380028DF68000000A | 190771055360 | 1 | 18263:800000F780000006800EAE7480000001 | 190769042154 | 1 | 2024-08-20 16:18:30 | 29.999 MiB | 32.017 MiB |
|---|
| L2 | 3 | 3 | 0.059673 | 0.187500 | 1398691 | 0 | 0 | 0 | 3 | 0.006617 | 0.051524 | 11.4% | 0.036474 | 0.151027 | 19.5% | 18.1% | 34.1% | 31.0% | 5.1 | 28.0 | 39.6 | 115.9 | FlatZip | 190706604272 | 190772554696 | 0 | 18263:800000A8800000078005090180000001 | 190760176977 | 1 | 18263:8000010B800000028002C82F80000009 | 190753191264 | 1 | 2024-08-20 16:15:09 | 18.437 MiB | 64.000 MiB |
|---|
| sum | 4 | 4 | 0.090708 | 0.218767 | 1631987 | 0 | 0 | 0 | 4 | 0.012468 | 0.076706 | 14.0% | 0.042557 | 0.176209 | 19.5% | 29.3% | 43.5% | 40.8% | 8.2 | 28.0 | 50.5 | 115.9 | FlatZip=3
SngFast=1 | 190706604272 | 190772554696 | 0 | 18263:800000A8800000078005090180000001 | 190760176977 | 1 | 18263:8000010B800000028002C82F80000009 | 190753191264 | 1 | 2024-08-20 16:15:09 | 21.328 MiB | 56.004 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 |
|---|
| 14674268 | 🟢 | 0.031035 | 0.031266 | 233296 | 0 | 0 | 0 | 1 | 0.005851 | 0.025183 | 18.9% | 0.006084 | 0.025183 | 19.5% | 96.2% | 100.0% | 99.3% | 26.9 | 28.0 | 115.9 | 115.9 | SngFast | 190768977666 | 190772554505 | 7 | 18263:800000B98000000380028DF68000000A | 190771055360 | 1 | 18263:800000F780000006800EAE7480000001 | 190769042154 | 1 | 2024-08-20 16:18:30 |
|---|
level = 2, file count = 3, total zip = 0.060 GB, raw = 0.188 GB, over prev level: zip = 1.922796, raw = 5.996873
| 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 |
|---|
| 14674230 | 🟢 | 0.019746 | 0.062500 | 465960 | 0 | 0 | 0 | 1 | 0.002188 | 0.017048 | 11.4% | 0.012151 | 0.050349 | 19.4% | 18.0% | 33.9% | 30.8% | 5.0 | 28.0 | 39.3 | 116.0 | FlatZip | 190738754285 | 190768977044 | 7 | 18263:800000A8800000078005090180000001 | 190760176977 | 1 | 18263:800000B9800000038002C5C880000001 | 190739191924 | 1 | 2024-08-20 16:15:41 |
|---|
| 14674211 | 🟢 | 0.019401 | 0.062500 | 466579 | 0 | 0 | 0 | 1 | 0.002240 | 0.016651 | 11.9% | 0.012167 | 0.050333 | 19.5% | 18.4% | 33.1% | 30.2% | 5.2 | 28.0 | 38.3 | 115.8 | FlatZip | 190706604272 | 190768976403 | 7 | 18263:800000B9800000098002C89C80000006 | 190751350668 | 1 | 18263:800000DC8000000380028BE380000006 | 190767250552 | 1 | 2024-08-20 16:15:09 |
|---|
| 14674304 | 🟢 | 0.020526 | 0.062500 | 466152 | 0 | 0 | 0 | 1 | 0.002189 | 0.017825 | 10.9% | 0.012156 | 0.050344 | 19.4% | 18.0% | 35.4% | 32.0% | 5.0 | 28.0 | 41.1 | 116.0 | FlatZip | 190747656947 | 190772554696 | 6 | 18263:800000DC8000000380028BE380000007 | 190767250553 | 1 | 18263:8000010B800000028002C82F80000009 | 190753191264 | 1 | 2024-08-20 16:18:38 |
|---|
| sum | 3 | 0.059673 | 0.187500 | 1398691 | 0 | 0 | 0 | 3 | 0.006617 | 0.051524 | 11.4% | 0.036474 | 0.151027 | 19.5% | 18.1% | 34.1% | 31.0% | 5.1 | 28.0 | 39.6 | 115.9 | FlatZip | 190706604272 | 190772554696 | 0 | 18263:800000A8800000078005090180000001 | 190760176977 | 1 | 18263:8000010B800000028002C82F80000009 | 190753191264 | 1 | 2024-08-20 16:15:09 |
|---|
|
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 |
|---|
| 14672912 | 189724223277 | 190740533517 | 0.040064 | 0.040064 | 18263:800000A88000000780047A3980000001 | 190737428449 | 1 | 18263:800000B98000000180025EDB8000000A | 190693698799 | 1 | 931253 | 0 | 0.026075 | 0.108143 | 0 | | 14674232 | 190671008577 | 190768972767 | 0.039001 | 0.039001 | 18263:800000B98000000180025EDB8000000B | 190693698800 | 1 | 18263:800000B9800000058002689580000002 | 190709624176 | 1 | 933266 | 0 | 0.026131 | 0.108086 | 0 | | 14674302 | 190651423288 | 190768974786 | 0.039713 | 0.039713 | 18263:800000B9800000058002689580000003 | 190709624177 | 1 | 18263:800000B9800000098002A21B80000007 | 190694962732 | 1 | 931142 | 0 | 0.026072 | 0.108146 | 0 | | 14674303 | 189706194419 | 190751350667 | 0.030836 | 0.030836 | 18263:800000B9800000098002A21B80000008 | 190694962733 | 1 | 18263:800000DC80000001800212E580000004 | 190570897303 | 1 | 698213 | 0 | 0.019550 | 0.081342 | 0 | | 14672686 | 190570897304 | 190587204050 | 0.001473 | 0.001473 | 18263:800000DC80000001800212E580000005 | 190570897304 | 1 | 18263:800000DC8000000180021CD980000009 | 190587204050 | 1 | 25362 | 0 | 0.000710 | 0.002993 | 0 | | 14673340 | 190516604946 | 190747656183 | 0.039494 | 0.039494 | 18263:800000DC8000000180021CD98000000A | 190587204051 | 1 | 18263:800000DC8000000480025B3680000001 | 190687338888 | 1 | 928135 | 0 | 0.025988 | 0.108230 | 0 | | 14674120 | 190610693585 | 190767217011 | 0.038538 | 0.038538 | 18263:800000DC80000004800288138000000B | 190760928744 | 1 | 18263:800000DC800000088002C5B98000000B | 190747707923 | 1 | 933071 | 0 | 0.026126 | 0.108092 | 0 | | 14674122 | 190596801086 | 190767216746 | 0.019348 | 0.019348 | 18263:800000DC800000088002C5B98000000C | 190747707924 | 1 | 18263:800000F7800000018010521F80000003 | 190710043765 | 1 | 436414 | 0 | 0.012220 | 0.050530 | 0 | | 14673454 | 190566830641 | 190751218773 | 0.041116 | 0.041116 | 18263:800000F7800000058010473D80000007 | 190681317497 | 1 | 18263:800000F78000000A800E7CBE80000008 | 190569358843 | 1 | 933437 | 0 | 0.026136 | 0.108082 | 0 | | 14673455 | 190569358844 | 190751216858 | 0.039818 | 0.039818 | 18263:800000F78000000A800E7CBE80000009 | 190569358844 | 1 | 18263:8000010B800000038002492280000001 | 190661667794 | 1 | 930428 | 0 | 0.026052 | 0.108166 | 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 | 190772784673 |
| last_allocated_sequence | 190772784673 |
| last_published_sequence | 189793095786 |
| next_file_number | 14674306 |
| min_log_number_to_keep | 14674234 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 19977 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.995581 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 190706604272 |
| earliest_write_conflict_snapshot | 190772784181 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18263:800000A8800000078005090180000001 |
| largest_user_key | 18263:8000010B800000028002C82F80000009 |
| existing_snapshots |
190772784181 |
|---|
| 190772784259 |
| 190772784423 |
| 190772784617 |
| 190772784640 |
| 190772784662 |
| 190772784673 |
| extra_serde_files | |
| shutting_down | |
|
|---|