| overview |
| job_id | 16422 |
| 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-16422/att-00 |
|
|---|
| inputs |
all levels summary: version# 8428, file count = 5, total size = 0.284 GB, avg size = 0.057 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.013457 | 0.012446 | 66817 | 0 | 0 | 0 | 1 | 0.002007 | 0.011450 | 14.9% | 0.000996 | 0.011450 | 8.0% | 201.5% | 100.0% | 108.1% | 32.2 | 16.0 | 184.0 | 184.0 | SngFast | 190202324352 | 190204063548 | 0 | 18204:800002B5 | 190203695431 | 1 | 18204:81312C2A | 190203418821 | 1 | 2024-08-20 07:44:04 | 13.270 MiB | 12.744 MiB |
|---|
| L3 | 4 | 4 | 0.270645 | 0.378643 | 2032824 | 0 | 0 | 0 | 4 | 0.009609 | 0.257563 | 3.6% | 0.030291 | 0.348352 | 8.0% | 31.7% | 73.9% | 70.6% | 5.1 | 16.0 | 136.0 | 184.0 | FlatZip | 189734509079 | 190202323549 | 0 | 18204:80000022 | 190157547130 | 1 | 18204:81312CE6 | 190186260114 | 1 | 2024-08-20 07:42:49 | 66.681 MiB | 96.933 MiB |
|---|
| sum | 5 | 5 | 0.284102 | 0.391089 | 2099641 | 0 | 0 | 0 | 5 | 0.011616 | 0.269013 | 4.1% | 0.031287 | 0.359802 | 8.0% | 37.1% | 74.8% | 71.8% | 5.9 | 16.0 | 137.6 | 184.0 | FlatZip=4
SngFast=1 | 189734509079 | 190204063548 | 0 | 18204:80000022 | 190157547130 | 1 | 18204:81312CE6 | 190186260114 | 1 | 2024-08-20 07:42:49 | 55.999 MiB | 80.095 MiB |
|---|
level = 2, file count = 1, total zip = 0.013 GB, raw = 0.012 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 |
|---|
| 14647933 | 🟢 | 0.013457 | 0.012446 | 66817 | 0 | 0 | 0 | 1 | 0.002007 | 0.011450 | 14.9% | 0.000996 | 0.011450 | 8.0% | 201.5% | 100.0% | 108.1% | 32.2 | 16.0 | 184.0 | 184.0 | SngFast | 190202324352 | 190204063548 | 4 | 18204:800002B5 | 190203695431 | 1 | 18204:81312C2A | 190203418821 | 1 | 2024-08-20 07:44:04 |
|---|
level = 3, file count = 4, total zip = 0.271 GB, raw = 0.379 GB, over prev level: zip = 20.111366, raw = 30.423754
| 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 |
|---|
| 14647890 | 🟢 | 0.089015 | 0.125000 | 671089 | 0 | 0 | 0 | 1 | 0.003124 | 0.084734 | 3.6% | 0.010000 | 0.115000 | 8.0% | 31.2% | 73.7% | 70.3% | 5.0 | 16.0 | 135.6 | 184.0 | FlatZip | 189734509079 | 190202323547 | 5 | 18204:80000022 | 190157547130 | 1 | 18204:8059ECA4 | 190186759535 | 1 | 2024-08-20 07:42:49 |
|---|
| 14647891 | 🟢 | 0.089074 | 0.125000 | 671089 | 0 | 0 | 0 | 1 | 0.003179 | 0.084737 | 3.6% | 0.010000 | 0.115000 | 8.0% | 31.8% | 73.7% | 70.3% | 5.1 | 16.0 | 135.6 | 184.0 | FlatZip | 189988338814 | 190202323546 | 5 | 18204:8059ECA5 | 190200429449 | 1 | 18204:80C1E697 | 190102925521 | 1 | 2024-08-20 07:42:54 |
|---|
| 14647892 | 🟢 | 0.089069 | 0.125000 | 671089 | 0 | 0 | 0 | 1 | 0.003171 | 0.084740 | 3.6% | 0.010000 | 0.115000 | 8.0% | 31.7% | 73.7% | 70.3% | 5.1 | 16.0 | 135.6 | 184.0 | FlatZip | 190007511593 | 190202323549 | 4 | 18204:80C1E698 | 190091843089 | 1 | 18204:812908A1 | 190201296593 | 1 | 2024-08-20 07:42:59 |
|---|
| 14647893 | 🟢 | 0.003488 | 0.003643 | 19557 | 0 | 0 | 0 | 1 | 0.000135 | 0.003352 | 3.9% | 0.000291 | 0.003351 | 8.0% | 46.3% | 100.0% | 95.7% | 7.4 | 16.0 | 184.0 | 184.0 | FlatZip | 190183277469 | 190202320716 | 5 | 18204:812908B3 | 190190954656 | 1 | 18204:81312CE6 | 190186260114 | 1 | 2024-08-20 07:43:02 |
|---|
| sum | 4 | 0.270645 | 0.378643 | 2032824 | 0 | 0 | 0 | 4 | 0.009609 | 0.257563 | 3.6% | 0.030291 | 0.348352 | 8.0% | 31.7% | 73.9% | 70.6% | 5.1 | 16.0 | 136.0 | 184.0 | FlatZip | 189734509079 | 190202323549 | 0 | 18204:80000022 | 190157547130 | 1 | 18204:81312CE6 | 190186260114 | 1 | 2024-08-20 07:42:49 |
|---|
|
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 |
|---|
| 14645363 | 189634998610 | 190143265992 | 0.180596 | 0.180596 | 18204:80000002 | 190113798997 | 1 | 18204:80211D8B | 190011519207 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 14645364 | 189634998611 | 190143265349 | 0.145331 | 0.145331 | 18204:80211D8C | 189799872907 | 1 | 18204:803B842C | 189663221637 | 1 | 1062271 | 0 | 0.016996 | 0.195458 | 0 | | 14645267 | 189634998614 | 190141579536 | 0.180608 | 0.180608 | 18204:803B842D | 189679493258 | 1 | 18204:805CE866 | 189986308892 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 14646983 | 189634998281 | 190183271094 | 0.180772 | 0.180772 | 18204:805CE86B | 190078729298 | 1 | 18204:807E9A33 | 190092306209 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 14646984 | 189634998607 | 190183271088 | 0.157909 | 0.157909 | 18204:807E9A34 | 189867039366 | 1 | 18204:809AE86C | 190156019290 | 1 | 1160463 | 0 | 0.018567 | 0.213525 | 0 | | 14646767 | 189634998701 | 190174515821 | 0.180759 | 0.180759 | 18204:809AE86D | 189897447173 | 1 | 18204:80BACEF7 | 190029858199 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 14646768 | 189634999312 | 190174513810 | 0.073867 | 0.073867 | 18204:80BACEF8 | 189920869049 | 1 | 18204:80C91E8A | 189764108312 | 1 | 512551 | 0 | 0.008201 | 0.094309 | 0 | | 14646147 | 189634998279 | 190164041921 | 0.180599 | 0.180599 | 18204:80C91E8D | 189657005246 | 1 | 18204:80E9B6BE | 190013812350 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 14646148 | 189634998282 | 190164042819 | 0.180597 | 0.180597 | 18204:80E9B6BF | 190097943375 | 1 | 18204:810A0F25 | 189935491908 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 14646149 | 189634998284 | 190074864276 | 0.043904 | 0.043904 | 18204:810A0F27 | 189898179698 | 1 | 18204:8111FD8B | 190029714065 | 1 | 294008 | 0 | 0.004704 | 0.054097 | 0 | | 14646982 | 189634999402 | 190183271210 | 0.176445 | 0.176445 | 18204:8111FD8C | 190032302617 | 1 | 18204:81312CFF | 189699057662 | 1 | 1307764 | 0 | 0.020924 | 0.240629 | 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 | 190204079722 |
| last_allocated_sequence | 190204079722 |
| last_published_sequence | 189793095786 |
| next_file_number | 14647945 |
| min_log_number_to_keep | 14647789 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 8426 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.959808 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 189734509079 |
| earliest_write_conflict_snapshot | 190204079325 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18204:80000022 |
| largest_user_key | 18204:81312CE6 |
| existing_snapshots |
190204079325 |
|---|
| 190204079329 |
| 190204079362 |
| 190204079377 |
| 190204079399 |
| 190204079410 |
| 190204079562 |
| 190204079711 |
| 190204079722 |
| extra_serde_files | |
| shutting_down | |
|
|---|