| overview |
| job_id | 35622 |
| 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 | 465QC0QPK7Q93426EREI |
|
|---|
| 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-35622/att-00 |
|
|---|
| inputs |
all levels summary: version# 18570, file count = 3, total size = 0.067 GB, avg size = 0.022 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.016857 | 0.015680 | 84183 | 0 | 0 | 0 | 1 | 0.002430 | 0.014426 | 14.4% | 0.001254 | 0.014426 | 8.0% | 193.7% | 100.0% | 107.5% | 31.0 | 16.0 | 184.0 | 184.0 | SngFast | 148088752624 | 148090570609 | 0 | 18203:80000030 | 148090333666 | 1 | 18203:81312C7C | 148089149653 | 1 | 2024-07-09 07:21:21 | 16.619 MiB | 16.057 MiB |
|---|
| L2 | 2 | 2 | 0.049673 | 0.063926 | 343201 | 0 | 0 | 0 | 2 | 0.003375 | 0.045705 | 6.9% | 0.005114 | 0.058812 | 8.0% | 66.0% | 77.7% | 76.8% | 10.6 | 16.0 | 143.0 | 184.0 | FlatZip | 148081468721 | 148088752494 | 0 | 18203:8000001F | 148085945657 | 1 | 18203:81312C71 | 148085772216 | 1 | 2024-07-09 07:19:14 | 24.659 MiB | 32.730 MiB |
|---|
| sum | 3 | 3 | 0.066531 | 0.079606 | 427384 | 0 | 0 | 0 | 3 | 0.005806 | 0.060131 | 8.8% | 0.006369 | 0.073238 | 8.0% | 91.2% | 82.1% | 82.8% | 14.6 | 16.0 | 151.1 | 184.0 | FlatZip=2
SngFast=1 | 148081468721 | 148090570609 | 0 | 18203:8000001F | 148085945657 | 1 | 18203:81312C7C | 148089149653 | 1 | 2024-07-09 07:19:14 | 21.979 MiB | 27.172 MiB |
|---|
level = 1, file count = 1, total zip = 0.017 GB, raw = 0.016 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 |
|---|
| 12666454 | 🟢 | 0.016857 | 0.015680 | 84183 | 0 | 0 | 0 | 1 | 0.002430 | 0.014426 | 14.4% | 0.001254 | 0.014426 | 8.0% | 193.7% | 100.0% | 107.5% | 31.0 | 16.0 | 184.0 | 184.0 | SngFast | 148088752624 | 148090570609 | 4 | 18203:80000030 | 148090333666 | 1 | 18203:81312C7C | 148089149653 | 1 | 2024-07-09 07:21:21 |
|---|
level = 2, file count = 2, total zip = 0.050 GB, raw = 0.064 GB, over prev level: zip = 2.946728, raw = 4.076844
| 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 |
|---|
| 12666326 | 🟢 | 0.048284 | 0.062500 | 335545 | 0 | 0 | 0 | 1 | 0.003299 | 0.044393 | 6.9% | 0.005000 | 0.057500 | 8.0% | 66.0% | 77.2% | 76.3% | 10.6 | 16.0 | 142.1 | 184.0 | FlatZip | 148081468721 | 148088752494 | 4 | 18203:8000001F | 148085945657 | 1 | 18203:812A5E22 | 148083756326 | 1 | 2024-07-09 07:19:14 |
|---|
| 12666327 | 🟢 | 0.001390 | 0.001426 | 7656 | 0 | 0 | 0 | 1 | 0.000076 | 0.001312 | 5.5% | 0.000114 | 0.001312 | 8.0% | 67.0% | 100.0% | 97.4% | 10.7 | 16.0 | 184.0 | 184.0 | FlatZip | 148081469648 | 148088750302 | 5 | 18203:812A5E30 | 148087308490 | 1 | 18203:81312C71 | 148085772216 | 1 | 2024-07-09 07:19:19 |
|---|
| sum | 2 | 0.049673 | 0.063926 | 343201 | 0 | 0 | 0 | 2 | 0.003375 | 0.045705 | 6.9% | 0.005114 | 0.058812 | 8.0% | 66.0% | 77.7% | 76.8% | 10.6 | 16.0 | 143.0 | 184.0 | FlatZip | 148081468721 | 148088752494 | 0 | 18203:8000001F | 148085945657 | 1 | 18203:81312C71 | 148085772216 | 1 | 2024-07-09 07:19:14 |
|---|
|
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 |
|---|
| 12666145 | 148003935756 | 148081467994 | 0.096054 | 0.096054 | 18203:8000002C | 148079668446 | 1 | 18203:80992A9F | 148042632893 | 1 | 671089 | 0 | 0.010737 | 0.123480 | 0 | | 12666146 | 147941264024 | 148081467996 | 0.095716 | 0.095716 | 18203:80992AA6 | 148060204314 | 1 | 18203:810984A3 | 148057045012 | 1 | 671089 | 0 | 0.010737 | 0.123480 | 0 | | 12666147 | 148047069751 | 148081467987 | 0.037900 | 0.037900 | 18203:810984BC | 148065920992 | 1 | 18203:81312CD5 | 148056441337 | 1 | 200227 | 0 | 0.003204 | 0.036842 | 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 | 148090602990 |
| last_allocated_sequence | 148090602990 |
| last_published_sequence | 147176466927 |
| next_file_number | 12666484 |
| min_log_number_to_keep | 12666392 |
| manifest_file_number | 12625661 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 18568 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.963928 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 148081468721 |
| earliest_write_conflict_snapshot | 148090602604 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18203:8000001F |
| largest_user_key | 18203:81312C7C |
| existing_snapshots |
148090602604 |
|---|
| 148090602608 |
| 148090602964 |
| 148090602975 |
| 148090602986 |
| extra_serde_files | |
| shutting_down | |
|
|---|