| overview |
| job_id | 55736 |
| 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-55736/att-00 |
|
|---|
| inputs |
all levels summary: version# 28163, file count = 6, total size = 0.128 GB, avg size = 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 | 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.031285 | 233397 | 0 | 0 | 0 | 1 | 0.005835 | 0.025199 | 18.8% | 0.006086 | 0.025199 | 19.5% | 95.9% | 100.0% | 99.2% | 26.8 | 28.0 | 115.9 | 115.9 | SngFast | 191188426549 | 191192053997 | 0 | 18263:8000001C8000000180037DE780000001 | 191188432848 | 1 | 18263:800000A3800000018003EB4080000002 | 191191161505 | 1 | 2024-08-20 23:40:56 | 29.998 MiB | 32.036 MiB |
|---|
| L2 | 5 | 5 | 0.096772 | 0.312500 | 2333491 | 0 | 0 | 0 | 5 | 0.011641 | 0.082585 | 12.4% | 0.060851 | 0.251650 | 19.5% | 19.1% | 32.8% | 30.2% | 5.4 | 28.0 | 38.0 | 115.8 | FlatZip | 190586022308 | 191188426313 | 0 | 18263:8000001C80000001800375AB80000001 | 191174093806 | 1 | 18263:800000A3800000038003DB5A80000001 | 191175282584 | 1 | 2024-08-20 23:36:56 | 17.762 MiB | 64.000 MiB |
|---|
| sum | 6 | 6 | 0.127807 | 0.343785 | 2566888 | 0 | 0 | 0 | 6 | 0.017476 | 0.107784 | 14.0% | 0.066937 | 0.276848 | 19.5% | 26.1% | 38.9% | 36.4% | 7.3 | 28.0 | 45.1 | 115.8 | FlatZip=5
SngFast=1 | 190586022308 | 191192053997 | 0 | 18263:8000001C80000001800375AB80000001 | 191174093806 | 1 | 18263:800000A3800000038003DB5A80000001 | 191175282584 | 1 | 2024-08-20 23:36:56 | 19.801 MiB | 58.673 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 |
|---|
| 14693376 | 🟢 | 0.031035 | 0.031285 | 233397 | 0 | 0 | 0 | 1 | 0.005835 | 0.025199 | 18.8% | 0.006086 | 0.025199 | 19.5% | 95.9% | 100.0% | 99.2% | 26.8 | 28.0 | 115.9 | 115.9 | SngFast | 191188426549 | 191192053997 | 7 | 18263:8000001C8000000180037DE780000001 | 191188432848 | 1 | 18263:800000A3800000018003EB4080000002 | 191191161505 | 1 | 2024-08-20 23:40:56 |
|---|
level = 2, file count = 5, total zip = 0.097 GB, raw = 0.313 GB, over prev level: zip = 3.118219, raw = 9.988844
| 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 |
|---|
| 14693321 | 🟢 | 0.019217 | 0.062500 | 467513 | 0 | 0 | 0 | 1 | 0.002298 | 0.016411 | 12.3% | 0.012191 | 0.050309 | 19.5% | 18.9% | 32.6% | 29.9% | 5.3 | 28.0 | 37.7 | 115.5 | FlatZip | 191073220730 | 191188426313 | 11 | 18263:8000001C80000001800375AB80000001 | 191174093806 | 1 | 18263:8000001C80000006800367AD8000000D | 191149567597 | 1 | 2024-08-20 23:36:56 |
|---|
| 14693322 | 🟢 | 0.019531 | 0.062500 | 467126 | 0 | 0 | 0 | 1 | 0.002291 | 0.016729 | 12.0% | 0.012181 | 0.050319 | 19.5% | 18.8% | 33.2% | 30.4% | 5.3 | 28.0 | 38.5 | 115.7 | FlatZip | 191109334151 | 191188425716 | 7 | 18263:8000001C80000006800367AD8000000E | 191149567598 | 1 | 18263:8000002280000002800362E180000005 | 191163124804 | 1 | 2024-08-20 23:36:59 |
|---|
| 14693323 | 🟢 | 0.019442 | 0.062500 | 466525 | 0 | 0 | 0 | 1 | 0.002294 | 0.016640 | 12.1% | 0.012166 | 0.050335 | 19.5% | 18.9% | 33.1% | 30.3% | 5.3 | 28.0 | 38.3 | 115.8 | FlatZip | 191094902528 | 191188424426 | 11 | 18263:8000002280000002800362E180000006 | 191163124805 | 1 | 18263:80000022800000068003CB4080000005 | 191160892037 | 1 | 2024-08-20 23:37:04 |
|---|
| 14693324 | 🟢 | 0.019328 | 0.062500 | 467819 | 0 | 0 | 0 | 1 | 0.002306 | 0.016514 | 12.3% | 0.012199 | 0.050301 | 19.5% | 18.9% | 32.8% | 30.1% | 5.3 | 28.0 | 37.9 | 115.5 | FlatZip | 191110428019 | 191188423437 | 11 | 18263:80000022800000068003CB4180000001 | 191160893536 | 1 | 18263:800000228000000A8003D40080000007 | 191179467895 | 1 | 2024-08-20 23:37:07 |
|---|
| 14693346 | 🟢 | 0.019255 | 0.062500 | 464508 | 0 | 0 | 0 | 1 | 0.002451 | 0.016291 | 13.1% | 0.012113 | 0.050387 | 19.4% | 20.2% | 32.3% | 30.0% | 5.7 | 28.0 | 37.7 | 116.5 | FlatZip | 190586022308 | 191188423519 | 7 | 18263:800000228000000A8003D40080000008 | 191179467896 | 1 | 18263:800000A3800000038003DB5A80000001 | 191175282584 | 1 | 2024-08-20 23:37:32 |
|---|
| sum | 5 | 0.096772 | 0.312500 | 2333491 | 0 | 0 | 0 | 5 | 0.011641 | 0.082585 | 12.4% | 0.060851 | 0.251650 | 19.5% | 19.1% | 32.8% | 30.2% | 5.4 | 28.0 | 38.0 | 115.8 | FlatZip | 190586022308 | 191188426313 | 0 | 18263:8000001C80000001800375AB80000001 | 191174093806 | 1 | 18263:800000A3800000038003DB5A80000001 | 191175282584 | 1 | 2024-08-20 23:36:56 |
|---|
|
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 |
|---|
| 14692640 | 190872519132 | 191174087077 | 0.037661 | 0.037661 | 18263:8000001C8000000180032CAF80000001 | 191048039625 | 1 | 18263:8000001C800000038002E0BC8000000C | 190919139841 | 1 | 932657 | 0 | 0.026114 | 0.108103 | 0 | | 14692641 | 190919139842 | 191174086818 | 0.023075 | 0.023075 | 18263:8000001C800000038002E0BC8000000D | 190919139842 | 1 | 18263:8000001C80000005800386E480000001 | 191043753238 | 1 | 516236 | 0 | 0.014455 | 0.060323 | 0 | | 14690381 | 190807976460 | 191130735420 | 0.037952 | 0.037952 | 18263:8000001C80000005800386E480000002 | 191043753239 | 1 | 18263:8000001C80000007800346AE80000001 | 191092640031 | 1 | 928506 | 0 | 0.025998 | 0.108220 | 0 | | 14692927 | 190929460633 | 191179510948 | 0.018010 | 0.018010 | 18263:8000001C800000088003B76480000002 | 191115782862 | 1 | 18263:8000001C800000098003778280000004 | 191177278222 | 1 | 410289 | 0 | 0.011488 | 0.047991 | 0 | | 14691994 | 190676718735 | 191161464186 | 0.039022 | 0.039022 | 18263:8000001C800000098003B92A80000004 | 191117116571 | 1 | 18263:8000002280000002800376038000000A | 191031363529 | 1 | 932505 | 0 | 0.026110 | 0.108108 | 0 | | 14691995 | 190893160985 | 191161464374 | 0.019067 | 0.019067 | 18263:8000002280000002800376038000000B | 191031363530 | 1 | 18263:800000228000000480035C9C80000002 | 191152275543 | 1 | 439017 | 0 | 0.012292 | 0.050661 | 0 | | 14691879 | 190605554351 | 191159656237 | 0.037792 | 0.037792 | 18263:800000228000000480035D3B80000003 | 191000800739 | 1 | 18263:800000228000000780035E3780000007 | 191155092901 | 1 | 931963 | 0 | 0.026095 | 0.108123 | 0 | | 14691880 | 190807978498 | 191159655713 | 0.038634 | 0.038634 | 18263:800000228000000780035E3880000001 | 191155097223 | 1 | 18263:800000228000000A8003A46380000008 | 191104927950 | 1 | 930741 | 0 | 0.026061 | 0.108157 | 0 | | 14691881 | 191104934854 | 191110418084 | 0.000553 | 0.000553 | 18263:800000228000000A8003A46480000001 | 191104934854 | 1 | 18263:800000228000000A8003A84D80000005 | 191110418084 | 1 | 9809 | 0 | 0.000275 | 0.001118 | 0 | | 14667818 | 189689290795 | 189988793070 | 0.042950 | 0.042950 | 18263:8000003C8000000380033DF380000001 | 189729517843 | 1 | 18263:800000A380000001800092B480000001 | 189988793070 | 1 | 930957 | 0 | 0.026067 | 0.108151 | 0 | | 14689911 | 190754444246 | 191119910428 | 0.037355 | 0.037355 | 18263:800000A3800000018002805280000008 | 190754444246 | 1 | 18263:800000A3800000028003562D8000000A | 191113602275 | 1 | 926200 | 0 | 0.025934 | 0.108284 | 0 | | 14692534 | 190934680928 | 191168664270 | 0.037186 | 0.037186 | 18263:800000A3800000028003562D8000000B | 191113602276 | 1 | 18263:800000A3800000048003464180000006 | 191086834408 | 1 | 934024 | 0 | 0.026153 | 0.108065 | 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 | 191192143397 |
| last_allocated_sequence | 191192143397 |
| last_published_sequence | 189793095786 |
| next_file_number | 14693418 |
| min_log_number_to_keep | 14693362 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 28161 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.994578 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 190586022308 |
| earliest_write_conflict_snapshot | 191192142379 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18263:8000001C80000001800375AB80000001 |
| largest_user_key | 18263:800000A3800000038003DB5A80000001 |
| existing_snapshots |
191192142379 |
|---|
| 191192142406 |
| 191192143069 |
| 191192143297 |
| 191192143308 |
| 191192143371 |
| 191192143397 |
| extra_serde_files | |
| shutting_down | |
|
|---|