overview |
job_id | 9024 |
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-09024/att-00 |
|
inputs |
all levels summary: version# 4681, 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.031198 | 232816 | 0 | 0 | 0 | 1 | 0.005908 | 0.025126 | 19.0% | 0.006071 | 0.025126 | 19.5% | 97.3% | 100.0% | 99.5% | 27.2 | 28.0 | 115.9 | 115.9 | SngFast | 190010840883 | 190012572899 | 0 | 18263:8000001C800000018000A29180000001 | 190010842443 | 1 | 18263:800000A88000000A8003884C8000000E | 190012548455 | 1 | 2024-08-20 05:15:05 | 30.003 MiB | 31.946 MiB |
L2 | 3 | 3 | 0.060455 | 0.187500 | 1397169 | 0 | 0 | 0 | 3 | 0.006707 | 0.052214 | 11.4% | 0.036434 | 0.151066 | 19.4% | 18.4% | 34.6% | 31.4% | 5.2 | 28.0 | 40.1 | 116.1 | FlatZip | 189768092390 | 190010840682 | 0 | 18263:8000001C8000000180009B7F80000001 | 190000538546 | 1 | 18263:800000B98000000A8000ADEC80000006 | 189998461975 | 1 | 2024-08-20 05:14:01 | 18.668 MiB | 64.000 MiB |
sum | 4 | 4 | 0.091490 | 0.218698 | 1629985 | 0 | 0 | 0 | 4 | 0.012615 | 0.077340 | 14.0% | 0.042505 | 0.176193 | 19.4% | 29.7% | 43.9% | 41.1% | 8.3 | 28.0 | 50.9 | 116.1 | FlatZip=3 SngFast=1 | 189768092390 | 190012572899 | 0 | 18263:8000001C8000000180009B7F80000001 | 190000538546 | 1 | 18263:800000B98000000A8000ADEC80000006 | 189998461975 | 1 | 2024-08-20 05:14:01 | 21.502 MiB | 55.987 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 |
14639471 | 🟢 | 0.031035 | 0.031198 | 232816 | 0 | 0 | 0 | 1 | 0.005908 | 0.025126 | 19.0% | 0.006071 | 0.025126 | 19.5% | 97.3% | 100.0% | 99.5% | 27.2 | 28.0 | 115.9 | 115.9 | SngFast | 190010840883 | 190012572899 | 7 | 18263:8000001C800000018000A29180000001 | 190010842443 | 1 | 18263:800000A88000000A8003884C8000000E | 190012548455 | 1 | 2024-08-20 05:15:05 |
level = 2, file count = 3, total zip = 0.060 GB, raw = 0.188 GB, over prev level: zip = 1.947935, raw = 6.010092
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 |
14639437 | 🟢 | 0.020058 | 0.062500 | 466145 | 0 | 0 | 0 | 1 | 0.002124 | 0.017423 | 10.9% | 0.012156 | 0.050344 | 19.4% | 17.5% | 34.6% | 31.3% | 4.9 | 28.0 | 40.1 | 116.0 | FlatZip | 190000534596 | 190010840682 | 7 | 18263:8000001C8000000180009B7F80000001 | 190000538546 | 1 | 18263:800000228000000380009DB48000000A | 190008224528 | 1 | 2024-08-20 05:14:01 |
14639438 | 🟢 | 0.020146 | 0.062500 | 465282 | 0 | 0 | 0 | 1 | 0.002348 | 0.017287 | 12.0% | 0.012133 | 0.050367 | 19.4% | 19.3% | 34.3% | 31.4% | 5.4 | 28.0 | 39.9 | 116.2 | FlatZip | 189768092390 | 190010840086 | 7 | 18263:800000228000000380009DB48000000B | 190008224529 | 1 | 18263:800000A38000000780009F4780000001 | 190006644487 | 1 | 2024-08-20 05:14:02 |
14639439 | 🟢 | 0.020251 | 0.062500 | 465742 | 0 | 0 | 0 | 1 | 0.002236 | 0.017504 | 11.3% | 0.012145 | 0.050355 | 19.4% | 18.4% | 34.8% | 31.6% | 5.2 | 28.0 | 40.4 | 116.1 | FlatZip | 189955357081 | 190010840538 | 7 | 18263:800000A38000000780009F4780000002 | 190006644488 | 1 | 18263:800000B98000000A8000ADEC80000006 | 189998461975 | 1 | 2024-08-20 05:14:04 |
sum | 3 | 0.060455 | 0.187500 | 1397169 | 0 | 0 | 0 | 3 | 0.006707 | 0.052214 | 11.4% | 0.036434 | 0.151066 | 19.4% | 18.4% | 34.6% | 31.4% | 5.2 | 28.0 | 40.1 | 116.1 | FlatZip | 189768092390 | 190010840682 | 0 | 18263:8000001C8000000180009B7F80000001 | 190000538546 | 1 | 18263:800000B98000000A8000ADEC80000006 | 189998461975 | 1 | 2024-08-20 05:14:01 |
|
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 |
---|
14638937 | 189703638130 | 190000533108 | 0.041563 | 0.041563 | 18263:8000000E800000098000875580000008 | 189742643039 | 1 | 18263:8000001C8000000280001E7F80000003 | 189823432916 | 1 | 926625 | 0 | 0.025946 | 0.108272 | 0 | 14638938 | 189823432917 | 190000534171 | 0.019156 | 0.019156 | 18263:8000001C8000000280001E7F80000004 | 189823432917 | 1 | 18263:8000001C800000058000AA2480000007 | 189995103798 | 1 | 423574 | 0 | 0.011860 | 0.049233 | 0 | 14638939 | 189907031157 | 190000533971 | 0.041156 | 0.041156 | 18263:8000001C800000058000AA2480000008 | 189995103799 | 1 | 18263:80000022800000048000A32680000004 | 189987743161 | 1 | 929534 | 0 | 0.026027 | 0.108191 | 0 | 14639346 | 189919094276 | 190009242445 | 0.040296 | 0.040296 | 18263:80000022800000048000A32680000005 | 189987743162 | 1 | 18263:800000228000000A800066A38000000A | 189926381979 | 1 | 927745 | 0 | 0.025977 | 0.108241 | 0 | 14639347 | 189724231068 | 190009241764 | 0.011292 | 0.011292 | 18263:800000228000000A800066A38000000B | 189926381980 | 1 | 18263:8000003C800000038002EBB28000000E | 189741354834 | 1 | 240911 | 0 | 0.006746 | 0.028164 | 0 | 14638941 | 189741354835 | 189788892405 | 0.003442 | 0.003442 | 18263:8000003C800000038002EBB28000000F | 189741354835 | 1 | 18263:8000003C800000038003031080000004 | 189788892405 | 1 | 60021 | 0 | 0.001681 | 0.007082 | 0 | 14638277 | 189689290795 | 189793092486 | 0.040063 | 0.040063 | 18263:8000003C800000038003031080000005 | 189788892406 | 1 | 18263:800000468000000480009B1480000004 | 189768092389 | 1 | 877414 | 0 | 0.024568 | 0.101803 | 0 | 14637899 | 189747081125 | 189976173861 | 0.041239 | 0.041239 | 18263:800000468000000480009C5B80000002 | 189769778009 | 1 | 18263:800000A38000000280003F5980000003 | 189869884659 | 1 | 926700 | 0 | 0.025948 | 0.108270 | 0 | 14639152 | 189869884660 | 190005759647 | 0.040849 | 0.040849 | 18263:800000A38000000280003F5980000004 | 189869884660 | 1 | 18263:800000A380000008800092E880000007 | 189989057306 | 1 | 927837 | 0 | 0.025979 | 0.108238 | 0 | 14639242 | 189907030830 | 190005760302 | 0.041172 | 0.041172 | 18263:800000A380000008800092E880000008 | 189989057307 | 1 | 18263:800000A8800000038003626480000005 | 189938724825 | 1 | 930385 | 0 | 0.026051 | 0.108167 | 0 | 14639243 | 189934619967 | 190005761274 | 0.032145 | 0.032145 | 18263:800000A8800000038003626480000006 | 189938724826 | 1 | 18263:800000A880000009800320E580000005 | 189988768253 | 1 | 720183 | 0 | 0.020165 | 0.083386 | 0 | 14639244 | 189724223277 | 190005760394 | 0.040467 | 0.040467 | 18263:800000A880000009800320E580000006 | 189988768254 | 1 | 18263:800000B9800000018000862580000005 | 189969865355 | 1 | 933151 | 0 | 0.026128 | 0.108090 | 0 | 14639245 | 189886344540 | 190007504258 | 0.035650 | 0.035650 | 18263:800000B9800000018000862580000006 | 189969865356 | 1 | 18263:800000B98000000A8000542280000004 | 189898498497 | 1 | 800489 | 0 | 0.022414 | 0.093566 | 0 | 14637521 | 189706194419 | 189955346827 | 0.017272 | 0.017272 | 18263:800000B98000000A8000542280000005 | 189898498498 | 1 | 18263:800000C2800000068000815E8000000A | 189730542142 | 1 | 366856 | 0 | 0.010272 | 0.042814 | 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 | 190012595948 |
last_allocated_sequence | 190012595948 |
last_published_sequence | 189793095786 |
next_file_number | 14639484 |
min_log_number_to_keep | 14639354 |
manifest_file_number | 14629260 |
options_file_number | 0 |
prev_log_number | 0 |
current_version_number | 4679 |
|
Others |
allow_ingest_behind | false |
preserve_deletes | false |
bottommost_level | false |
is_deserialized | true |
score | 0.983802 |
preserve_deletes_seqnum | 0 |
smallest_seqno | 189768092390 |
earliest_write_conflict_snapshot | 190012595694 |
paranoid_file_checks | false |
full_history_ts_low | |
smallest_user_key | 18263:8000001C8000000180009B7F80000001 |
largest_user_key | 18263:800000B98000000A8000ADEC80000006 |
existing_snapshots |
190012595694 |
190012595896 |
190012595907 |
190012595915 |
190012595948 |
extra_serde_files | |
shutting_down | |
|