overview |
job_id | 38504 |
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-38504/att-00 |
|
inputs |
all levels summary: version# 19672, file count = 5, total size = 0.109 GB, avg size = 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 | 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.031213 | 232852 | 0 | 0 | 0 | 1 | 0.005894 | 0.025141 | 19.0% | 0.006072 | 0.025141 | 19.5% | 97.1% | 100.0% | 99.4% | 27.2 | 28.0 | 115.9 | 115.9 | SngFast | 190753012562 | 190756585327 | 0 | 18263:8000001C8000000180027D8780000001 | 190753015449 | 1 | 18263:800000A380000001800280D280000006 | 190755333241 | 1 | 2024-08-20 16:02:34 | 30.003 MiB | 31.962 MiB |
L2 | 4 | 4 | 0.078318 | 0.250000 | 1866529 | 0 | 0 | 0 | 4 | 0.009237 | 0.067042 | 12.1% | 0.048674 | 0.201327 | 19.5% | 19.0% | 33.3% | 30.5% | 5.3 | 28.0 | 38.6 | 115.8 | FlatZip | 190586022308 | 190753012465 | 0 | 18263:8000001C800000018002782F80000001 | 190744127924 | 1 | 18263:800000A88000000180047DFF80000002 | 190745659000 | 1 | 2024-08-20 15:59:15 | 18.012 MiB | 64.000 MiB |
sum | 5 | 5 | 0.109353 | 0.281213 | 2099381 | 0 | 0 | 0 | 5 | 0.015131 | 0.092183 | 14.1% | 0.054746 | 0.226467 | 19.5% | 27.6% | 40.7% | 38.2% | 7.7 | 28.0 | 47.1 | 115.8 | FlatZip=4 SngFast=1 | 190586022308 | 190756585327 | 0 | 18263:8000001C800000018002782F80000001 | 190744127924 | 1 | 18263:800000A88000000180047DFF80000002 | 190745659000 | 1 | 2024-08-20 15:59:15 | 20.410 MiB | 57.592 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 |
14673578 | 🟢 | 0.031035 | 0.031213 | 232852 | 0 | 0 | 0 | 1 | 0.005894 | 0.025141 | 19.0% | 0.006072 | 0.025141 | 19.5% | 97.1% | 100.0% | 99.4% | 27.2 | 28.0 | 115.9 | 115.9 | SngFast | 190753012562 | 190756585327 | 7 | 18263:8000001C8000000180027D8780000001 | 190753015449 | 1 | 18263:800000A380000001800280D280000006 | 190755333241 | 1 | 2024-08-20 16:02:34 |
level = 2, file count = 4, total zip = 0.078 GB, raw = 0.250 GB, over prev level: zip = 2.523531, raw = 8.009552
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 |
14673542 | 🟢 | 0.019232 | 0.062500 | 466820 | 0 | 0 | 0 | 1 | 0.002295 | 0.016428 | 12.3% | 0.012173 | 0.050327 | 19.5% | 18.9% | 32.6% | 30.0% | 5.3 | 28.0 | 37.8 | 115.8 | FlatZip | 190683488808 | 190753012254 | 11 | 18263:8000001C800000018002782F80000001 | 190744127924 | 1 | 18263:8000001C8000000780025F888000000C | 190703057717 | 1 | 2024-08-20 15:59:15 |
14673544 | 🟢 | 0.019417 | 0.062500 | 466215 | 0 | 0 | 0 | 1 | 0.002292 | 0.016615 | 12.1% | 0.012158 | 0.050343 | 19.5% | 18.9% | 33.0% | 30.3% | 5.3 | 28.0 | 38.3 | 115.9 | FlatZip | 190683492754 | 190753010834 | 7 | 18263:8000001C800000098002C65B8000000C | 190746361185 | 1 | 18263:800000228000000380026F4880000004 | 190746495049 | 1 | 2024-08-20 15:59:19 |
14673545 | 🟢 | 0.019418 | 0.062500 | 467250 | 0 | 0 | 0 | 1 | 0.002303 | 0.016607 | 12.2% | 0.012184 | 0.050316 | 19.5% | 18.9% | 33.0% | 30.3% | 5.3 | 28.0 | 38.2 | 115.6 | FlatZip | 190682563575 | 190753011882 | 11 | 18263:800000228000000380026F4880000005 | 190746495050 | 1 | 18263:800000228000000880026BBE80000001 | 190740562115 | 1 | 2024-08-20 15:59:21 |
14673546 | 🟢 | 0.020251 | 0.062500 | 466244 | 0 | 0 | 0 | 1 | 0.002347 | 0.017393 | 11.9% | 0.012158 | 0.050342 | 19.5% | 19.3% | 34.6% | 31.6% | 5.4 | 28.0 | 40.1 | 115.9 | FlatZip | 190586022308 | 190753012465 | 7 | 18263:800000228000000880026BBE80000002 | 190740562116 | 1 | 18263:800000A88000000180047DFF80000002 | 190745659000 | 1 | 2024-08-20 15:59:22 |
sum | 4 | 0.078318 | 0.250000 | 1866529 | 0 | 0 | 0 | 4 | 0.009237 | 0.067042 | 12.1% | 0.048674 | 0.201327 | 19.5% | 19.0% | 33.3% | 30.5% | 5.3 | 28.0 | 38.6 | 115.8 | FlatZip | 190586022308 | 190753012465 | 0 | 18263:8000001C800000018002782F80000001 | 190744127924 | 1 | 18263:800000A88000000180047DFF80000002 | 190745659000 | 1 | 2024-08-20 15:59:15 |
|
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 |
---|
14673032 | 190371265509 | 190744109094 | 0.039417 | 0.039417 | 18263:8000001C8000000180025D7080000001 | 190699519837 | 1 | 18263:8000001C800000048002277480000008 | 190611409421 | 1 | 928853 | 0 | 0.026008 | 0.108210 | 0 | 14673033 | 190427349624 | 190744109566 | 0.038480 | 0.038480 | 18263:8000001C800000048002277480000009 | 190611409422 | 1 | 18263:8000001C8000000680027FA280000007 | 190643400769 | 1 | 928990 | 0 | 0.026012 | 0.108206 | 0 | 14673550 | 190518293188 | 190753011836 | 0.038274 | 0.038274 | 18263:8000001C8000000680027FA280000008 | 190643400770 | 1 | 18263:8000001C8000000980020BFD8000000D | 190566755687 | 1 | 931879 | 0 | 0.026093 | 0.108125 | 0 | 14673551 | 190566763513 | 190753007443 | 0.020012 | 0.020012 | 18263:8000001C8000000980020BFE80000001 | 190566763513 | 1 | 18263:8000001C8000000A8002599980000003 | 190693275315 | 1 | 475278 | 0 | 0.013308 | 0.055525 | 0 | 14672062 | 190456765166 | 190720917526 | 0.039667 | 0.039667 | 18263:8000001C8000000A8002599980000004 | 190693275316 | 1 | 18263:8000002280000003800239C58000000A | 190657596058 | 1 | 928591 | 0 | 0.026001 | 0.108217 | 0 | 14672379 | 190456765185 | 190729831290 | 0.038043 | 0.038043 | 18263:8000002280000003800239C58000000B | 190657596059 | 1 | 18263:800000228000000580024A0E80000002 | 190684818633 | 1 | 930530 | 0 | 0.026055 | 0.108163 | 0 | 14672380 | 190605554367 | 190729831413 | 0.019891 | 0.019891 | 18263:800000228000000580024A0E80000003 | 190684818634 | 1 | 18263:800000228000000680026AFD80000002 | 190626087082 | 1 | 462933 | 0 | 0.012962 | 0.053759 | 0 | 14672282 | 189724223715 | 190728056410 | 0.027173 | 0.027173 | 18263:800000228000000980023A0880000001 | 190658018378 | 1 | 18263:8000003C8000000380033DF28000000E | 189729517079 | 1 | 656242 | 0 | 0.018375 | 0.075924 | 0 | 14667818 | 189689290795 | 189988793070 | 0.042950 | 0.042950 | 18263:8000003C8000000380033DF380000001 | 189729517843 | 1 | 18263:800000A380000001800092B480000001 | 189988793070 | 1 | 930957 | 0 | 0.026067 | 0.108151 | 0 | 14673337 | 190416596401 | 190749436708 | 0.039484 | 0.039484 | 18263:800000A38000000180021B4280000005 | 190589531878 | 1 | 18263:800000A3800000048002664B80000007 | 190711661389 | 1 | 929815 | 0 | 0.026035 | 0.108183 | 0 | 14673338 | 190603766283 | 190749437632 | 0.039094 | 0.039094 | 18263:800000A3800000048002664B80000008 | 190711661390 | 1 | 18263:800000A3800000078002656280000003 | 190710089156 | 1 | 931263 | 0 | 0.026075 | 0.108142 | 0 | 14673339 | 190674942932 | 190749434526 | 0.014027 | 0.014027 | 18263:800000A3800000078002656280000004 | 190710089157 | 1 | 18263:800000A3800000088002C17D80000002 | 190743098337 | 1 | 320472 | 0 | 0.008973 | 0.037048 | 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 | 190756693705 |
last_allocated_sequence | 190756693705 |
last_published_sequence | 189793095786 |
next_file_number | 14673602 |
min_log_number_to_keep | 14673558 |
manifest_file_number | 14629260 |
options_file_number | 0 |
prev_log_number | 0 |
current_version_number | 19670 |
|
Others |
allow_ingest_behind | false |
preserve_deletes | false |
bottommost_level | false |
is_deserialized | true |
score | 0.998843 |
preserve_deletes_seqnum | 0 |
smallest_seqno | 190586022308 |
earliest_write_conflict_snapshot | 190756693586 |
paranoid_file_checks | false |
full_history_ts_low | |
smallest_user_key | 18263:8000001C800000018002782F80000001 |
largest_user_key | 18263:800000A88000000180047DFF80000002 |
existing_snapshots |
190756693586 |
190756693605 |
190756693616 |
190756693638 |
190756693668 |
190756693683 |
190756693694 |
190756693705 |
extra_serde_files | |
shutting_down | |
|