| overview |
| job_id | 49835 |
| 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-49835/att-00 |
|
|---|
| inputs |
all levels summary: version# 25289, file count = 5, total size = 0.109 GB, avg size = 0.022 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.031258 | 233231 | 0 | 0 | 0 | 1 | 0.005858 | 0.025176 | 18.9% | 0.006082 | 0.025176 | 19.5% | 96.3% | 100.0% | 99.3% | 27.0 | 28.0 | 115.9 | 115.9 | SngFast | 191044410498 | 191048024781 | 0 | 18263:8000001C8000000180032AAC80000001 | 191044413268 | 1 | 18263:800000A38000000280032D9A80000004 | 191044742861 | 1 | 2024-08-20 21:03:46 | 29.999 MiB | 32.008 MiB |
|---|
| L2 | 4 | 4 | 0.078425 | 0.250000 | 1863850 | 0 | 0 | 0 | 4 | 0.009218 | 0.067166 | 12.1% | 0.048604 | 0.201397 | 19.4% | 19.0% | 33.3% | 30.6% | 5.3 | 28.0 | 38.7 | 116.0 | FlatZip | 190586022308 | 191048023105 | 0 | 18263:8000001C800000018003109480000001 | 190999605218 | 1 | 18263:800000A38000000380032DE580000001 | 191045235266 | 1 | 2024-08-20 21:00:03 | 18.041 MiB | 64.000 MiB |
|---|
| sum | 5 | 5 | 0.109459 | 0.281258 | 2097081 | 0 | 0 | 0 | 5 | 0.015076 | 0.092342 | 14.0% | 0.054686 | 0.226573 | 19.4% | 27.6% | 40.8% | 38.2% | 7.7 | 28.0 | 47.3 | 116.0 | FlatZip=4
SngFast=1 | 190586022308 | 191048024781 | 0 | 18263:8000001C800000018003109480000001 | 190999605218 | 1 | 18263:800000A38000000380032DE580000001 | 191045235266 | 1 | 2024-08-20 21:00:03 | 20.432 MiB | 57.602 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 |
|---|
| 14686576 | 🟢 | 0.031035 | 0.031258 | 233231 | 0 | 0 | 0 | 1 | 0.005858 | 0.025176 | 18.9% | 0.006082 | 0.025176 | 19.5% | 96.3% | 100.0% | 99.3% | 27.0 | 28.0 | 115.9 | 115.9 | SngFast | 191044410498 | 191048024781 | 7 | 18263:8000001C8000000180032AAC80000001 | 191044413268 | 1 | 18263:800000A38000000280032D9A80000004 | 191044742861 | 1 | 2024-08-20 21:03:46 |
|---|
level = 2, file count = 4, total zip = 0.078 GB, raw = 0.250 GB, over prev level: zip = 2.527001, raw = 7.997928
| 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 |
|---|
| 14686520 | 🟢 | 0.019068 | 0.062500 | 466410 | 0 | 0 | 0 | 1 | 0.002293 | 0.016266 | 12.4% | 0.012163 | 0.050338 | 19.5% | 18.9% | 32.3% | 29.7% | 5.3 | 28.0 | 37.4 | 115.9 | FlatZip | 190948641548 | 191044409069 | 11 | 18263:8000001C800000018003109480000001 | 190999605218 | 1 | 18263:8000001C800000048002F9D88000000C | 190961185488 | 1 | 2024-08-20 21:00:03 |
|---|
| 14686521 | 🟢 | 0.019973 | 0.062500 | 465193 | 0 | 0 | 0 | 1 | 0.002287 | 0.017174 | 11.8% | 0.012131 | 0.050369 | 19.4% | 18.9% | 34.1% | 31.1% | 5.3 | 28.0 | 39.6 | 116.3 | FlatZip | 190961188540 | 191044409801 | 7 | 18263:8000001C800000048002F9D980000001 | 190961188540 | 1 | 18263:800000228000000280030F968000000B | 191018549717 | 1 | 2024-08-20 21:00:06 |
|---|
| 14686522 | 🟢 | 0.019442 | 0.062500 | 466196 | 0 | 0 | 0 | 1 | 0.002238 | 0.016695 | 11.8% | 0.012157 | 0.050343 | 19.5% | 18.4% | 33.2% | 30.3% | 5.2 | 28.0 | 38.5 | 115.9 | FlatZip | 190996030857 | 191044409601 | 11 | 18263:800000228000000280030F968000000C | 191018549718 | 1 | 18263:80000022800000068003124180000008 | 191023168591 | 1 | 2024-08-20 21:00:11 |
|---|
| 14686656 | 🟢 | 0.019941 | 0.062500 | 466051 | 0 | 0 | 0 | 1 | 0.002400 | 0.017030 | 12.4% | 0.012153 | 0.050347 | 19.4% | 19.7% | 33.8% | 31.1% | 5.5 | 28.0 | 39.2 | 116.0 | FlatZip | 190586022308 | 191048023105 | 7 | 18263:80000022800000068003124180000009 | 191023168592 | 1 | 18263:800000A38000000380032DE580000001 | 191045235266 | 1 | 2024-08-20 21:03:56 |
|---|
| sum | 4 | 0.078425 | 0.250000 | 1863850 | 0 | 0 | 0 | 4 | 0.009218 | 0.067166 | 12.1% | 0.048604 | 0.201397 | 19.4% | 19.0% | 33.3% | 30.6% | 5.3 | 28.0 | 38.7 | 116.0 | FlatZip | 190586022308 | 191048023105 | 0 | 18263:8000001C800000018003109480000001 | 190999605218 | 1 | 18263:800000A38000000380032DE580000001 | 191045235266 | 1 | 2024-08-20 21:00:03 |
|---|
|
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 | | 14686410 | 190820937865 | 191040786347 | 0.038674 | 0.038674 | 18263:8000001C800000048002B13C80000007 | 190838730778 | 1 | 18263:8000001C8000000680030A2380000006 | 190988807654 | 1 | 928541 | 0 | 0.025999 | 0.108219 | 0 | | 14686411 | 190807976460 | 191040783565 | 0.016481 | 0.016481 | 18263:8000001C8000000680030A2380000007 | 190988807655 | 1 | 18263:8000001C800000078002C2B180000003 | 190868390819 | 1 | 384476 | 0 | 0.010765 | 0.044509 | 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 | | 14686406 | 190807978479 | 191040787876 | 0.036610 | 0.036610 | 18263:80000022800000078002F41580000009 | 190971261232 | 1 | 18263:80000022800000098002977180000007 | 190813496042 | 1 | 934135 | 0 | 0.026156 | 0.108062 | 0 | | 14686407 | 190813496043 | 191040787904 | 0.026176 | 0.026176 | 18263:80000022800000098002977180000008 | 190813496043 | 1 | 18263:800000228000000A800354D080000003 | 190981280851 | 1 | 625106 | 0 | 0.017503 | 0.072654 | 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 | | 14686259 | 190839941506 | 191037266759 | 0.038300 | 0.038300 | 18263:800000A380000003800319F980000006 | 191011200546 | 1 | 18263:800000A3800000058003347480000006 | 190910333241 | 1 | 931275 | 0 | 0.026076 | 0.108142 | 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 | 191048390355 |
| last_allocated_sequence | 191048390355 |
| last_published_sequence | 189793095786 |
| next_file_number | 14686661 |
| min_log_number_to_keep | 14686563 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 25287 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.991885 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 190586022308 |
| earliest_write_conflict_snapshot | 191048389991 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18263:8000001C800000018003109480000001 |
| largest_user_key | 18263:800000A38000000380032DE580000001 |
| existing_snapshots |
191048389991 |
|---|
| 191048390152 |
| 191048390244 |
| 191048390255 |
| 191048390297 |
| 191048390318 |
| 191048390329 |
| 191048390355 |
| extra_serde_files | |
| shutting_down | |
|
|---|