| overview |
| job_id | 47843 |
| 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-47843/att-00 |
|
|---|
| inputs |
all levels summary: version# 24320, file count = 4, total size = 0.079 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 | 2 | 2 | 0.038615 | 0.038843 | 289864 | 0 | 0 | 0 | 2 | 0.007330 | 0.031284 | 19.0% | 0.007559 | 0.031284 | 19.5% | 97.0% | 100.0% | 99.4% | 27.2 | 28.0 | 115.9 | 115.9 | SngFast | 190985282452 | 190996030376 | 0 | 18263:800000F780000001800EE51680000005 | 190988261622 | 1 | 18263:8000010B80000007800311FB80000004 | 190994300399 | 1 | 2024-08-20 20:08:16 | 18.664 MiB | 19.888 MiB |
|---|
| L2 | 2 | 2 | 0.040176 | 0.125000 | 932542 | 0 | 0 | 0 | 2 | 0.004596 | 0.034559 | 11.7% | 0.024318 | 0.100682 | 19.5% | 18.9% | 34.3% | 31.3% | 5.3 | 28.0 | 39.8 | 115.9 | FlatZip | 190852267535 | 190988841257 | 0 | 18263:800000F780000001800EE26180000005 | 190977277430 | 1 | 18263:8000010B8000000A8003573A8000000E | 190966339184 | 1 | 2024-08-20 20:00:43 | 18.547 MiB | 64.000 MiB |
|---|
| sum | 4 | 4 | 0.078791 | 0.163843 | 1222406 | 0 | 0 | 0 | 4 | 0.011926 | 0.065844 | 15.3% | 0.031877 | 0.131966 | 19.5% | 37.4% | 49.9% | 47.5% | 10.5 | 28.0 | 57.8 | 115.9 | FlatZip=2
SngFast=2 | 190852267535 | 190996030376 | 0 | 18263:800000F780000001800EE26180000005 | 190977277430 | 1 | 18263:8000010B8000000A8003573A8000000E | 190966339184 | 1 | 2024-08-20 20:00:43 | 18.606 MiB | 41.944 MiB |
|---|
level = 1, file count = 2, total zip = 0.039 GB, raw = 0.039 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 |
|---|
| 14684386 | 🟢 | 0.031035 | 0.031211 | 232980 | 0 | 0 | 0 | 1 | 0.005899 | 0.025135 | 19.0% | 0.006075 | 0.025135 | 19.5% | 97.1% | 100.0% | 99.4% | 27.2 | 28.0 | 115.8 | 115.8 | SngFast | 190985282452 | 190996030342 | 6 | 18263:800000F780000001800EE51680000005 | 190988261622 | 1 | 18263:8000010B8000000480036DA980000006 | 190993570066 | 1 | 2024-08-20 20:08:16 |
|---|
| 14684387 | 🟢 | 0.007580 | 0.007632 | 56884 | 0 | 0 | 0 | 1 | 0.001431 | 0.006149 | 18.9% | 0.001483 | 0.006149 | 19.4% | 96.5% | 100.0% | 99.3% | 27.0 | 28.0 | 116.1 | 116.1 | SngFast | 190988844108 | 190996030376 | 11 | 18263:8000010B8000000480036DA980000007 | 190993570067 | 1 | 18263:8000010B80000007800311FB80000004 | 190994300399 | 1 | 2024-08-20 20:08:16 |
|---|
| sum | 2 | 0.038615 | 0.038843 | 289864 | 0 | 0 | 0 | 2 | 0.007330 | 0.031284 | 19.0% | 0.007559 | 0.031284 | 19.5% | 97.0% | 100.0% | 99.4% | 27.2 | 28.0 | 115.9 | 115.9 | SngFast | 190985282452 | 190996030376 | 0 | 18263:800000F780000001800EE51680000005 | 190988261622 | 1 | 18263:8000010B80000007800311FB80000004 | 190994300399 | 1 | 2024-08-20 20:08:16 |
|---|
level = 2, file count = 2, total zip = 0.040 GB, raw = 0.125 GB, over prev level: zip = 1.040410, raw = 3.218097
| 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 |
|---|
| 14684245 | 🟢 | 0.020446 | 0.062500 | 466265 | 0 | 0 | 0 | 1 | 0.002352 | 0.017582 | 11.8% | 0.012159 | 0.050341 | 19.5% | 19.3% | 34.9% | 31.9% | 5.4 | 28.0 | 40.5 | 115.9 | FlatZip | 190852267535 | 190988841257 | 6 | 18263:800000F780000001800EE26180000005 | 190977277430 | 1 | 18263:8000010B8000000480030DB080000004 | 190986898791 | 1 | 2024-08-20 20:00:43 |
|---|
| 14684246 | 🟢 | 0.019730 | 0.062500 | 466277 | 0 | 0 | 0 | 1 | 0.002244 | 0.016977 | 11.7% | 0.012159 | 0.050341 | 19.5% | 18.5% | 33.7% | 30.8% | 5.2 | 28.0 | 39.1 | 115.9 | FlatZip | 190922514730 | 190988839609 | 11 | 18263:8000010B8000000480030DB080000005 | 190986898792 | 1 | 18263:8000010B8000000A8003573A8000000E | 190966339184 | 1 | 2024-08-20 20:00:45 |
|---|
| sum | 2 | 0.040176 | 0.125000 | 932542 | 0 | 0 | 0 | 2 | 0.004596 | 0.034559 | 11.7% | 0.024318 | 0.100682 | 19.5% | 18.9% | 34.3% | 31.3% | 5.3 | 28.0 | 39.8 | 115.9 | FlatZip | 190852267535 | 190988841257 | 0 | 18263:800000F780000001800EE26180000005 | 190977277430 | 1 | 18263:8000010B8000000A8003573A8000000E | 190966339184 | 1 | 2024-08-20 20:00:43 |
|---|
|
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 |
|---|
| 14683747 | 190751235851 | 190976388417 | 0.040981 | 0.040981 | 18263:800000DC8000000A8002DEE580000007 | 190905587369 | 1 | 18263:800000F780000004800EDC4E80000003 | 190953192568 | 1 | 931711 | 0 | 0.026088 | 0.108130 | 0 | | 14683748 | 190751235879 | 190976380297 | 0.040491 | 0.040491 | 18263:800000F780000004800EDC4E80000004 | 190953192569 | 1 | 18263:800000F780000007801067D58000000D | 190791177393 | 1 | 933314 | 0 | 0.026133 | 0.108085 | 0 | | 14683321 | 190579064108 | 190967647645 | 0.038267 | 0.038267 | 18263:800000F78000000A801094CD80000004 | 190966877984 | 1 | 18263:8000010B80000004800330AB80000007 | 190902560929 | 1 | 931683 | 0 | 0.026087 | 0.108131 | 0 | | 14683841 | 190689661026 | 190978145976 | 0.037985 | 0.037985 | 18263:8000010B80000004800330AB80000008 | 190902560930 | 1 | 18263:8000010B800000068003086480000003 | 190977911728 | 1 | 928790 | 0 | 0.026006 | 0.108212 | 0 | | 14683842 | 190829583860 | 190978145384 | 0.038021 | 0.038021 | 18263:8000010B800000068003086480000004 | 190977911729 | 1 | 18263:8000010B8000000880032A2C8000000D | 190893079201 | 1 | 933497 | 0 | 0.026138 | 0.108080 | 0 | | 14683843 | 190870818401 | 190962362303 | 0.005457 | 0.005457 | 18263:8000010B8000000880032A2D80000001 | 190893082418 | 1 | 18263:8000010B800000098002CA8980000008 | 190874522137 | 1 | 123717 | 0 | 0.003464 | 0.014127 | 0 | | 14682972 | 190870815404 | 190962366824 | 0.024307 | 0.024307 | 18263:8000010B800000098002CA8980000009 | 190874522138 | 1 | 18263:8000010B8000000A800354758000000C | 190962362975 | 1 | 583179 | 0 | 0.016329 | 0.067583 | 0 |
|
| compaction |
| compaction_reason | kLevelMaxLevelSize |
| 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 | 190996072532 |
| last_allocated_sequence | 190996072532 |
| last_published_sequence | 189793095786 |
| next_file_number | 14684388 |
| min_log_number_to_keep | 14684328 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 24318 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 1.590263 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 190852267535 |
| earliest_write_conflict_snapshot | 190996072062 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18263:800000F780000001800EE26180000005 |
| largest_user_key | 18263:8000010B8000000A8003573A8000000E |
| existing_snapshots |
190996072062 |
|---|
| 190996072180 |
| 190996072484 |
| 190996072528 |
| extra_serde_files | |
| shutting_down | |
|
|---|