| overview |
| job_id | 28526 |
| 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 | 465QC0QPK7Q93426EREI |
|
|---|
| 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-28526/att-00 |
|
|---|
| inputs |
all levels summary: version# 15019, file count = 7, total size = 0.139 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 | 1 | 1 | 0.022557 | 0.022611 | 168732 | 0 | 0 | 0 | 1 | 0.004346 | 0.018211 | 19.3% | 0.004400 | 0.018211 | 19.5% | 98.8% | 100.0% | 99.8% | 27.7 | 28.0 | 115.9 | 115.9 | SngFast | 147890992257 | 147892797824 | 0 | 18263:80000018800000018002135080000001 | 147891005237 | 1 | 18263:80000029800000028002591880000005 | 147892257364 | 1 | 2024-07-09 03:21:53 | 21.810 MiB | 23.153 MiB |
|---|
| L2 | 6 | 6 | 0.116424 | 0.375000 | 2799769 | 0 | 0 | 0 | 6 | 0.013500 | 0.099866 | 11.9% | 0.073010 | 0.301991 | 19.5% | 18.5% | 33.1% | 30.2% | 5.2 | 28.0 | 38.3 | 115.8 | FlatZip | 147804901157 | 147890992009 | 0 | 18263:8000001880000001800208DD80000001 | 147875080494 | 1 | 18263:8000002980000003800251AF80000003 | 147883554430 | 1 | 2024-07-09 03:19:46 | 17.892 MiB | 64.000 MiB |
|---|
| sum | 7 | 7 | 0.138981 | 0.397611 | 2968501 | 0 | 0 | 0 | 7 | 0.017846 | 0.118077 | 13.1% | 0.077410 | 0.320201 | 19.5% | 23.1% | 36.9% | 34.2% | 6.5 | 28.0 | 42.7 | 115.8 | FlatZip=6
SngFast=1 | 147804901157 | 147892797824 | 0 | 18263:8000001880000001800208DD80000001 | 147875080494 | 1 | 18263:8000002980000003800251AF80000003 | 147883554430 | 1 | 2024-07-09 03:19:46 | 18.452 MiB | 58.165 MiB |
|---|
level = 1, file count = 1, total zip = 0.023 GB, raw = 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 |
|---|
| 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 |
|---|
| 12658215 | 🟢 | 0.022557 | 0.022611 | 168732 | 0 | 0 | 0 | 1 | 0.004346 | 0.018211 | 19.3% | 0.004400 | 0.018211 | 19.5% | 98.8% | 100.0% | 99.8% | 27.7 | 28.0 | 115.9 | 115.9 | SngFast | 147890992257 | 147892797824 | 7 | 18263:80000018800000018002135080000001 | 147891005237 | 1 | 18263:80000029800000028002591880000005 | 147892257364 | 1 | 2024-07-09 03:21:53 |
|---|
level = 2, file count = 6, total zip = 0.116 GB, raw = 0.375 GB, over prev level: zip = 5.161287, raw = 16.585202
| 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 |
|---|
| 12658175 | 🟢 | 0.019462 | 0.062500 | 466603 | 0 | 0 | 0 | 1 | 0.002240 | 0.016713 | 11.8% | 0.012168 | 0.050332 | 19.5% | 18.4% | 33.2% | 30.3% | 5.2 | 28.0 | 38.5 | 115.8 | FlatZip | 147825674883 | 147890991836 | 11 | 18263:8000001880000001800208DD80000001 | 147875080494 | 1 | 18263:80000018800000078002097780000009 | 147876043251 | 1 | 2024-07-09 03:19:46 |
|---|
| 12658176 | 🟢 | 0.019829 | 0.062500 | 466538 | 0 | 0 | 0 | 1 | 0.002240 | 0.017080 | 11.6% | 0.012166 | 0.050334 | 19.5% | 18.4% | 33.9% | 30.9% | 5.2 | 28.0 | 39.3 | 115.8 | FlatZip | 147825674206 | 147890991631 | 7 | 18263:8000001880000007800209778000000A | 147876043252 | 1 | 18263:8000002080000004800F07A380000008 | 147869211684 | 1 | 2024-07-09 03:19:53 |
|---|
| 12658177 | 🟢 | 0.019804 | 0.062500 | 466064 | 0 | 0 | 0 | 1 | 0.002297 | 0.016995 | 11.9% | 0.012154 | 0.050347 | 19.4% | 18.9% | 33.8% | 30.9% | 5.3 | 28.0 | 39.2 | 116.0 | FlatZip | 147812289262 | 147890991928 | 7 | 18263:8000002080000004800F07A380000009 | 147869211685 | 1 | 18263:800000288000000480022EED80000007 | 147834162716 | 1 | 2024-07-09 03:19:55 |
|---|
| 12658178 | 🟢 | 0.019030 | 0.062500 | 467906 | 0 | 0 | 0 | 1 | 0.002301 | 0.016221 | 12.4% | 0.012202 | 0.050298 | 19.5% | 18.9% | 32.3% | 29.6% | 5.3 | 28.0 | 37.2 | 115.4 | FlatZip | 147804901157 | 147890991960 | 11 | 18263:800000288000000480022EED80000008 | 147834162717 | 1 | 18263:80000028800000078001FB4680000009 | 147844114386 | 1 | 2024-07-09 03:19:56 |
|---|
| 12658179 | 🟢 | 0.018810 | 0.062500 | 465954 | 0 | 0 | 0 | 1 | 0.002242 | 0.016059 | 12.3% | 0.012151 | 0.050349 | 19.4% | 18.5% | 31.9% | 29.3% | 5.2 | 28.0 | 37.0 | 116.0 | FlatZip | 147830936304 | 147890991986 | 11 | 18263:80000028800000078001FB468000000A | 147844114387 | 1 | 18263:8000002880000009800216F480000002 | 147884780412 | 1 | 2024-07-09 03:19:59 |
|---|
| 12658180 | 🟢 | 0.019489 | 0.062500 | 466704 | 0 | 0 | 0 | 1 | 0.002180 | 0.016798 | 11.5% | 0.012170 | 0.050330 | 19.5% | 17.9% | 33.4% | 30.4% | 5.0 | 28.0 | 38.6 | 115.8 | FlatZip | 147862450634 | 147890992009 | 7 | 18263:8000002880000009800216F480000003 | 147884780413 | 1 | 18263:8000002980000003800251AF80000003 | 147883554430 | 1 | 2024-07-09 03:20:01 |
|---|
| sum | 6 | 0.116424 | 0.375000 | 2799769 | 0 | 0 | 0 | 6 | 0.013500 | 0.099866 | 11.9% | 0.073010 | 0.301991 | 19.5% | 18.5% | 33.1% | 30.2% | 5.2 | 28.0 | 38.3 | 115.8 | FlatZip | 147804901157 | 147890992009 | 0 | 18263:8000001880000001800208DD80000001 | 147875080494 | 1 | 18263:8000002980000003800251AF80000003 | 147883554430 | 1 | 2024-07-09 03:19:46 |
|---|
|
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 |
|---|
| 12657408 | 147782189131 | 147875072662 | 0.038171 | 0.038171 | 18263:80000018800000018001CAAD80000001 | 147782189131 | 1 | 18263:800000188000000380023E2B8000000A | 147863685967 | 1 | 931737 | 0 | 0.026089 | 0.108129 | 0 | | 12657409 | 147780192472 | 147875073903 | 0.035565 | 0.035565 | 18263:800000188000000380023E2B8000000B | 147863685968 | 1 | 18263:800000188000000680021FBB80000005 | 147817542352 | 1 | 859175 | 0 | 0.024057 | 0.099687 | 0 | | 12657170 | 147744788623 | 147869657086 | 0.010807 | 0.010807 | 18263:80000018800000098001EA1D8000000D | 147828904293 | 1 | 18263:800000188000000A8001C29080000004 | 147770267705 | 1 | 243100 | 0 | 0.006807 | 0.028167 | 0 | | 12657071 | 147562442555 | 147867857921 | 0.040684 | 0.040684 | 18263:800000188000000A8001C29080000005 | 147770267706 | 1 | 18263:80000020800000058010B59B80000008 | 147854542502 | 1 | 933027 | 0 | 0.026125 | 0.108093 | 0 | | 12658093 | 147387048507 | 147889391263 | 0.039786 | 0.039786 | 18263:80000020800000058010B59B80000009 | 147854542503 | 1 | 18263:800000208000000A800EE0D28000000B | 147735570115 | 1 | 936008 | 0 | 0.026208 | 0.108010 | 0 | | 12656772 | 147505858016 | 147862449847 | 0.038898 | 0.038898 | 18263:80000028800000028001F1A180000007 | 147755302318 | 1 | 18263:80000028800000058001834380000003 | 147668940937 | 1 | 930086 | 0 | 0.026042 | 0.108175 | 0 | | 12656773 | 147668940938 | 147804813396 | 0.012234 | 0.012234 | 18263:80000028800000058001834380000004 | 147668940938 | 1 | 18263:80000028800000058001E0908000000A | 147804813396 | 1 | 239260 | 0 | 0.006699 | 0.028233 | 0 | | 12656674 | 147653870801 | 147860665021 | 0.039362 | 0.039362 | 18263:80000028800000058001E0908000000B | 147804813397 | 1 | 18263:80000028800000088001E98180000002 | 147818007854 | 1 | 929938 | 0 | 0.026038 | 0.108180 | 0 | | 12656675 | 147753481710 | 147830927743 | 0.007174 | 0.007174 | 18263:80000028800000088001E98180000003 | 147818007855 | 1 | 18263:8000002880000008800220F580000007 | 147815473248 | 1 | 141690 | 0 | 0.003967 | 0.016241 | 0 | | 12656784 | 147595240050 | 147862449932 | 0.039022 | 0.039022 | 18263:8000002880000008800220F580000008 | 147815473249 | 1 | 18263:800000298000000180019BB680000003 | 147707241059 | 1 | 928999 | 0 | 0.026012 | 0.108206 | 0 | | 12656785 | 147707241060 | 147862449179 | 0.039360 | 0.039360 | 18263:800000298000000180019BB680000004 | 147707241060 | 1 | 18263:80000029800000048001EC1980000001 | 147825410286 | 1 | 928709 | 0 | 0.026004 | 0.108214 | 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 | 147892838504 |
| last_allocated_sequence | 147892838504 |
| last_published_sequence | 147176466927 |
| next_file_number | 12658225 |
| min_log_number_to_keep | 12658165 |
| manifest_file_number | 12625661 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 15017 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.994953 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 147804901157 |
| earliest_write_conflict_snapshot | 147892838275 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18263:8000001880000001800208DD80000001 |
| largest_user_key | 18263:8000002980000003800251AF80000003 |
| existing_snapshots |
147892838275 |
|---|
| 147892838279 |
| 147892838373 |
| 147892838377 |
| 147892838410 |
| 147892838425 |
| 147892838473 |
| 147892838504 |
| extra_serde_files | |
| shutting_down | |
|
|---|