| overview |
| job_id | 40912 |
| num_levels | 7 |
| output_level | 3 |
| target_file_size | 128.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-40912/att-00 |
|
|---|
| inputs |
all levels summary: version# 20840, file count = 5, total size = 0.114 GB, avg size = 0.023 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 |
|---|
| L2 | 2 | 2 | 0.045763 | 0.045169 | 46770 | 0 | 0 | 0 | 2 | 0.001464 | 0.044298 | 3.2% | 0.000871 | 0.044298 | 1.9% | 168.0% | 100.0% | 101.3% | 33.6 | 20.0 | 1017.0 | 1017.0 | SngFast | 190818681707 | 190820463611 | 0 | 18265:800000B980009C13 | 190818801723 | 1 | 18265:8000012C8001231C | 190819144145 | 1 | 2024-08-20 17:06:24 | 23.252 MiB | 23.127 MiB |
|---|
| L3 | 3 | 3 | 0.068612 | 0.210544 | 218006 | 0 | 0 | 0 | 3 | 0.001758 | 0.064707 | 2.6% | 0.004061 | 0.206483 | 1.9% | 43.3% | 31.3% | 31.6% | 8.7 | 20.0 | 318.7 | 1017.0 | FlatZip | 190660328346 | 190818681615 | 0 | 18265:800000A88000EEAA | 190813518420 | 1 | 18265:8000012C8001836B | 190807437810 | 1 | 2024-08-20 17:04:56 | 22.447 MiB | 71.866 MiB |
|---|
| sum | 5 | 5 | 0.114375 | 0.255713 | 264776 | 0 | 0 | 0 | 5 | 0.003222 | 0.109005 | 2.9% | 0.004932 | 0.250781 | 1.9% | 65.3% | 43.5% | 43.9% | 13.1 | 20.0 | 442.0 | 1017.0 | FlatZip=3
SngFast=2 | 190660328346 | 190820463611 | 0 | 18265:800000A88000EEAA | 190813518420 | 1 | 18265:8000012C8001836B | 190807437810 | 1 | 2024-08-20 17:04:56 | 22.769 MiB | 52.370 MiB |
|---|
level = 2, file count = 2, total zip = 0.046 GB, raw = 0.045 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 |
|---|
| 14676334 | 🟢 | 0.031222 | 0.030861 | 31955 | 0 | 0 | 0 | 1 | 0.000956 | 0.030266 | 3.1% | 0.000595 | 0.030265 | 1.9% | 160.6% | 100.0% | 101.2% | 32.1 | 20.0 | 1017.0 | 1017.0 | SngFast | 190818681707 | 190820463611 | 6 | 18265:800000B980009C13 | 190818801723 | 1 | 18265:8000010B800009C3 | 190820396917 | 1 | 2024-08-20 17:06:24 |
|---|
| 14676337 | 🟢 | 0.014541 | 0.014308 | 14815 | 0 | 0 | 0 | 1 | 0.000508 | 0.014032 | 3.5% | 0.000276 | 0.014032 | 1.9% | 184.0% | 100.0% | 101.6% | 36.8 | 20.0 | 1017.0 | 1017.0 | SngFast | 190818681795 | 190820460712 | 7 | 18265:8000010B800009D3 | 190819664087 | 1 | 18265:8000012C8001231C | 190819144145 | 1 | 2024-08-20 17:06:24 |
|---|
| sum | 2 | 0.045763 | 0.045169 | 46770 | 0 | 0 | 0 | 2 | 0.001464 | 0.044298 | 3.2% | 0.000871 | 0.044298 | 1.9% | 168.0% | 100.0% | 101.3% | 33.6 | 20.0 | 1017.0 | 1017.0 | SngFast | 190818681707 | 190820463611 | 0 | 18265:800000B980009C13 | 190818801723 | 1 | 18265:8000012C8001231C | 190819144145 | 1 | 2024-08-20 17:06:24 |
|---|
level = 3, file count = 3, total zip = 0.069 GB, raw = 0.211 GB, over prev level: zip = 1.499282, raw = 4.661242
| 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 |
|---|
| 14676279 | 🟢 | 0.040646 | 0.125000 | 129432 | 0 | 0 | 0 | 1 | 0.001052 | 0.038309 | 2.7% | 0.002411 | 0.122589 | 1.9% | 43.6% | 31.2% | 31.5% | 8.7 | 20.0 | 317.8 | 1017.0 | FlatZip | 190665683038 | 190818681605 | 7 | 18265:800000A88000EEAA | 190813518420 | 1 | 18265:800000F780008939 | 190811572184 | 1 | 2024-08-20 17:05:00 |
|---|
| 14676280 | 🟢 | 0.005416 | 0.016545 | 17131 | 0 | 0 | 0 | 1 | 0.000056 | 0.005193 | 1.1% | 0.000319 | 0.016225 | 1.9% | 17.7% | 32.0% | 31.7% | 3.5 | 20.0 | 325.5 | 1017.0 | FlatZip | 190802650418 | 190818681612 | 9 | 18265:800000F78000893A | 190811360484 | 1 | 18265:800000F78001672A | 190815639166 | 1 | 2024-08-20 17:05:02 |
|---|
| 14676269 | 🟢 | 0.022550 | 0.068999 | 71443 | 0 | 0 | 0 | 1 | 0.000650 | 0.021205 | 3.0% | 0.001331 | 0.067668 | 1.9% | 48.8% | 31.3% | 31.7% | 9.8 | 20.0 | 318.7 | 1017.0 | FlatZip | 190660328346 | 190818681615 | 6 | 18265:800000F78001672B | 190813963535 | 1 | 18265:8000012C8001836B | 190807437810 | 1 | 2024-08-20 17:04:56 |
|---|
| sum | 3 | 0.068612 | 0.210544 | 218006 | 0 | 0 | 0 | 3 | 0.001758 | 0.064707 | 2.6% | 0.004061 | 0.206483 | 1.9% | 43.3% | 31.3% | 31.6% | 8.7 | 20.0 | 318.7 | 1017.0 | FlatZip | 190660328346 | 190818681615 | 0 | 18265:800000A88000EEAA | 190813518420 | 1 | 18265:8000012C8001836B | 190807437810 | 1 | 2024-08-20 17:04: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 |
|---|
| 14675625 | 189650419945 | 190802646272 | 0.086887 | 0.086887 | 18265:800000A38000CEAF | 190689344851 | 1 | 18265:800000B48000F7CF | 189767992826 | 1 | 258858 | 0 | 0.005177 | 0.263258 | 0 | | 14675626 | 189650398659 | 190802647513 | 0.086774 | 0.086774 | 18265:800000B48000F7D0 | 189752580355 | 1 | 18265:800000C280017513 | 189786122147 | 1 | 258864 | 0 | 0.005177 | 0.263258 | 0 | | 14675627 | 189650399593 | 190802594647 | 0.027145 | 0.027145 | 18265:800000C280017514 | 189792082139 | 1 | 18265:800000D58000AF2D | 190439281744 | 1 | 80641 | 0 | 0.001613 | 0.082013 | 0 | | 14675580 | 189650408151 | 190802647960 | 0.086812 | 0.086812 | 18265:800000D58000AF2F | 190197440279 | 1 | 18265:800000F780005869 | 190795001089 | 1 | 258861 | 0 | 0.005177 | 0.263259 | 0 | | 14675581 | 189650424519 | 190802647838 | 0.087224 | 0.087224 | 18265:800000F78000586A | 190801269747 | 1 | 18265:8000010E80002C63 | 190213366505 | 1 | 258855 | 0 | 0.005177 | 0.263259 | 0 | | 14675583 | 189651908328 | 190771650935 | 0.000202 | 0.000202 | 18265:8000010E80002C75 | 189765139977 | 1 | 18265:8000010E80005FF5 | 189771465185 | 1 | 565 | 0 | 0.000011 | 0.000575 | 0 | | 14675489 | 189651106030 | 190771687294 | 0.001481 | 0.001481 | 18265:8000010E80006023 | 190769308342 | 1 | 18265:8000010F80005453 | 190553473334 | 1 | 4180 | 0 | 0.000084 | 0.004252 | 0 | | 14674341 | 189650442586 | 190772496658 | 0.002755 | 0.002755 | 18265:8000010F80005482 | 189784827742 | 1 | 18265:800001118000017A | 189750887042 | 1 | 7850 | 0 | 0.000157 | 0.007984 | 0 | | 14672794 | 189650975641 | 190644689949 | 0.000202 | 0.000202 | 18265:800001118000017C | 189748587643 | 1 | 18265:800001118000040C | 189669709457 | 1 | 572 | 0 | 0.000011 | 0.000582 | 0 | | 14672696 | 189650449675 | 190643140282 | 0.001325 | 0.001325 | 18265:800001118000040D | 189774477276 | 1 | 18265:8000011180001685 | 189762151815 | 1 | 3845 | 0 | 0.000077 | 0.003910 | 0 | | 14671463 | 189650517844 | 190654510209 | 0.001274 | 0.001274 | 18265:8000011180001686 | 189775907712 | 1 | 18265:8000011180002669 | 189747503958 | 1 | 3694 | 0 | 0.000074 | 0.003757 | 0 | | 14670418 | 189650409033 | 190659923862 | 0.018855 | 0.018855 | 18265:800001118000266A | 189767219383 | 1 | 18265:80000111800131EC | 189792480249 | 1 | 56655 | 0 | 0.001133 | 0.057621 | 0 | | 14669239 | 189658380869 | 190659551494 | 0.000212 | 0.000212 | 18265:80000111800131ED | 189788025882 | 1 | 18265:8000011180013449 | 189790615003 | 1 | 599 | 0 | 0.000012 | 0.000609 | 0 | | 14669212 | 189784455106 | 189793073064 | 0.000008 | 0.000008 | 18265:800001118001344A | 189792139927 | 1 | 18265:800001118001345A | 189789545042 | 1 | 17 | 0 | 0.000000 | 0.000017 | 0 | | 14669134 | 189650406054 | 190660274302 | 0.041671 | 0.041671 | 18265:800001118001345B | 189789406098 | 1 | 18265:8000012C80018663 | 190200441993 | 1 | 123802 | 0 | 0.002476 | 0.125902 | 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 | 190820498629 |
| last_allocated_sequence | 190820498629 |
| last_published_sequence | 189793095786 |
| next_file_number | 14676344 |
| min_log_number_to_keep | 14676281 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 20838 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.988730 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 190660328346 |
| earliest_write_conflict_snapshot | 190820498353 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18265:800000A88000EEAA |
| largest_user_key | 18265:8000012C8001836B |
| existing_snapshots |
190820498353 |
|---|
| 190820498601 |
| 190820498612 |
| 190820498629 |
| extra_serde_files | |
| shutting_down | |
|
|---|