| overview |
| job_id | 58925 |
| 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-58925/att-00 |
|
|---|
| inputs |
all levels summary: version# 29695, file count = 3, total size = 0.071 GB, avg size = 0.024 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 | 1 | 1 | 0.019407 | 0.062500 | 465520 | 0 | 0 | 0 | 1 | 0.002240 | 0.016655 | 11.9% | 0.012139 | 0.050361 | 19.4% | 18.5% | 33.1% | 30.2% | 5.2 | 28.0 | 38.4 | 116.2 | FlatZip | 191215519785 | 191279769212 | 0 | 18263:800000A88000000980055F4080000008 | 191229056459 | 1 | 18263:800000B9800000028004286480000006 | 191275754042 | 1 | 2024-08-21 01:19:34 | 17.906 MiB | 64.000 MiB |
|---|
| L3 | 2 | 2 | 0.051315 | 0.173056 | 1290449 | 0 | 0 | 0 | 2 | 0.006830 | 0.043077 | 13.7% | 0.033651 | 0.139405 | 19.4% | 20.3% | 30.9% | 28.8% | 5.7 | 28.0 | 35.8 | 116.0 | FlatZip | 189724223277 | 191266161198 | 0 | 18263:800000A8800000098005570480000009 | 191211798697 | 1 | 18263:800000B9800000038003BE728000000B | 191112877527 | 1 | 2024-08-21 00:10:58 | 23.232 MiB | 88.605 MiB |
|---|
| sum | 3 | 3 | 0.070722 | 0.235556 | 1755969 | 0 | 0 | 0 | 3 | 0.009070 | 0.059732 | 13.2% | 0.045790 | 0.189765 | 19.4% | 19.8% | 31.5% | 29.2% | 5.5 | 28.0 | 36.5 | 116.0 | FlatZip | 189724223277 | 191279769212 | 0 | 18263:800000A8800000098005570480000009 | 191211798697 | 1 | 18263:800000B9800000038003BE728000000B | 191112877527 | 1 | 2024-08-21 00:10:58 | 21.456 MiB | 80.403 MiB |
|---|
level = 2, file count = 1, total zip = 0.019 GB, raw = 0.063 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 |
|---|
| 14697033 | 🟢 | 0.019407 | 0.062500 | 465520 | 0 | 0 | 0 | 1 | 0.002240 | 0.016655 | 11.9% | 0.012139 | 0.050361 | 19.4% | 18.5% | 33.1% | 30.2% | 5.2 | 28.0 | 38.4 | 116.2 | FlatZip | 191215519785 | 191279769212 | 7 | 18263:800000A88000000980055F4080000008 | 191229056459 | 1 | 18263:800000B9800000028004286480000006 | 191275754042 | 1 | 2024-08-21 01:19:34 |
|---|
level = 3, file count = 2, total zip = 0.051 GB, raw = 0.173 GB, over prev level: zip = 2.644221, raw = 2.768895
| 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 |
|---|
| 14694634 | 🟢 | 0.036837 | 0.125000 | 932917 | 0 | 0 | 0 | 1 | 0.005031 | 0.030793 | 14.0% | 0.024328 | 0.100672 | 19.5% | 20.7% | 30.6% | 28.7% | 5.8 | 28.0 | 35.4 | 115.9 | FlatZip | 189724223277 | 191215516422 | 7 | 18263:800000A8800000098005570480000009 | 191211798697 | 1 | 18263:800000B980000001800364FF80000003 | 191130175377 | 1 | 2024-08-21 00:10:58 |
|---|
| 14696596 | 🟢 | 0.014478 | 0.048056 | 357532 | 0 | 0 | 0 | 1 | 0.001800 | 0.012283 | 12.8% | 0.009323 | 0.038733 | 19.4% | 19.3% | 31.7% | 29.3% | 5.4 | 28.0 | 36.9 | 116.3 | FlatZip | 191061406742 | 191266161198 | 11 | 18263:800000B9800000028004094780000008 | 191228270536 | 1 | 18263:800000B9800000038003BE728000000B | 191112877527 | 1 | 2024-08-21 01:04:35 |
|---|
| sum | 2 | 0.051315 | 0.173056 | 1290449 | 0 | 0 | 0 | 2 | 0.006830 | 0.043077 | 13.7% | 0.033651 | 0.139405 | 19.4% | 20.3% | 30.9% | 28.8% | 5.7 | 28.0 | 35.8 | 116.0 | FlatZip | 189724223277 | 191266161198 | 0 | 18263:800000A8800000098005570480000009 | 191211798697 | 1 | 18263:800000B9800000038003BE728000000B | 191112877527 | 1 | 2024-08-21 00:10:58 |
|---|
|
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 |
|---|
| 14693234 | 189793234413 | 191184924658 | 0.068336 | 0.068336 | 18263:800000A88000000980039BB280000003 | 190256607495 | 1 | 18263:800000A88000000A80034ECE8000000B | 190090088129 | 1 | 1849395 | 0 | 0.051783 | 0.216652 | 0 | | 14693235 | 189638867654 | 191184920519 | 0.051025 | 0.051025 | 18263:800000A88000000A80034ECE8000000C | 190090088130 | 1 | 18263:800000B48000000180003C0880000005 | 189641872021 | 1 | 1391669 | 0 | 0.038967 | 0.163873 | 0 | | 14640835 | 189641872022 | 189644120784 | 0.000264 | 0.000264 | 18263:800000B48000000180003C0880000006 | 189641872022 | 1 | 18263:800000B48000000180003DB180000001 | 189644120784 | 1 | 4278 | 0 | 0.000120 | 0.000505 | 0 | | 14635079 | 189636721631 | 189793095204 | 0.026638 | 0.026638 | 18263:800000B48000000180003DB180000002 | 189644120785 | 1 | 18263:800000B4800000028000A1908000000C | 189774841750 | 1 | 617028 | 0 | 0.017277 | 0.072587 | 0 | | 14629598 | 189636721648 | 189793091041 | 0.020145 | 0.020145 | 18263:800000B4800000028000A1908000000D | 189774841751 | 1 | 18263:800000B480000004800048FB80000008 | 189658495476 | 1 | 455082 | 0 | 0.012742 | 0.053390 | 0 | | 14628461 | 189636721676 | 189770404945 | 0.014714 | 0.014714 | 18263:800000B480000004800048FB80000009 | 189658495477 | 1 | 18263:800000B480000005800050078000000F | 189667968132 | 1 | 327955 | 0 | 0.009183 | 0.038501 | 0 | | 14631408 | 189636721694 | 189793094274 | 0.072276 | 0.072276 | 18263:800000B4800000058000500880000001 | 189667972999 | 1 | 18263:800000B48000000A80003DBD80000003 | 189644175307 | 1 | 1766752 | 0 | 0.049469 | 0.207237 | 0 | | 14675374 | 189644175308 | 190684724161 | 0.068503 | 0.068503 | 18263:800000B48000000A80003DBD80000004 | 189644175308 | 1 | 18263:800000B9800000018002596180000002 | 190684724161 | 1 | 1844196 | 0 | 0.051637 | 0.216798 | 0 | | 14696728 | 189793237620 | 191266150467 | 0.068746 | 0.068746 | 18263:800000B9800000018002596180000003 | 190684724162 | 1 | 18263:800000B980000002800112EF8000000A | 190176818432 | 1 | 1852543 | 0 | 0.051871 | 0.216564 | 0 | | 14696729 | 190176826185 | 191266160723 | 0.076497 | 0.076497 | 18263:800000B980000002800112F080000001 | 190176826185 | 1 | 18263:800000B9800000028003E2A880000003 | 191168073998 | 1 | 1841894 | 0 | 0.051573 | 0.216863 | 0 | | 14696730 | 189793237635 | 191228270535 | 0.030870 | 0.030870 | 18263:800000B9800000028003E2A880000004 | 191168073999 | 1 | 18263:800000B9800000038001047980000002 | 190155419961 | 1 | 745209 | 0 | 0.020866 | 0.087539 | 0 | | 14689106 | 189793237654 | 191087327467 | 0.064116 | 0.064116 | 18263:800000B9800000038001047980000003 | 190155419962 | 1 | 18263:800000B980000004800063C18000000A | 189920622416 | 1 | 1727617 | 0 | 0.048373 | 0.203859 | 0 |
|
| compaction |
| compaction_reason | kLevelMaxLevelSize |
| 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 | 191280406812 |
| last_allocated_sequence | 191280406812 |
| last_published_sequence | 189793095786 |
| next_file_number | 14697037 |
| min_log_number_to_keep | 14696877 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 29693 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 1.139954 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 189724223277 |
| earliest_write_conflict_snapshot | 191280405846 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18263:800000A8800000098005570480000009 |
| largest_user_key | 18263:800000B9800000038003BE728000000B |
| existing_snapshots |
191280405846 |
|---|
| 191280405890 |
| 191280406708 |
| 191280406786 |
| 191280406797 |
| 191280406808 |
| extra_serde_files | |
| shutting_down | |
|
|---|