| overview |
| job_id | 49576 |
| 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-49576/att-00 |
|
|---|
| inputs |
all levels summary: version# 25161, file count = 6, total size = 0.126 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.031220 | 232982 | 0 | 0 | 0 | 1 | 0.005890 | 0.025144 | 19.0% | 0.006075 | 0.025144 | 19.5% | 96.9% | 100.0% | 99.4% | 27.1 | 28.0 | 115.9 | 115.9 | SngFast | 191037268760 | 191040787904 | 0 | 18263:8000001C800000018003269880000001 | 191037271577 | 1 | 18263:800000A3800000028003299580000007 | 191037987527 | 1 | 2024-08-20 20:55:59 | 30.001 MiB | 31.969 MiB |
|---|
| L2 | 5 | 5 | 0.094986 | 0.306098 | 2283182 | 0 | 0 | 0 | 5 | 0.011225 | 0.081258 | 12.1% | 0.059539 | 0.246560 | 19.5% | 18.9% | 33.0% | 30.2% | 5.3 | 28.0 | 38.2 | 116.0 | FlatZip | 190586022308 | 191037268436 | 0 | 18263:8000001C800000018003109480000001 | 190999605218 | 1 | 18263:800000A38000000180031CF680000003 | 191016259999 | 1 | 2024-08-20 20:52:20 | 17.473 MiB | 62.689 MiB |
|---|
| sum | 6 | 6 | 0.126021 | 0.337318 | 2516164 | 0 | 0 | 0 | 6 | 0.017115 | 0.106403 | 13.9% | 0.065614 | 0.271704 | 19.5% | 26.1% | 39.2% | 36.6% | 7.3 | 28.0 | 45.4 | 115.9 | FlatZip=5
SngFast=1 | 190586022308 | 191040787904 | 0 | 18263:8000001C800000018003109480000001 | 190999605218 | 1 | 18263:800000A3800000028003299580000007 | 191037987527 | 1 | 2024-08-20 20:52:20 | 19.561 MiB | 57.569 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 |
|---|
| 14686322 | 🟢 | 0.031035 | 0.031220 | 232982 | 0 | 0 | 0 | 1 | 0.005890 | 0.025144 | 19.0% | 0.006075 | 0.025144 | 19.5% | 96.9% | 100.0% | 99.4% | 27.1 | 28.0 | 115.9 | 115.9 | SngFast | 191037268760 | 191040787904 | 7 | 18263:8000001C800000018003269880000001 | 191037271577 | 1 | 18263:800000A3800000028003299580000007 | 191037987527 | 1 | 2024-08-20 20:55:59 |
|---|
level = 2, file count = 5, total zip = 0.095 GB, raw = 0.306 GB, over prev level: zip = 3.060624, raw = 9.804685
| 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 |
|---|
| 14686223 | 🟢 | 0.019394 | 0.062500 | 465417 | 0 | 0 | 0 | 1 | 0.002288 | 0.016596 | 12.1% | 0.012137 | 0.050363 | 19.4% | 18.9% | 33.0% | 30.2% | 5.3 | 28.0 | 38.3 | 116.2 | FlatZip | 190948641548 | 191037268321 | 11 | 18263:8000001C800000018003109480000001 | 190999605218 | 1 | 18263:8000001C800000048003206980000003 | 191026523296 | 1 | 2024-08-20 20:52:20 |
|---|
| 14686224 | 🟢 | 0.019053 | 0.062500 | 466785 | 0 | 0 | 0 | 1 | 0.002241 | 0.016304 | 12.1% | 0.012172 | 0.050328 | 19.5% | 18.4% | 32.4% | 29.7% | 5.2 | 28.0 | 37.5 | 115.8 | FlatZip | 190985278692 | 191037266826 | 11 | 18263:8000001C800000048003206980000004 | 191026523297 | 1 | 18263:8000001C800000078003157A80000003 | 191008067822 | 1 | 2024-08-20 20:52:22 |
|---|
| 14686277 | 🟢 | 0.019890 | 0.062500 | 465495 | 0 | 0 | 0 | 1 | 0.002289 | 0.017090 | 11.8% | 0.012139 | 0.050361 | 19.4% | 18.9% | 33.9% | 31.0% | 5.3 | 28.0 | 39.4 | 116.2 | FlatZip | 190967650537 | 191037268120 | 7 | 18263:8000001C80000009800379F680000007 | 191020734125 | 1 | 18263:80000022800000058003121380000007 | 191022861627 | 1 | 2024-08-20 20:52:48 |
|---|
| 14686278 | 🟢 | 0.019210 | 0.062500 | 466866 | 0 | 0 | 0 | 1 | 0.002246 | 0.016455 | 12.0% | 0.012174 | 0.050326 | 19.5% | 18.5% | 32.7% | 29.9% | 5.2 | 28.0 | 37.8 | 115.7 | FlatZip | 190996030857 | 191037267118 | 11 | 18263:80000022800000058003121380000008 | 191022861628 | 1 | 18263:8000002280000008800371938000000D | 191028965437 | 1 | 2024-08-20 20:52:50 |
|---|
| 14686279 | 🟢 | 0.017439 | 0.056098 | 418619 | 0 | 0 | 0 | 1 | 0.002161 | 0.014815 | 12.7% | 0.010916 | 0.045182 | 19.5% | 19.8% | 32.8% | 30.3% | 5.5 | 28.0 | 38.0 | 115.9 | FlatZip | 190586022308 | 191037268436 | 7 | 18263:8000002280000008800371938000000E | 191028965438 | 1 | 18263:800000A38000000180031CF680000003 | 191016259999 | 1 | 2024-08-20 20:52:53 |
|---|
| sum | 5 | 0.094986 | 0.306098 | 2283182 | 0 | 0 | 0 | 5 | 0.011225 | 0.081258 | 12.1% | 0.059539 | 0.246560 | 19.5% | 18.9% | 33.0% | 30.2% | 5.3 | 28.0 | 38.2 | 116.0 | FlatZip | 190586022308 | 191037268436 | 0 | 18263:8000001C800000018003109480000001 | 190999605218 | 1 | 18263:800000A38000000180031CF680000003 | 191016259999 | 1 | 2024-08-20 20:52:20 |
|---|
|
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 |
|---|
| 14684667 | 190872505073 | 190999595920 | 0.037801 | 0.037801 | 18263:8000001C800000018002C51680000001 | 190872519105 | 1 | 18263:8000001C800000038002F16880000007 | 190946922282 | 1 | 931090 | 0 | 0.026071 | 0.108147 | 0 | | 14684668 | 190767217982 | 190999586926 | 0.017320 | 0.017320 | 18263:8000001C800000038002F16980000001 | 190946930391 | 1 | 18263:8000001C800000048002B13C80000006 | 190838730777 | 1 | 404142 | 0 | 0.011316 | 0.046833 | 0 | | 14684480 | 190807976460 | 190985277625 | 0.038650 | 0.038650 | 18263:8000001C800000048002B13C80000007 | 190838730778 | 1 | 18263:8000001C800000078002C2B180000003 | 190868390819 | 1 | 929982 | 0 | 0.026039 | 0.108178 | 0 | | 14686246 | 190868390820 | 191037267464 | 0.038252 | 0.038252 | 18263:8000001C800000078002C2B180000004 | 190868390820 | 1 | 18263:8000001C80000009800331128000000E | 190909094006 | 1 | 930474 | 0 | 0.026053 | 0.108165 | 0 | | 14686247 | 190802648776 | 191020734124 | 0.016270 | 0.016270 | 18263:8000001C80000009800331128000000F | 190909094007 | 1 | 18263:8000001C8000000A8002E2FD80000005 | 190922799985 | 1 | 370397 | 0 | 0.010371 | 0.042961 | 0 | | 14685403 | 190676718735 | 191017477778 | 0.038263 | 0.038263 | 18263:8000001C8000000A8002E2FD80000006 | 190922799986 | 1 | 18263:8000002280000002800331CE80000001 | 190925672569 | 1 | 932494 | 0 | 0.026110 | 0.108108 | 0 | | 14685404 | 190605554351 | 191017477232 | 0.039624 | 0.039624 | 18263:8000002280000002800331CE80000002 | 190925672570 | 1 | 18263:80000022800000068002F04980000009 | 190964909776 | 1 | 934134 | 0 | 0.026156 | 0.108062 | 0 | | 14685405 | 190881064641 | 190996029811 | 0.016371 | 0.016371 | 18263:80000022800000068002F0498000000A | 190964909777 | 1 | 18263:80000022800000078002F41580000008 | 190971261231 | 1 | 375739 | 0 | 0.010521 | 0.043562 | 0 | | 14684531 | 190807978479 | 190996026989 | 0.015549 | 0.015549 | 18263:80000022800000078002F41580000009 | 190971261232 | 1 | 18263:80000022800000088002B99480000002 | 190871665506 | 1 | 363969 | 0 | 0.010191 | 0.042021 | 0 | | 14684491 | 190807978498 | 190996027025 | 0.032987 | 0.032987 | 18263:80000022800000088002B99480000003 | 190871665507 | 1 | 18263:800000228000000A800342A28000000C | 190953791778 | 1 | 793995 | 0 | 0.022232 | 0.092158 | 0 | | 14667818 | 189689290795 | 189988793070 | 0.042950 | 0.042950 | 18263:8000003C8000000380033DF380000001 | 189729517843 | 1 | 18263:800000A380000001800092B480000001 | 189988793070 | 1 | 930957 | 0 | 0.026067 | 0.108151 | 0 | | 14686258 | 190754444246 | 191037268413 | 0.038138 | 0.038138 | 18263:800000A3800000018002805280000008 | 190754444246 | 1 | 18263:800000A380000003800319F980000005 | 191011200545 | 1 | 930318 | 0 | 0.026049 | 0.108169 | 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 | 191040897448 |
| last_allocated_sequence | 191040897448 |
| last_published_sequence | 189793095786 |
| next_file_number | 14686355 |
| min_log_number_to_keep | 14686304 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 25159 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.983917 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 190586022308 |
| earliest_write_conflict_snapshot | 191040897062 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18263:8000001C800000018003109480000001 |
| largest_user_key | 18263:800000A3800000028003299580000007 |
| existing_snapshots |
191040897062 |
|---|
| 191040897073 |
| 191040897403 |
| 191040897422 |
| 191040897433 |
| 191040897448 |
| extra_serde_files | |
| shutting_down | |
|
|---|