| overview |
| job_id | 104293 |
| 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 | FDMKK73D6HWPO0XETTGC |
|
|---|
| 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-104293/att-00 |
|
|---|
| inputs |
all levels summary: version# 53984, file count = 3, total size = 0.100 GB, avg size = 0.033 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.018488 | 0.017231 | 92510 | 0 | 0 | 0 | 1 | 0.002634 | 0.015853 | 14.2% | 0.001379 | 0.015853 | 8.0% | 191.1% | 100.0% | 107.3% | 30.6 | 16.0 | 184.0 | 184.0 | SngFast | 165827617534 | 165829423218 | 0 | 18204:80000099 | 165827860011 | 1 | 18204:81312CB7 | 165828028245 | 1 | 2024-07-26 13:28:06 | 18.225 MiB | 17.645 MiB |
|---|
| L2 | 2 | 2 | 0.081868 | 0.097912 | 525663 | 0 | 0 | 0 | 2 | 0.004301 | 0.076974 | 5.3% | 0.007833 | 0.090079 | 8.0% | 54.9% | 85.5% | 83.0% | 8.8 | 16.0 | 157.2 | 184.0 | FlatZip | 165814759254 | 165827616617 | 0 | 18204:80000018 | 165819683819 | 1 | 18204:81312CE0 | 165825922319 | 1 | 2024-07-26 13:25:40 | 40.860 MiB | 50.131 MiB |
|---|
| sum | 3 | 3 | 0.100355 | 0.115144 | 618173 | 0 | 0 | 0 | 3 | 0.006935 | 0.092827 | 7.0% | 0.009211 | 0.105932 | 8.0% | 75.3% | 87.6% | 86.6% | 12.0 | 16.0 | 161.2 | 184.0 | FlatZip=2
SngFast=1 | 165814759254 | 165829423218 | 0 | 18204:80000018 | 165819683819 | 1 | 18204:81312CE0 | 165825922319 | 1 | 2024-07-26 13:25:40 | 33.315 MiB | 39.302 MiB |
|---|
level = 1, file count = 1, total zip = 0.018 GB, raw = 0.017 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 |
|---|
| 13490877 | 🟢 | 0.018488 | 0.017231 | 92510 | 0 | 0 | 0 | 1 | 0.002634 | 0.015853 | 14.2% | 0.001379 | 0.015853 | 8.0% | 191.1% | 100.0% | 107.3% | 30.6 | 16.0 | 184.0 | 184.0 | SngFast | 165827617534 | 165829423218 | 4 | 18204:80000099 | 165827860011 | 1 | 18204:81312CB7 | 165828028245 | 1 | 2024-07-26 13:28:06 |
|---|
level = 2, file count = 2, total zip = 0.082 GB, raw = 0.098 GB, over prev level: zip = 4.428155, raw = 5.682229
| 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 |
|---|
| 13490766 | 🟢 | 0.047681 | 0.062500 | 335545 | 0 | 0 | 0 | 1 | 0.002695 | 0.044394 | 5.7% | 0.005000 | 0.057500 | 8.0% | 53.9% | 77.2% | 75.3% | 8.6 | 16.0 | 142.1 | 184.0 | FlatZip | 165818432745 | 165827616617 | 5 | 18204:80000018 | 165819683819 | 1 | 18204:80D40939 | 165826414461 | 1 | 2024-07-26 13:25:40 |
|---|
| 13490767 | 🟢 | 0.034187 | 0.035412 | 190118 | 0 | 0 | 0 | 1 | 0.001606 | 0.032579 | 4.7% | 0.002833 | 0.032579 | 8.0% | 56.7% | 100.0% | 96.5% | 9.1 | 16.0 | 184.0 | 184.0 | FlatZip | 165814759254 | 165827616616 | 4 | 18204:80D4093F | 165825164319 | 1 | 18204:81312CE0 | 165825922319 | 1 | 2024-07-26 13:25:43 |
|---|
| sum | 2 | 0.081868 | 0.097912 | 525663 | 0 | 0 | 0 | 2 | 0.004301 | 0.076974 | 5.3% | 0.007833 | 0.090079 | 8.0% | 54.9% | 85.5% | 83.0% | 8.8 | 16.0 | 157.2 | 184.0 | FlatZip | 165814759254 | 165827616617 | 0 | 18204:80000018 | 165819683819 | 1 | 18204:81312CE0 | 165825922319 | 1 | 2024-07-26 13:25:40 |
|---|
|
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 |
|---|
| 13490438 | 164555954727 | 165818432570 | 0.180808 | 0.180808 | 18204:80000001 | 165347669158 | 1 | 18204:80154F4D | 165011679479 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 13490439 | 164555953834 | 165818432221 | 0.180826 | 0.180826 | 18204:80154F4E | 165589424352 | 1 | 18204:802A9DD1 | 165422619169 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 13490440 | 164555950007 | 165818432192 | 0.180815 | 0.180815 | 18204:802A9DD2 | 165576531986 | 1 | 18204:803FEA86 | 165176401654 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 13490441 | 164555950934 | 165818432322 | 0.180814 | 0.180814 | 18204:803FEA87 | 165079641864 | 1 | 18204:80553A52 | 165667439611 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 13490442 | 164555958609 | 165818432319 | 0.180817 | 0.180817 | 18204:80553A53 | 165311269149 | 1 | 18204:806A88AE | 165595929576 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 13490443 | 164555951593 | 165818432223 | 0.180820 | 0.180820 | 18204:806A88AF | 165754744695 | 1 | 18204:807FD543 | 165608911984 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 13490529 | 164555948593 | 165818432218 | 0.180811 | 0.180811 | 18204:807FD544 | 165671412417 | 1 | 18204:8095244C | 165499732802 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 13490530 | 164555949471 | 165818432316 | 0.180828 | 0.180828 | 18204:8095244D | 165784895898 | 1 | 18204:80AA7284 | 165180191935 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 13490531 | 164555950938 | 165818432188 | 0.180806 | 0.180806 | 18204:80AA7285 | 165731646890 | 1 | 18204:80BFBFA4 | 165298547800 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 13490532 | 164555950092 | 165818432224 | 0.180822 | 0.180822 | 18204:80BFBFA5 | 164741915327 | 1 | 18204:80D5104B | 165543108735 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 13490533 | 164555952872 | 165818432572 | 0.180823 | 0.180823 | 18204:80D5104C | 165815886977 | 1 | 18204:80EA5F8B | 165692038073 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 13490534 | 164555954005 | 165818432012 | 0.180818 | 0.180818 | 18204:80EA5F8C | 165768962737 | 1 | 18204:80FFAEB3 | 165751957939 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 13490535 | 164555948550 | 165814758975 | 0.180818 | 0.180818 | 18204:80FFAEB4 | 165296258709 | 1 | 18204:8114FD93 | 165734674062 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 13490536 | 164555953487 | 165814758646 | 0.180830 | 0.180830 | 18204:8114FD94 | 165370311196 | 1 | 18204:812A4E58 | 165604127766 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 13490537 | 164555949469 | 165814758864 | 0.062996 | 0.062996 | 18204:812A4E59 | 165529628184 | 1 | 18204:81312D00 | 164977018448 | 1 | 432607 | 0 | 0.006922 | 0.079600 | 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.831 KiB |
| InfoLogLevel | INFO_LEVEL |
|
|---|
version
set |
| last_sequence | 165829450128 |
| last_allocated_sequence | 165829450128 |
| last_published_sequence | 163149219356 |
| next_file_number | 13490885 |
| min_log_number_to_keep | 13490719 |
| manifest_file_number | 13366722 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 53982 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.770873 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 165814759254 |
| earliest_write_conflict_snapshot | 165829449044 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18204:80000018 |
| largest_user_key | 18204:81312CE0 |
| existing_snapshots |
165829449044 |
|---|
| 165829449055 |
| 165829449082 |
| 165829449551 |
| 165829449692 |
| 165829449696 |
| 165829449845 |
| 165829450105 |
| 165829450128 |
| extra_serde_files | |
| shutting_down | |
|
|---|