| overview |
| job_id | 18850 |
| 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-18850/att-00 |
|
|---|
| inputs |
all levels summary: version# 9677, 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.031205 | 232944 | 0 | 0 | 0 | 1 | 0.005903 | 0.025131 | 19.0% | 0.006074 | 0.025131 | 19.5% | 97.2% | 100.0% | 99.5% | 27.2 | 28.0 | 115.8 | 115.8 | SngFast | 190261468477 | 190263213589 | 0 | 18263:8000001C8000000180014A7C80000001 | 190261470608 | 1 | 18263:800000B98000000280014B8F80000009 | 190261603808 | 1 | 2024-08-20 08:32:51 | 30.002 MiB | 31.954 MiB |
|---|
| L2 | 3 | 3 | 0.060102 | 0.187500 | 1397198 | 0 | 0 | 0 | 3 | 0.006875 | 0.051694 | 11.7% | 0.036435 | 0.151065 | 19.4% | 18.9% | 34.2% | 31.2% | 5.3 | 28.0 | 39.7 | 116.1 | FlatZip | 189768092390 | 190261468327 | 0 | 18263:8000001C800000018001482C80000001 | 190257955511 | 1 | 18263:800000A88000000A800386A580000008 | 190211207843 | 1 | 2024-08-20 08:31:32 | 18.492 MiB | 64.000 MiB |
|---|
| sum | 4 | 4 | 0.091137 | 0.218705 | 1630142 | 0 | 0 | 0 | 4 | 0.012779 | 0.076824 | 14.3% | 0.042509 | 0.176196 | 19.4% | 30.1% | 43.6% | 41.0% | 8.4 | 28.0 | 50.6 | 116.1 | FlatZip=3
SngFast=1 | 189768092390 | 190263213589 | 0 | 18263:8000001C800000018001482C80000001 | 190257955511 | 1 | 18263:800000B98000000280014B8F80000009 | 190261603808 | 1 | 2024-08-20 08:31:32 | 21.370 MiB | 55.989 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 |
|---|
| 14650719 | 🟢 | 0.031035 | 0.031205 | 232944 | 0 | 0 | 0 | 1 | 0.005903 | 0.025131 | 19.0% | 0.006074 | 0.025131 | 19.5% | 97.2% | 100.0% | 99.5% | 27.2 | 28.0 | 115.8 | 115.8 | SngFast | 190261468477 | 190263213589 | 7 | 18263:8000001C8000000180014A7C80000001 | 190261470608 | 1 | 18263:800000B98000000280014B8F80000009 | 190261603808 | 1 | 2024-08-20 08:32:51 |
|---|
level = 2, file count = 3, total zip = 0.060 GB, raw = 0.188 GB, over prev level: zip = 1.936606, raw = 6.008648
| 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 |
|---|
| 14650686 | 🟢 | 0.020042 | 0.062500 | 466271 | 0 | 0 | 0 | 1 | 0.002233 | 0.017298 | 11.4% | 0.012159 | 0.050341 | 19.5% | 18.4% | 34.4% | 31.3% | 5.1 | 28.0 | 39.8 | 115.9 | FlatZip | 190224968321 | 190261468020 | 7 | 18263:8000001C800000018001482C80000001 | 190257955511 | 1 | 18263:80000022800000098001367280000004 | 190241256410 | 1 | 2024-08-20 08:31:52 |
|---|
| 14650665 | 🟢 | 0.019864 | 0.062500 | 464639 | 0 | 0 | 0 | 1 | 0.002403 | 0.016949 | 12.4% | 0.012116 | 0.050384 | 19.4% | 19.8% | 33.6% | 31.0% | 5.6 | 28.0 | 39.2 | 116.4 | FlatZip | 189768092390 | 190261467867 | 7 | 18263:800000228000000A8001602680000009 | 190244003126 | 1 | 18263:800000A380000005800168F480000007 | 190247472881 | 1 | 2024-08-20 08:31:32 |
|---|
| 14650666 | 🟢 | 0.020196 | 0.062500 | 466288 | 0 | 0 | 0 | 1 | 0.002238 | 0.017446 | 11.4% | 0.012159 | 0.050341 | 19.5% | 18.4% | 34.7% | 31.5% | 5.2 | 28.0 | 40.2 | 115.9 | FlatZip | 190201255527 | 190261468327 | 7 | 18263:800000A380000005800168F480000008 | 190247472882 | 1 | 18263:800000A88000000A800386A580000008 | 190211207843 | 1 | 2024-08-20 08:31:37 |
|---|
| sum | 3 | 0.060102 | 0.187500 | 1397198 | 0 | 0 | 0 | 3 | 0.006875 | 0.051694 | 11.7% | 0.036435 | 0.151065 | 19.4% | 18.9% | 34.2% | 31.2% | 5.3 | 28.0 | 39.7 | 116.1 | FlatZip | 189768092390 | 190261468327 | 0 | 18263:8000001C800000018001482C80000001 | 190257955511 | 1 | 18263:800000A88000000A800386A580000008 | 190211207843 | 1 | 2024-08-20 08:31:32 |
|---|
|
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 |
|---|
| 14650677 | 189974433765 | 190257953780 | 0.040562 | 0.040562 | 18263:8000001C8000000180013DFE80000001 | 190242499221 | 1 | 18263:8000001C800000098001668880000005 | 190244787766 | 1 | 929204 | 0 | 0.026018 | 0.108200 | 0 | | 14650678 | 190136504384 | 190257954573 | 0.040520 | 0.040520 | 18263:8000001C800000098001668880000006 | 190244787767 | 1 | 18263:800000228000000780012B8F80000002 | 190224087692 | 1 | 929415 | 0 | 0.026024 | 0.108194 | 0 | | 14650679 | 190191848173 | 190240743761 | 0.006019 | 0.006019 | 18263:800000228000000780012B8F80000003 | 190224087693 | 1 | 18263:800000228000000880011DC680000009 | 190202932265 | 1 | 131833 | 0 | 0.003691 | 0.015210 | 0 | | 14650693 | 190191848185 | 190261468172 | 0.020762 | 0.020762 | 18263:800000228000000880011DC68000000A | 190202932266 | 1 | 18263:800000228000000A8001602680000008 | 190244003125 | 1 | 476144 | 0 | 0.013332 | 0.055243 | 0 | | 14638277 | 189689290795 | 189793092486 | 0.040063 | 0.040063 | 18263:8000003C800000038003031080000005 | 189788892406 | 1 | 18263:800000468000000480009B1480000004 | 189768092389 | 1 | 877414 | 0 | 0.024568 | 0.101803 | 0 | | 14644660 | 189747081125 | 190090936836 | 0.040415 | 0.040415 | 18263:800000468000000480009C5B80000002 | 189769778009 | 1 | 18263:800000A3800000018000D90F80000009 | 190090936836 | 1 | 926700 | 0 | 0.025948 | 0.108270 | 0 | | 14649844 | 190172760252 | 190242494497 | 0.012532 | 0.012532 | 18263:800000A38000000480014E8580000006 | 190215498196 | 1 | 18263:800000A380000006800138788000000B | 190234343820 | 1 | 283779 | 0 | 0.007946 | 0.032879 | 0 | | 14650364 | 190128184507 | 190252856699 | 0.039882 | 0.039882 | 18263:800000A38000000680013FC680000002 | 190245291733 | 1 | 18263:800000A8800000018003E4898000000B | 190199505980 | 1 | 930404 | 0 | 0.026051 | 0.108167 | 0 | | 14650365 | 190128193333 | 190252854832 | 0.010227 | 0.010227 | 18263:800000A8800000018003E4898000000C | 190199505981 | 1 | 18263:800000A8800000038003866F8000000B | 190210766001 | 1 | 225224 | 0 | 0.006306 | 0.026056 | 0 | | 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 |
|
| 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 | 190263225197 |
| last_allocated_sequence | 190263225197 |
| last_published_sequence | 189793095786 |
| next_file_number | 14650737 |
| min_log_number_to_keep | 14650694 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 9675 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.954073 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 189768092390 |
| earliest_write_conflict_snapshot | 190263224663 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18263:8000001C800000018001482C80000001 |
| largest_user_key | 18263:800000B98000000280014B8F80000009 |
| existing_snapshots |
190263224663 |
|---|
| 190263225132 |
| 190263225186 |
| 190263225197 |
| extra_serde_files | |
| shutting_down | |
|
|---|