| overview |
| job_id | 40075 |
| 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-40075/att-00 |
|
|---|
| inputs |
all levels summary: version# 20440, file count = 7, total size = 0.124 GB, avg size = 0.018 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.020443 | 0.020508 | 153097 | 0 | 0 | 0 | 1 | 0.003927 | 0.016516 | 19.2% | 0.003992 | 0.016516 | 19.5% | 98.4% | 100.0% | 99.7% | 27.5 | 28.0 | 115.8 | 115.8 | SngFast | 190793772916 | 190795554139 | 0 | 18263:800000B9800000038002EC0480000006 | 190795217601 | 1 | 18263:8000010B800000058002E7BC80000008 | 190795390346 | 1 | 2024-08-20 16:41:30 | 19.765 MiB | 21.000 MiB |
|---|
| L2 | 6 | 6 | 0.103938 | 0.328040 | 2447219 | 0 | 0 | 0 | 6 | 0.011700 | 0.089549 | 11.6% | 0.063816 | 0.264224 | 19.5% | 18.3% | 33.9% | 30.9% | 5.1 | 28.0 | 39.3 | 115.9 | FlatZip | 190706755556 | 190795551021 | 0 | 18263:800000B9800000038002E50280000003 | 190785181584 | 1 | 18263:8000010B8000000A8002E5AB8000000A | 190795547871 | 1 | 2024-08-20 16:40:07 | 16.027 MiB | 55.985 MiB |
|---|
| sum | 7 | 7 | 0.124381 | 0.348548 | 2600316 | 0 | 0 | 0 | 7 | 0.015627 | 0.106065 | 12.8% | 0.067809 | 0.280740 | 19.5% | 23.0% | 37.8% | 34.9% | 6.5 | 28.0 | 43.8 | 115.9 | FlatZip=6
SngFast=1 | 190706755556 | 190795554139 | 0 | 18263:800000B9800000038002E50280000003 | 190785181584 | 1 | 18263:8000010B8000000A8002E5AB8000000A | 190795547871 | 1 | 2024-08-20 16:40:07 | 16.561 MiB | 50.988 MiB |
|---|
level = 1, file count = 1, total zip = 0.020 GB, raw = 0.021 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 |
|---|
| 14675296 | 🟢 | 0.020443 | 0.020508 | 153097 | 0 | 0 | 0 | 1 | 0.003927 | 0.016516 | 19.2% | 0.003992 | 0.016516 | 19.5% | 98.4% | 100.0% | 99.7% | 27.5 | 28.0 | 115.8 | 115.8 | SngFast | 190793772916 | 190795554139 | 6 | 18263:800000B9800000038002EC0480000006 | 190795217601 | 1 | 18263:8000010B800000058002E7BC80000008 | 190795390346 | 1 | 2024-08-20 16:41:30 |
|---|
level = 2, file count = 6, total zip = 0.104 GB, raw = 0.328 GB, over prev level: zip = 5.084194, raw = 15.995469
| 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 |
|---|
| 14675353 | 🟢 | 0.010010 | 0.031194 | 232591 | 0 | 0 | 0 | 1 | 0.001090 | 0.008659 | 11.2% | 0.006065 | 0.025128 | 19.4% | 18.0% | 34.5% | 31.3% | 5.0 | 28.0 | 40.0 | 116.0 | FlatZip | 190768977930 | 190795217600 | 11 | 18263:800000B9800000038002E50280000003 | 190785181584 | 1 | 18263:800000B9800000068002DA7780000003 | 190777282821 | 1 | 2024-08-20 16:41:52 |
|---|
| 14675256 | 🟢 | 0.019547 | 0.062500 | 466280 | 0 | 0 | 0 | 1 | 0.002298 | 0.016738 | 12.1% | 0.012159 | 0.050341 | 19.5% | 18.9% | 33.3% | 30.5% | 5.3 | 28.0 | 38.5 | 115.9 | FlatZip | 190706755556 | 190793772123 | 7 | 18263:800000B9800000068002DA7780000004 | 190777282822 | 1 | 18263:800000DC80000001800296DE80000004 | 190784989956 | 1 | 2024-08-20 16:40:07 |
|---|
| 14675257 | 🟢 | 0.019684 | 0.062500 | 466206 | 0 | 0 | 0 | 1 | 0.002238 | 0.016937 | 11.7% | 0.012157 | 0.050343 | 19.5% | 18.4% | 33.6% | 30.7% | 5.2 | 28.0 | 39.0 | 115.9 | FlatZip | 190749274108 | 190793772586 | 11 | 18263:800000DC80000001800296DE80000005 | 190784989957 | 1 | 18263:800000DC8000000780028F7580000005 | 190772915949 | 1 | 2024-08-20 16:40:10 |
|---|
| 14675258 | 🟢 | 0.020099 | 0.062500 | 466301 | 0 | 0 | 0 | 1 | 0.002184 | 0.017404 | 11.2% | 0.012160 | 0.050340 | 19.5% | 18.0% | 34.6% | 31.3% | 5.0 | 28.0 | 40.1 | 115.9 | FlatZip | 190767219989 | 190793772015 | 7 | 18263:800000DC8000000780028F7680000001 | 190772923984 | 1 | 18263:800000F780000008801069F280000001 | 190779493766 | 1 | 2024-08-20 16:40:12 |
|---|
| 14675259 | 🟢 | 0.019781 | 0.062500 | 465825 | 0 | 0 | 0 | 1 | 0.002242 | 0.017028 | 11.6% | 0.012147 | 0.050353 | 19.4% | 18.5% | 33.8% | 30.8% | 5.2 | 28.0 | 39.2 | 116.1 | FlatZip | 190751226143 | 190793772146 | 6 | 18263:800000F780000008801069F280000002 | 190779493767 | 1 | 18263:8000010B80000005800298248000000E | 190790532840 | 1 | 2024-08-20 16:40:13 |
|---|
| 14675310 | 🟢 | 0.014816 | 0.046846 | 350016 | 0 | 0 | 0 | 1 | 0.001648 | 0.012783 | 11.4% | 0.009127 | 0.037718 | 19.5% | 18.1% | 33.9% | 30.8% | 5.1 | 28.0 | 39.2 | 115.7 | FlatZip | 190768978403 | 190795551021 | 11 | 18263:8000010B80000005800298248000000F | 190790532841 | 1 | 18263:8000010B8000000A8002E5AB8000000A | 190795547871 | 1 | 2024-08-20 16:41:33 |
|---|
| sum | 6 | 0.103938 | 0.328040 | 2447219 | 0 | 0 | 0 | 6 | 0.011700 | 0.089549 | 11.6% | 0.063816 | 0.264224 | 19.5% | 18.3% | 33.9% | 30.9% | 5.1 | 28.0 | 39.3 | 115.9 | FlatZip | 190706755556 | 190795551021 | 0 | 18263:800000B9800000038002E50280000003 | 190785181584 | 1 | 18263:8000010B8000000A8002E5AB8000000A | 190795547871 | 1 | 2024-08-20 16:40:07 |
|---|
|
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 |
|---|
| 14674232 | 190671008577 | 190768972767 | 0.039001 | 0.039001 | 18263:800000B98000000180025EDB8000000B | 190693698800 | 1 | 18263:800000B9800000058002689580000002 | 190709624176 | 1 | 933266 | 0 | 0.026131 | 0.108086 | 0 | | 14674302 | 190651423288 | 190768974786 | 0.039713 | 0.039713 | 18263:800000B9800000058002689580000003 | 190709624177 | 1 | 18263:800000B9800000098002A21B80000007 | 190694962732 | 1 | 931142 | 0 | 0.026072 | 0.108146 | 0 | | 14674455 | 189706194419 | 190774329110 | 0.039468 | 0.039468 | 18263:800000B9800000098002A21B80000008 | 190694962733 | 1 | 18263:800000DC800000018002475E80000003 | 190655222260 | 1 | 929142 | 0 | 0.026016 | 0.108202 | 0 | | 14674456 | 190516604946 | 190774334494 | 0.039189 | 0.039189 | 18263:800000DC800000018002475E80000004 | 190655222261 | 1 | 18263:800000DC8000000480021A118000000C | 190582625720 | 1 | 930502 | 0 | 0.026054 | 0.108164 | 0 | | 14674457 | 190582632354 | 190749274107 | 0.008885 | 0.008885 | 18263:800000DC8000000480021A1280000001 | 190582632354 | 1 | 18263:800000DC800000048002810580000006 | 190749274107 | 1 | 168510 | 0 | 0.004718 | 0.019884 | 0 | | 14674120 | 190610693585 | 190767217011 | 0.038538 | 0.038538 | 18263:800000DC80000004800288138000000B | 190760928744 | 1 | 18263:800000DC800000088002C5B98000000B | 190747707923 | 1 | 933071 | 0 | 0.026126 | 0.108092 | 0 | | 14674550 | 190569358844 | 190776128566 | 0.041705 | 0.041705 | 18263:800000DC800000088002C5B98000000C | 190747707924 | 1 | 18263:800000F78000000A8010481D80000004 | 190692660561 | 1 | 931758 | 0 | 0.026089 | 0.108129 | 0 | | 14674551 | 190579064108 | 190776123125 | 0.037390 | 0.037390 | 18263:800000F78000000A8010481D80000005 | 190692660562 | 1 | 18263:8000010B800000038002492280000001 | 190661667794 | 1 | 892882 | 0 | 0.025001 | 0.103624 | 0 | | 14674214 | 190579064127 | 190768976287 | 0.039639 | 0.039639 | 18263:8000010B800000038002492280000002 | 190661667795 | 1 | 18263:8000010B800000088002A02180000006 | 190689571428 | 1 | 932470 | 0 | 0.026109 | 0.108109 | 0 | | 14675012 | 190610704813 | 190788403521 | 0.025022 | 0.025022 | 18263:8000010B800000088002A02180000007 | 190689571429 | 1 | 18263:8000010B8000000A8002E0A980000007 | 190788403369 | 1 | 584492 | 0 | 0.016366 | 0.067596 | 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 | 190795957995 |
| last_allocated_sequence | 190795957995 |
| last_published_sequence | 189793095786 |
| next_file_number | 14675354 |
| min_log_number_to_keep | 14675148 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 20438 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.992087 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 190706755556 |
| earliest_write_conflict_snapshot | 190795956944 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18263:800000B9800000038002E50280000003 |
| largest_user_key | 18263:8000010B8000000A8002E5AB8000000A |
| existing_snapshots |
190795956944 |
|---|
| 190795957936 |
| 190795957947 |
| 190795957969 |
| 190795957980 |
| 190795957995 |
| extra_serde_files | |
| shutting_down | |
|
|---|