| overview |
| job_id | 17971 |
| 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 | 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-17971/att-00 |
|
|---|
| inputs |
all levels summary: version# 9685, file count = 4, total size = 0.140 GB, avg size = 0.035 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.014743 | 0.013669 | 73385 | 0 | 0 | 0 | 1 | 0.002167 | 0.012576 | 14.7% | 0.001094 | 0.012575 | 8.0% | 198.1% | 100.0% | 107.9% | 31.7 | 16.0 | 184.0 | 184.0 | SngFast | 147600521134 | 147602283431 | 0 | 18197:8000001C | 147601826357 | 1 | 18197:81312A38 | 147602106021 | 1 | 2024-07-08 21:50:11 | 14.536 MiB | 13.997 MiB |
|---|
| L2 | 3 | 3 | 0.125492 | 0.165139 | 886581 | 0 | 0 | 0 | 3 | 0.005634 | 0.118293 | 4.5% | 0.013211 | 0.151927 | 8.0% | 42.6% | 77.9% | 75.0% | 6.8 | 16.0 | 143.3 | 184.0 | FlatZip | 147488785930 | 147600521084 | 0 | 18197:8000001F | 147598825248 | 1 | 18197:81312C9D | 147597346735 | 1 | 2024-07-08 21:48:18 | 41.371 MiB | 56.367 MiB |
|---|
| sum | 4 | 4 | 0.140234 | 0.178808 | 959966 | 0 | 0 | 0 | 4 | 0.007801 | 0.130869 | 5.6% | 0.014305 | 0.164503 | 8.0% | 54.5% | 79.6% | 77.6% | 8.7 | 16.0 | 146.4 | 184.0 | FlatZip=3
SngFast=1 | 147488785930 | 147602283431 | 0 | 18197:8000001C | 147601826357 | 1 | 18197:81312C9D | 147597346735 | 1 | 2024-07-08 21:48:18 | 34.662 MiB | 45.775 MiB |
|---|
level = 1, file count = 1, total zip = 0.015 GB, raw = 0.014 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 |
|---|
| 12645302 | 🟢 | 0.014743 | 0.013669 | 73385 | 0 | 0 | 0 | 1 | 0.002167 | 0.012576 | 14.7% | 0.001094 | 0.012575 | 8.0% | 198.1% | 100.0% | 107.9% | 31.7 | 16.0 | 184.0 | 184.0 | SngFast | 147600521134 | 147602283431 | 4 | 18197:8000001C | 147601826357 | 1 | 18197:81312A38 | 147602106021 | 1 | 2024-07-08 21:50:11 |
|---|
level = 2, file count = 3, total zip = 0.125 GB, raw = 0.165 GB, over prev level: zip = 8.511982, raw = 12.081229
| 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 |
|---|
| 12645262 | 🟢 | 0.047438 | 0.062500 | 335545 | 0 | 0 | 0 | 1 | 0.002442 | 0.044405 | 5.2% | 0.005000 | 0.057500 | 8.0% | 48.8% | 77.2% | 75.0% | 7.8 | 16.0 | 142.1 | 184.0 | FlatZip | 147488785930 | 147600521082 | 5 | 18197:8000001F | 147598825248 | 1 | 18197:80917568 | 147587159634 | 1 | 2024-07-08 21:48:18 |
|---|
| 12645263 | 🟢 | 0.046695 | 0.062500 | 335545 | 0 | 0 | 0 | 1 | 0.001712 | 0.044392 | 3.7% | 0.005000 | 0.057500 | 8.0% | 34.2% | 77.2% | 73.8% | 5.5 | 16.0 | 142.1 | 184.0 | FlatZip | 147565544300 | 147600521083 | 5 | 18197:80917571 | 147600137214 | 1 | 18197:80DA6BFD | 147592619649 | 1 | 2024-07-08 21:48:23 |
|---|
| 12645264 | 🟢 | 0.031359 | 0.040138 | 215491 | 0 | 0 | 0 | 1 | 0.001480 | 0.029496 | 4.8% | 0.003211 | 0.036927 | 8.0% | 46.1% | 79.9% | 77.2% | 7.4 | 16.0 | 147.0 | 184.0 | FlatZip | 147565544306 | 147600521084 | 4 | 18197:80DA6C0F | 147567288262 | 1 | 18197:81312C9D | 147597346735 | 1 | 2024-07-08 21:48:25 |
|---|
| sum | 3 | 0.125492 | 0.165139 | 886581 | 0 | 0 | 0 | 3 | 0.005634 | 0.118293 | 4.5% | 0.013211 | 0.151927 | 8.0% | 42.6% | 77.9% | 75.0% | 6.8 | 16.0 | 143.3 | 184.0 | FlatZip | 147488785930 | 147600521084 | 0 | 18197:8000001F | 147598825248 | 1 | 18197:81312C9D | 147597346735 | 1 | 2024-07-08 21:48:18 |
|---|
|
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 |
|---|
| 12644861 | 147270616180 | 147593678108 | 0.095413 | 0.095413 | 18197:80000005 | 147554870393 | 1 | 18197:804A09FE | 147572156291 | 1 | 671089 | 0 | 0.010737 | 0.123480 | 0 | | 12644862 | 147241136426 | 147593678473 | 0.086032 | 0.086032 | 18197:804A0A00 | 147534877597 | 1 | 18197:807CD0FF | 147526488565 | 1 | 601527 | 0 | 0.009624 | 0.110681 | 0 | | 12643433 | 147401035487 | 147565543571 | 0.095076 | 0.095076 | 18197:807DBA78 | 147486562085 | 1 | 18197:80AE29E0 | 147528709764 | 1 | 671089 | 0 | 0.010737 | 0.123480 | 0 | | 12643434 | 147241139317 | 147565543914 | 0.043560 | 0.043560 | 18197:80AE29E1 | 147536142537 | 1 | 18197:80C7A1FA | 147508125861 | 1 | 290173 | 0 | 0.004643 | 0.053392 | 0 | | 12643439 | 147267139010 | 147565543916 | 0.095199 | 0.095199 | 18197:80C7A1FC | 147512046991 | 1 | 18197:80FC81E2 | 147554944711 | 1 | 671089 | 0 | 0.010737 | 0.123480 | 0 | | 12644957 | 147364518069 | 147595234805 | 0.052790 | 0.052790 | 18197:80FC81E6 | 147524381681 | 1 | 18197:81312CD7 | 147594496909 | 1 | 355475 | 0 | 0.005688 | 0.065407 | 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 | 147602376561 |
| last_allocated_sequence | 147602376561 |
| last_published_sequence | 147176466927 |
| next_file_number | 12645335 |
| min_log_number_to_keep | 12645298 |
| manifest_file_number | 12625661 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 9683 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.952734 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 147488785930 |
| earliest_write_conflict_snapshot | 147602375463 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18197:8000001C |
| largest_user_key | 18197:81312C9D |
| existing_snapshots |
147602375463 |
|---|
| 147602375474 |
| 147602376340 |
| 147602376542 |
| 147602376557 |
| 147602376561 |
| extra_serde_files | |
| shutting_down | |
|
|---|