| overview |
| job_id | 35596 |
| 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-35596/att-00 |
|
|---|
| inputs |
all levels summary: version# 18190, file count = 5, total size = 0.135 GB, avg size = 0.027 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.062444 | 0.061673 | 63860 | 0 | 0 | 0 | 2 | 0.001959 | 0.060484 | 3.1% | 0.001189 | 0.060484 | 1.9% | 164.7% | 100.0% | 101.2% | 32.9 | 20.0 | 1017.0 | 1017.0 | SngFast | 190683488280 | 190687044619 | 0 | 18265:800000B980007020 | 190686817815 | 1 | 18265:8000010B8000C4CF | 190686291788 | 1 | 2024-08-20 14:54:39 | 31.727 MiB | 31.577 MiB |
|---|
| L3 | 3 | 3 | 0.072769 | 0.222990 | 230895 | 0 | 0 | 0 | 3 | 0.001934 | 0.068560 | 2.7% | 0.004301 | 0.218689 | 1.9% | 45.0% | 31.4% | 31.6% | 9.0 | 20.0 | 318.8 | 1017.0 | FlatZip | 190531902229 | 190687044454 | 0 | 18265:800000A880004B35 | 190659908262 | 1 | 18265:8000012C8001814C | 190682035371 | 1 | 2024-08-20 14:51:34 | 23.817 MiB | 76.114 MiB |
|---|
| sum | 5 | 5 | 0.135213 | 0.284663 | 294755 | 0 | 0 | 0 | 5 | 0.003893 | 0.129044 | 2.9% | 0.005490 | 0.279173 | 1.9% | 70.9% | 46.2% | 46.7% | 14.2 | 20.0 | 470.1 | 1017.0 | FlatZip=3
SngFast=2 | 190531902229 | 190687044619 | 0 | 18265:800000A880004B35 | 190659908262 | 1 | 18265:8000012C8001814C | 190682035371 | 1 | 2024-08-20 14:51:34 | 26.981 MiB | 58.299 MiB |
|---|
level = 2, file count = 2, total zip = 0.062 GB, raw = 0.062 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 |
|---|
| 14670254 | 🟢 | 0.031222 | 0.030820 | 31914 | 0 | 0 | 0 | 1 | 0.000996 | 0.030226 | 3.2% | 0.000594 | 0.030225 | 1.9% | 167.5% | 100.0% | 101.3% | 33.5 | 20.0 | 1016.9 | 1016.9 | SngFast | 190683488280 | 190687044619 | 7 | 18265:800000B980007020 | 190686817815 | 1 | 18265:800000DC8001126A | 190684160462 | 1 | 2024-08-20 14:54:39 |
|---|
| 14670255 | 🟢 | 0.031222 | 0.030853 | 31946 | 0 | 0 | 0 | 1 | 0.000963 | 0.030258 | 3.1% | 0.000595 | 0.030258 | 1.9% | 161.9% | 100.0% | 101.2% | 32.4 | 20.0 | 1017.0 | 1017.0 | SngFast | 190683492569 | 190687044448 | 6 | 18265:800000DC8001126B | 190685472494 | 1 | 18265:8000010B8000C4CF | 190686291788 | 1 | 2024-08-20 14:54:39 |
|---|
| sum | 2 | 0.062444 | 0.061673 | 63860 | 0 | 0 | 0 | 2 | 0.001959 | 0.060484 | 3.1% | 0.001189 | 0.060484 | 1.9% | 164.7% | 100.0% | 101.2% | 32.9 | 20.0 | 1017.0 | 1017.0 | SngFast | 190683488280 | 190687044619 | 0 | 18265:800000B980007020 | 190686817815 | 1 | 18265:8000010B8000C4CF | 190686291788 | 1 | 2024-08-20 14:54:39 |
|---|
level = 3, file count = 3, total zip = 0.073 GB, raw = 0.223 GB, over prev level: zip = 1.165339, raw = 3.615661
| 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 |
|---|
| 14670190 | 🟢 | 0.040654 | 0.125000 | 129432 | 0 | 0 | 0 | 1 | 0.001051 | 0.038319 | 2.7% | 0.002411 | 0.122589 | 1.9% | 43.6% | 31.3% | 31.5% | 8.7 | 20.0 | 317.9 | 1017.0 | FlatZip | 190531902229 | 190683488235 | 7 | 18265:800000A880004B35 | 190659908262 | 1 | 18265:800000DC80012FA1 | 190680878932 | 1 | 2024-08-20 14:51:34 |
|---|
| 14670191 | 🟢 | 0.004624 | 0.013891 | 14384 | 0 | 0 | 0 | 1 | 0.000120 | 0.004368 | 2.7% | 0.000268 | 0.013623 | 1.9% | 44.9% | 32.1% | 32.3% | 9.0 | 20.0 | 326.1 | 1016.9 | FlatZip | 190663891311 | 190683484968 | 7 | 18265:800000DC80012FA4 | 190664254480 | 1 | 18265:800000F78000120C | 190679030133 | 1 | 2024-08-20 14:51:35 |
|---|
| 14670262 | 🟢 | 0.027490 | 0.084099 | 87079 | 0 | 0 | 0 | 1 | 0.000763 | 0.025873 | 2.9% | 0.001622 | 0.082477 | 1.9% | 47.0% | 31.4% | 31.7% | 9.4 | 20.0 | 319.0 | 1017.0 | FlatZip | 190660328346 | 190687044454 | 6 | 18265:800000F780001213 | 190679319168 | 1 | 18265:8000012C8001814C | 190682035371 | 1 | 2024-08-20 14:54:41 |
|---|
| sum | 3 | 0.072769 | 0.222990 | 230895 | 0 | 0 | 0 | 3 | 0.001934 | 0.068560 | 2.7% | 0.004301 | 0.218689 | 1.9% | 45.0% | 31.4% | 31.6% | 9.0 | 20.0 | 318.8 | 1017.0 | FlatZip | 190531902229 | 190687044454 | 0 | 18265:800000A880004B35 | 190659908262 | 1 | 18265:8000012C8001814C | 190682035371 | 1 | 2024-08-20 14:51:34 |
|---|
|
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 |
|---|
| 14669358 | 189650398659 | 190665664028 | 0.086835 | 0.086835 | 18265:800000A880000CB6 | 190529133990 | 1 | 18265:800000B9800067D4 | 190592658244 | 1 | 258861 | 0 | 0.005177 | 0.263259 | 0 | | 14669359 | 189650398772 | 190665664035 | 0.086682 | 0.086682 | 18265:800000B9800067D5 | 190664584237 | 1 | 18265:800000D58000AF2D | 190439281744 | 1 | 258858 | 0 | 0.005177 | 0.263258 | 0 | | 14669360 | 189650410220 | 190665663658 | 0.017750 | 0.017750 | 18265:800000D58000AF2F | 190197440279 | 1 | 18265:800000DC80006B94 | 190420696442 | 1 | 52468 | 0 | 0.001049 | 0.053358 | 0 | | 14669237 | 189650408151 | 190663875912 | 0.086920 | 0.086920 | 18265:800000DC80006B96 | 190141864194 | 1 | 18265:800000F780017B0A | 190659573878 | 1 | 258858 | 0 | 0.005177 | 0.263259 | 0 | | 14669238 | 189650409033 | 190663875729 | 0.087101 | 0.087101 | 18265:800000F780017B0B | 190660864597 | 1 | 18265:80000111800131EC | 189792480249 | 1 | 258855 | 0 | 0.005177 | 0.263259 | 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 | 190687205188 |
| last_allocated_sequence | 190687205188 |
| last_published_sequence | 189793095786 |
| next_file_number | 14670263 |
| min_log_number_to_keep | 14670219 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 18188 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.988203 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 190531902229 |
| earliest_write_conflict_snapshot | 190687204719 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18265:800000A880004B35 |
| largest_user_key | 18265:8000012C8001814C |
| existing_snapshots |
190687204719 |
|---|
| 190687204745 |
| 190687205113 |
| 190687205124 |
| 190687205135 |
| 190687205166 |
| 190687205177 |
| 190687205188 |
| extra_serde_files | |
| shutting_down | |
|
|---|