| overview |
| job_id | 19021 |
| 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-19021/att-00 |
|
|---|
| inputs |
all levels summary: version# 9768, file count = 8, total size = 0.140 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.027960 | 0.028073 | 209433 | 0 | 0 | 0 | 1 | 0.005347 | 0.022611 | 19.1% | 0.005461 | 0.022611 | 19.5% | 97.9% | 100.0% | 99.6% | 27.4 | 28.0 | 115.9 | 115.9 | SngFast | 190266742423 | 190268500156 | 0 | 18263:800000B980000001800176C880000001 | 190267621178 | 1 | 18263:8000010B8000000A800174FB80000005 | 190268494916 | 1 | 2024-08-20 08:37:19 | 27.032 MiB | 28.747 MiB |
|---|
| L2 | 7 | 7 | 0.111828 | 0.354042 | 2643011 | 0 | 0 | 0 | 7 | 0.012652 | 0.096282 | 11.6% | 0.068922 | 0.285120 | 19.5% | 18.4% | 33.8% | 30.8% | 5.1 | 28.0 | 39.1 | 115.8 | FlatZip | 190201255527 | 190266742388 | 0 | 18263:800000A88000000680039E9C80000006 | 190262801798 | 1 | 18263:8000010B8000000A800173A28000000D | 190266734790 | 1 | 2024-08-20 08:35:58 | 14.773 MiB | 51.791 MiB |
|---|
| sum | 8 | 8 | 0.139788 | 0.382115 | 2852444 | 0 | 0 | 0 | 8 | 0.017999 | 0.118894 | 13.1% | 0.074383 | 0.307732 | 19.5% | 24.2% | 38.6% | 35.8% | 6.8 | 28.0 | 44.8 | 115.8 | FlatZip=7
SngFast=1 | 190201255527 | 190268500156 | 0 | 18263:800000A88000000680039E9C80000006 | 190262801798 | 1 | 18263:8000010B8000000A800174FB80000005 | 190268494916 | 1 | 2024-08-20 08:35:58 | 16.306 MiB | 48.911 MiB |
|---|
level = 1, file count = 1, total zip = 0.028 GB, raw = 0.028 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 |
|---|
| 14650950 | 🟢 | 0.027960 | 0.028073 | 209433 | 0 | 0 | 0 | 1 | 0.005347 | 0.022611 | 19.1% | 0.005461 | 0.022611 | 19.5% | 97.9% | 100.0% | 99.6% | 27.4 | 28.0 | 115.9 | 115.9 | SngFast | 190266742423 | 190268500156 | 6 | 18263:800000B980000001800176C880000001 | 190267621178 | 1 | 18263:8000010B8000000A800174FB80000005 | 190268494916 | 1 | 2024-08-20 08:37:19 |
|---|
level = 2, file count = 7, total zip = 0.112 GB, raw = 0.354 GB, over prev level: zip = 3.999610, raw = 12.611541
| 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 |
|---|
| 14650899 | 🟢 | 0.019858 | 0.062500 | 465911 | 0 | 0 | 0 | 1 | 0.002231 | 0.017116 | 11.5% | 0.012150 | 0.050350 | 19.4% | 18.4% | 34.0% | 31.0% | 5.1 | 28.0 | 39.4 | 116.0 | FlatZip | 190201255527 | 190266742388 | 7 | 18263:800000A88000000680039E9C80000006 | 190262801798 | 1 | 18263:800000B980000005800146C480000003 | 190254294849 | 1 | 2024-08-20 08:36:16 |
|---|
| 14650900 | 🟢 | 0.000040 | 0.000067 | 490 | 0 | 0 | 0 | 1 | 0.000015 | 0.000023 | 39.5% | 0.000013 | 0.000054 | 19.2% | 116.6% | 42.4% | 56.6% | 32.7 | 28.0 | 50.0 | 118.0 | FlatZip | 190254294850 | 190254537988 | 15 | 18263:800000B980000005800146C480000004 | 190254294850 | 1 | 18263:800000B980000005800146F680000003 | 190254537988 | 1 | 2024-08-20 08:36:17 |
|---|
| 14650886 | 🟢 | 0.019676 | 0.062500 | 466878 | 0 | 0 | 0 | 1 | 0.002241 | 0.016925 | 11.7% | 0.012175 | 0.050325 | 19.5% | 18.4% | 33.6% | 30.7% | 5.2 | 28.0 | 38.9 | 115.7 | FlatZip | 190226725450 | 190266741757 | 7 | 18263:800000B980000005800146F680000004 | 190254537989 | 1 | 18263:800000DC80000001800176898000000B | 190264700877 | 1 | 2024-08-20 08:35:58 |
|---|
| 14650887 | 🟢 | 0.019422 | 0.062500 | 466089 | 0 | 0 | 0 | 1 | 0.002243 | 0.016670 | 11.9% | 0.012154 | 0.050346 | 19.4% | 18.5% | 33.1% | 30.3% | 5.2 | 28.0 | 38.4 | 116.0 | FlatZip | 190212843349 | 190266740942 | 11 | 18263:800000DC800000018001768A80000001 | 190264701438 | 1 | 18263:800000DC8000000680014ECA80000001 | 190266055857 | 1 | 2024-08-20 08:36:01 |
|---|
| 14650888 | 🟢 | 0.019124 | 0.062500 | 467404 | 0 | 0 | 0 | 1 | 0.002244 | 0.016371 | 12.1% | 0.012189 | 0.050312 | 19.5% | 18.4% | 32.5% | 29.8% | 5.2 | 28.0 | 37.6 | 115.6 | FlatZip | 190217941686 | 190266742059 | 11 | 18263:800000DC8000000680014ECA80000002 | 190266055858 | 1 | 18263:800000DC8000000A80013F0B80000002 | 190242058137 | 1 | 2024-08-20 08:36:03 |
|---|
| 14650893 | 🟢 | 0.020417 | 0.062500 | 466303 | 0 | 0 | 0 | 1 | 0.002190 | 0.017716 | 11.0% | 0.012160 | 0.050340 | 19.5% | 18.0% | 35.2% | 31.8% | 5.0 | 28.0 | 40.8 | 115.9 | FlatZip | 190240744982 | 190266741968 | 6 | 18263:800000DC8000000A80013F0B80000003 | 190242058138 | 1 | 18263:8000010B800000038001770480000004 | 190265199945 | 1 | 2024-08-20 08:36:09 |
|---|
| 14650894 | 🟢 | 0.013292 | 0.041475 | 309936 | 0 | 0 | 0 | 1 | 0.001488 | 0.011461 | 11.5% | 0.008082 | 0.033393 | 19.5% | 18.4% | 34.3% | 31.2% | 5.2 | 28.0 | 39.7 | 115.7 | FlatZip | 190217943267 | 190266742362 | 11 | 18263:8000010B800000038001770480000005 | 190265199946 | 1 | 18263:8000010B8000000A800173A28000000D | 190266734790 | 1 | 2024-08-20 08:36:11 |
|---|
| sum | 7 | 0.111828 | 0.354042 | 2643011 | 0 | 0 | 0 | 7 | 0.012652 | 0.096282 | 11.6% | 0.068922 | 0.285120 | 19.5% | 18.4% | 33.8% | 30.8% | 5.1 | 28.0 | 39.1 | 115.8 | FlatZip | 190201255527 | 190266742388 | 0 | 18263:800000A88000000680039E9C80000006 | 190262801798 | 1 | 18263:8000010B8000000A800173A28000000D | 190266734790 | 1 | 2024-08-20 08:35:58 |
|---|
|
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 |
|---|
| 14650475 | 190133154487 | 190252855933 | 0.020381 | 0.020381 | 18263:800000A8800000068003E7C680000006 | 190202336110 | 1 | 18263:800000A8800000098003903780000008 | 190232022948 | 1 | 466095 | 0 | 0.013051 | 0.054058 | 0 | | 14650697 | 189724223277 | 190261467935 | 0.040061 | 0.040061 | 18263:800000A88000000A800386A580000009 | 190211207844 | 1 | 18263:800000B98000000280014BA880000002 | 190209421946 | 1 | 930923 | 0 | 0.026066 | 0.108152 | 0 | | 14650698 | 190187309707 | 190261466203 | 0.015844 | 0.015844 | 18263:800000B98000000280014BA880000003 | 190209421947 | 1 | 18263:800000B98000000480012B0180000008 | 190212198396 | 1 | 359685 | 0 | 0.010071 | 0.041659 | 0 | | 14650355 | 190048815600 | 190252857590 | 0.039807 | 0.039807 | 18263:800000B98000000480012B0180000009 | 190212198397 | 1 | 18263:800000B980000008800143E68000000B | 190249770720 | 1 | 929176 | 0 | 0.026017 | 0.108201 | 0 | | 14650356 | 189706194419 | 190252857626 | 0.040502 | 0.040502 | 18263:800000B980000008800143E68000000C | 190249770721 | 1 | 18263:800000DC8000000280013E3280000004 | 190240895843 | 1 | 927418 | 0 | 0.025968 | 0.108250 | 0 | | 14650357 | 190212838827 | 190252855053 | 0.007556 | 0.007556 | 18263:800000DC8000000280013E3280000005 | 190240895844 | 1 | 18263:800000DC80000003800145CF80000004 | 190252152930 | 1 | 162497 | 0 | 0.004550 | 0.018871 | 0 | | 14649244 | 190047078055 | 190230232469 | 0.039360 | 0.039360 | 18263:800000DC800000038001507680000003 | 190213735861 | 1 | 18263:800000DC80000007800137FC80000007 | 190179824915 | 1 | 926437 | 0 | 0.025940 | 0.108278 | 0 | | 14649740 | 190124758173 | 190240744488 | 0.040193 | 0.040193 | 18263:800000DC80000007800137FD80000001 | 190179832161 | 1 | 18263:800000F780000004800E28FB80000001 | 190225745106 | 1 | 930561 | 0 | 0.026056 | 0.108162 | 0 | | 14650673 | 190027915591 | 190261468146 | 0.041050 | 0.041050 | 18263:800000F780000004800E28FB80000002 | 190225745107 | 1 | 18263:8000010B800000038001373F80000001 | 190232498858 | 1 | 929905 | 0 | 0.026037 | 0.108180 | 0 | | 14650674 | 190012584926 | 190261467686 | 0.033430 | 0.033430 | 18263:8000010B800000038001373F80000002 | 190232498859 | 1 | 18263:8000010B800000068001103A80000007 | 190173473813 | 1 | 783138 | 0 | 0.021928 | 0.091457 | 0 | | 14650567 | 190164049991 | 190257951529 | 0.012073 | 0.012073 | 18263:8000010B800000098001476680000008 | 190256827519 | 1 | 18263:8000010B8000000A80016D858000000F | 190257945637 | 1 | 271186 | 0 | 0.007593 | 0.031412 | 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 | 190268520623 |
| last_allocated_sequence | 190268520623 |
| last_published_sequence | 189793095786 |
| next_file_number | 14650955 |
| min_log_number_to_keep | 14650803 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 9766 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.976188 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 190201255527 |
| earliest_write_conflict_snapshot | 190268520533 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18263:800000A88000000680039E9C80000006 |
| largest_user_key | 18263:8000010B8000000A800174FB80000005 |
| existing_snapshots |
190268520533 |
|---|
| 190268520556 |
| 190268520578 |
| 190268520589 |
| 190268520601 |
| 190268520612 |
| 190268520623 |
| extra_serde_files | |
| shutting_down | |
|
|---|