| overview |
| job_id | 26708 |
| num_levels | 7 |
| output_level | 3 |
| target_file_size | 128.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-26708/att-00 |
|
|---|
| inputs |
all levels summary: version# 14081, file count = 5, total size = 0.338 GB, avg size = 0.068 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 |
|---|
| L2 | 1 | 1 | 0.016001 | 0.014865 | 79808 | 0 | 0 | 0 | 1 | 0.002324 | 0.013676 | 14.5% | 0.001189 | 0.013676 | 8.0% | 195.4% | 100.0% | 107.6% | 31.3 | 16.0 | 184.0 | 184.0 | SngFast | 147844961625 | 147846740871 | 0 | 18206:8000007B | 147846037289 | 1 | 18206:81312AF7 | 147846172278 | 1 | 2024-07-09 02:27:36 | 15.775 MiB | 15.222 MiB |
|---|
| L3 | 4 | 4 | 0.322296 | 0.450516 | 2418692 | 0 | 0 | 0 | 4 | 0.010936 | 0.307180 | 3.4% | 0.036041 | 0.414475 | 8.0% | 30.3% | 74.1% | 70.6% | 4.9 | 16.0 | 136.4 | 184.0 | FlatZip | 147286243297 | 147844961080 | 0 | 18206:80000002 | 147827128545 | 1 | 18206:81312CEB | 147788479797 | 1 | 2024-07-09 02:25:35 | 79.383 MiB | 115.332 MiB |
|---|
| sum | 5 | 5 | 0.338297 | 0.465382 | 2498500 | 0 | 0 | 0 | 5 | 0.013259 | 0.320856 | 4.0% | 0.037231 | 0.428151 | 8.0% | 35.6% | 74.9% | 71.8% | 5.7 | 16.0 | 137.9 | 184.0 | FlatZip=4
SngFast=1 | 147286243297 | 147846740871 | 0 | 18206:80000002 | 147827128545 | 1 | 18206:81312CEB | 147788479797 | 1 | 2024-07-09 02:25:35 | 66.662 MiB | 95.310 MiB |
|---|
level = 2, file count = 1, total zip = 0.016 GB, raw = 0.015 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 |
|---|
| 12656059 | 🟢 | 0.016001 | 0.014865 | 79808 | 0 | 0 | 0 | 1 | 0.002324 | 0.013676 | 14.5% | 0.001189 | 0.013676 | 8.0% | 195.4% | 100.0% | 107.6% | 31.3 | 16.0 | 184.0 | 184.0 | SngFast | 147844961625 | 147846740871 | 4 | 18206:8000007B | 147846037289 | 1 | 18206:81312AF7 | 147846172278 | 1 | 2024-07-09 02:27:36 |
|---|
level = 3, file count = 4, total zip = 0.322 GB, raw = 0.451 GB, over prev level: zip = 20.142608, raw = 30.306385
| 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 |
|---|
| 12655997 | 🟢 | 0.089112 | 0.125000 | 671089 | 0 | 0 | 0 | 1 | 0.003218 | 0.084737 | 3.7% | 0.010000 | 0.115000 | 8.0% | 32.2% | 73.7% | 70.4% | 5.1 | 16.0 | 135.6 | 184.0 | FlatZip | 147286243297 | 147844961080 | 5 | 18206:80000002 | 147827128545 | 1 | 18206:805B9CF5 | 147840123292 | 1 | 2024-07-09 02:25:35 |
|---|
| 12655998 | 🟢 | 0.088819 | 0.125000 | 671089 | 0 | 0 | 0 | 1 | 0.002928 | 0.084733 | 3.3% | 0.010000 | 0.115000 | 8.0% | 29.3% | 73.7% | 70.1% | 4.7 | 16.0 | 135.6 | 184.0 | FlatZip | 147555028752 | 147844961076 | 5 | 18206:805B9CF6 | 147835827918 | 1 | 18206:80A10F80 | 147705573201 | 1 | 2024-07-09 02:25:42 |
|---|
| 12655999 | 🟢 | 0.088990 | 0.125000 | 671089 | 0 | 0 | 0 | 1 | 0.003089 | 0.084743 | 3.5% | 0.010000 | 0.115000 | 8.0% | 30.9% | 73.7% | 70.3% | 4.9 | 16.0 | 135.6 | 184.0 | FlatZip | 147605817499 | 147844961079 | 5 | 18206:80A10F81 | 147714540119 | 1 | 18206:80FF9ACB | 147800030169 | 1 | 2024-07-09 02:25:45 |
|---|
| 12656000 | 🟢 | 0.055375 | 0.075516 | 405425 | 0 | 0 | 0 | 1 | 0.001700 | 0.052967 | 3.1% | 0.006041 | 0.069475 | 8.0% | 28.1% | 76.2% | 72.4% | 4.5 | 16.0 | 140.3 | 184.0 | FlatZip | 147785669858 | 147844961078 | 4 | 18206:80FF9AD0 | 147794420564 | 1 | 18206:81312CEB | 147788479797 | 1 | 2024-07-09 02:25:49 |
|---|
| sum | 4 | 0.322296 | 0.450516 | 2418692 | 0 | 0 | 0 | 4 | 0.010936 | 0.307180 | 3.4% | 0.036041 | 0.414475 | 8.0% | 30.3% | 74.1% | 70.6% | 4.9 | 16.0 | 136.4 | 184.0 | FlatZip | 147286243297 | 147844961080 | 0 | 18206:80000002 | 147827128545 | 1 | 18206:81312CEB | 147788479797 | 1 | 2024-07-09 02:25:35 |
|---|
|
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 |
|---|
| 12654898 | 147192754894 | 147818904659 | 0.180737 | 0.180737 | 18206:80000001 | 147514661047 | 1 | 18206:801C13C1 | 147707548134 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 12654899 | 147192755731 | 147818904405 | 0.180721 | 0.180721 | 18206:801C13C2 | 147521353050 | 1 | 18206:803830F7 | 147458090130 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 12654900 | 147192763476 | 147818903300 | 0.033097 | 0.033097 | 18206:803830F8 | 147673042430 | 1 | 18206:803D4132 | 147219985619 | 1 | 216629 | 0 | 0.003466 | 0.039860 | 0 | | 12653690 | 147192754802 | 147794416519 | 0.180760 | 0.180760 | 18206:803D4144 | 147265490940 | 1 | 18206:805CBB8A | 147586368852 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 12653691 | 147192765193 | 147680484398 | 0.022886 | 0.022886 | 18206:805CBB8C | 147425003347 | 1 | 18206:805FAE23 | 147626467611 | 1 | 121809 | 0 | 0.001949 | 0.022413 | 0 | | 12655446 | 147192754892 | 147830933486 | 0.180716 | 0.180716 | 18206:805FAE24 | 147581073202 | 1 | 18206:807C3EE7 | 147218845168 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 12655447 | 147192754906 | 147830934330 | 0.177048 | 0.177048 | 18206:807C3EE9 | 147556028941 | 1 | 18206:8098F185 | 147486963842 | 1 | 1312923 | 0 | 0.021007 | 0.241578 | 0 | | 12654302 | 147192754986 | 147804897972 | 0.180753 | 0.180753 | 18206:8098F186 | 147591224967 | 1 | 18206:80B82144 | 147492069548 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 12654303 | 147192757392 | 147804898142 | 0.180736 | 0.180736 | 18206:80B82145 | 147324804042 | 1 | 18206:80D490DF | 147202193322 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 12654385 | 147192756343 | 147804898141 | 0.180722 | 0.180722 | 18206:80D490E0 | 147288119295 | 1 | 18206:80F105DD | 147598801065 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 12654386 | 147192754808 | 147804898008 | 0.121567 | 0.121567 | 18206:80F105E0 | 147382135377 | 1 | 18206:8103C71E | 147414450269 | 1 | 875897 | 0 | 0.014014 | 0.161165 | 0 | | 12654204 | 147192754915 | 147785668639 | 0.180722 | 0.180722 | 18206:8103C71F | 147530597755 | 1 | 18206:8120B102 | 147570067062 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 12654301 | 147192757327 | 147785668636 | 0.107167 | 0.107167 | 18206:8120B103 | 147696776612 | 1 | 18206:81312D00 | 147704062980 | 1 | 764632 | 0 | 0.012234 | 0.140692 | 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 | 147846923686 |
| last_allocated_sequence | 147846923686 |
| last_published_sequence | 147176466927 |
| next_file_number | 12656095 |
| min_log_number_to_keep | 12656011 |
| manifest_file_number | 12625661 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 14079 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.956556 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 147286243297 |
| earliest_write_conflict_snapshot | 147846923072 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18206:80000002 |
| largest_user_key | 18206:81312CEB |
| existing_snapshots |
147846923072 |
|---|
| 147846923397 |
| 147846923434 |
| 147846923456 |
| 147846923613 |
| 147846923653 |
| 147846923675 |
| 147846923686 |
| extra_serde_files | |
| shutting_down | |
|
|---|