| overview |
| job_id | 42983 |
| 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-42983/att-00 |
|
|---|
| inputs |
all levels summary: version# 21921, file count = 4, total size = 0.125 GB, avg size = 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 | 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.014420 | 0.013362 | 71736 | 0 | 0 | 0 | 1 | 0.002126 | 0.012293 | 14.7% | 0.001069 | 0.012293 | 8.0% | 198.9% | 100.0% | 107.9% | 31.8 | 16.0 | 184.0 | 184.0 | SngFast | 190870815139 | 190872504884 | 0 | 18205:8000024B | 190870862493 | 1 | 18205:81312CF8 | 190871277369 | 1 | 2024-08-20 17:59:30 | 14.218 MiB | 13.683 MiB |
|---|
| L2 | 3 | 3 | 0.110731 | 0.141899 | 761816 | 0 | 0 | 0 | 3 | 0.005217 | 0.104331 | 4.8% | 0.011352 | 0.130547 | 8.0% | 46.0% | 79.9% | 77.2% | 7.4 | 16.0 | 147.1 | 184.0 | FlatZip | 190813323345 | 190870814959 | 0 | 18205:80000026 | 190867541020 | 1 | 18205:81312C98 | 190867674788 | 1 | 2024-08-20 17:57:47 | 36.605 MiB | 48.435 MiB |
|---|
| sum | 4 | 4 | 0.125151 | 0.155261 | 833552 | 0 | 0 | 0 | 4 | 0.007344 | 0.116624 | 5.9% | 0.012421 | 0.142840 | 8.0% | 59.1% | 81.6% | 79.8% | 9.5 | 16.0 | 150.2 | 184.0 | FlatZip=3
SngFast=1 | 190813323345 | 190872504884 | 0 | 18205:80000026 | 190867541020 | 1 | 18205:81312CF8 | 190871277369 | 1 | 2024-08-20 17:57:47 | 31.009 MiB | 39.747 MiB |
|---|
level = 1, file count = 1, total zip = 0.014 GB, raw = 0.013 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 |
|---|
| 14678828 | 🟢 | 0.014420 | 0.013362 | 71736 | 0 | 0 | 0 | 1 | 0.002126 | 0.012293 | 14.7% | 0.001069 | 0.012293 | 8.0% | 198.9% | 100.0% | 107.9% | 31.8 | 16.0 | 184.0 | 184.0 | SngFast | 190870815139 | 190872504884 | 4 | 18205:8000024B | 190870862493 | 1 | 18205:81312CF8 | 190871277369 | 1 | 2024-08-20 17:59:30 |
|---|
level = 2, file count = 3, total zip = 0.111 GB, raw = 0.142 GB, over prev level: zip = 7.678913, raw = 10.619717
| 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 |
|---|
| 14678769 | 🟢 | 0.047234 | 0.062500 | 335545 | 0 | 0 | 0 | 1 | 0.002255 | 0.044389 | 4.8% | 0.005000 | 0.057500 | 8.0% | 45.1% | 77.2% | 74.6% | 7.2 | 16.0 | 142.0 | 184.0 | FlatZip | 190818682378 | 190870814959 | 5 | 18205:80000026 | 190867541020 | 1 | 18205:8081E126 | 190854019520 | 1 | 2024-08-20 17:57:47 |
|---|
| 14678770 | 🟢 | 0.047446 | 0.062500 | 335545 | 0 | 0 | 0 | 1 | 0.002459 | 0.044395 | 5.2% | 0.005000 | 0.057500 | 8.0% | 49.2% | 77.2% | 75.0% | 7.9 | 16.0 | 142.1 | 184.0 | FlatZip | 190813323870 | 190870814958 | 4 | 18205:8081E128 | 190866090555 | 1 | 18205:81193C1A | 190858783338 | 1 | 2024-08-20 17:57:52 |
|---|
| 14678771 | 🟢 | 0.016052 | 0.016899 | 90726 | 0 | 0 | 0 | 1 | 0.000503 | 0.015547 | 3.1% | 0.001352 | 0.015547 | 8.0% | 37.2% | 100.0% | 95.0% | 6.0 | 16.0 | 184.0 | 184.0 | FlatZip | 190813323345 | 190870814957 | 5 | 18205:81193C28 | 190840940466 | 1 | 18205:81312C98 | 190867674788 | 1 | 2024-08-20 17:57:56 |
|---|
| sum | 3 | 0.110731 | 0.141899 | 761816 | 0 | 0 | 0 | 3 | 0.005217 | 0.104331 | 4.8% | 0.011352 | 0.130547 | 8.0% | 46.0% | 79.9% | 77.2% | 7.4 | 16.0 | 147.1 | 184.0 | FlatZip | 190813323345 | 190870814959 | 0 | 18205:80000026 | 190867541020 | 1 | 18205:81312C98 | 190867674788 | 1 | 2024-08-20 17:57:47 |
|---|
|
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 |
|---|
| 14678212 | 190642688571 | 190860596395 | 0.095074 | 0.095074 | 18205:80000009 | 190795163934 | 1 | 18205:803184CE | 190781036382 | 1 | 671089 | 0 | 0.010737 | 0.123480 | 0 | | 14677770 | 190297846603 | 190852247476 | 0.095295 | 0.095295 | 18205:803D862F | 190690367145 | 1 | 18205:8073A510 | 190827700410 | 1 | 671089 | 0 | 0.010737 | 0.123480 | 0 | | 14677771 | 190577278777 | 190852247471 | 0.059361 | 0.059361 | 18205:8073A51B | 190818023141 | 1 | 18205:80888DE7 | 190840848873 | 1 | 405733 | 0 | 0.006492 | 0.074655 | 0 | | 14678601 | 190595025227 | 190867423355 | 0.095136 | 0.095136 | 18205:80888DEE | 190796923749 | 1 | 18205:80B7B524 | 190651815897 | 1 | 671089 | 0 | 0.010737 | 0.123480 | 0 | | 14678602 | 190595039324 | 190867423359 | 0.070915 | 0.070915 | 18205:80B7B527 | 190722799958 | 1 | 18205:80E851CA | 190850926791 | 1 | 488394 | 0 | 0.007814 | 0.089864 | 0 | | 14677356 | 190706602204 | 190839934329 | 0.094910 | 0.094910 | 18205:80ED151F | 190734453995 | 1 | 18205:811619E2 | 190758333906 | 1 | 671089 | 0 | 0.010737 | 0.123480 | 0 | | 14677357 | 190706603697 | 190813322646 | 0.024493 | 0.024493 | 18205:811619E7 | 190803457978 | 1 | 18205:811FBEE6 | 190806050411 | 1 | 130178 | 0 | 0.002083 | 0.023953 | 0 | | 14678207 | 190706602208 | 190860596173 | 0.046523 | 0.046523 | 18205:811FBEF0 | 190737007736 | 1 | 18205:81312CF8 | 190853187260 | 1 | 312579 | 0 | 0.005001 | 0.057515 | 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 | 190872524788 |
| last_allocated_sequence | 190872524788 |
| last_published_sequence | 189793095786 |
| next_file_number | 14678848 |
| min_log_number_to_keep | 14678810 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 21919 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.997359 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 190813323345 |
| earliest_write_conflict_snapshot | 190872524109 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18205:80000026 |
| largest_user_key | 18205:81312CF8 |
| existing_snapshots |
190872524109 |
|---|
| 190872524658 |
| 190872524688 |
| 190872524729 |
| 190872524755 |
| 190872524788 |
| extra_serde_files | |
| shutting_down | |
|
|---|