| overview |
| job_id | 52002 |
| 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-52002/att-00 |
|
|---|
| inputs |
all levels summary: version# 26348, file count = 4, total size = 0.188 GB, avg size = 0.047 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.015728 | 0.014593 | 78345 | 0 | 0 | 0 | 2 | 0.002301 | 0.013426 | 14.6% | 0.001167 | 0.013425 | 8.0% | 197.1% | 100.0% | 107.8% | 31.5 | 16.0 | 184.0 | 184.0 | SngFast | 191100312785 | 191102101882 | 0 | 18202:800001B6 | 191100432905 | 1 | 18202:81312CEB | 191100535766 | 1 | 2024-08-20 22:02:10 | 7.753 MiB | 7.472 MiB |
|---|
| L3 | 2 | 2 | 0.172687 | 0.240611 | 1291772 | 0 | 0 | 0 | 2 | 0.006899 | 0.163564 | 4.0% | 0.019249 | 0.221362 | 8.0% | 35.8% | 73.9% | 70.8% | 5.7 | 16.0 | 136.0 | 184.0 | FlatZip | 190996030830 | 191100312340 | 0 | 18202:8000005E | 191093996859 | 1 | 18202:81312CFA | 191089287542 | 1 | 2024-08-20 22:00:23 | 85.235 MiB | 123.193 MiB |
|---|
| sum | 4 | 4 | 0.188414 | 0.255204 | 1370117 | 0 | 0 | 0 | 4 | 0.009200 | 0.176989 | 4.9% | 0.020416 | 0.234788 | 8.0% | 45.1% | 75.4% | 73.0% | 7.2 | 16.0 | 138.7 | 184.0 | FlatZip=2
SngFast=2 | 190996030830 | 191102101882 | 0 | 18202:8000005E | 191093996859 | 1 | 18202:81312CFA | 191089287542 | 1 | 2024-08-20 22:00:23 | 46.494 MiB | 65.332 MiB |
|---|
level = 2, file count = 2, total zip = 0.016 GB, raw = 0.015 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 |
|---|
| 14689135 | 🟢 | 0.014976 | 0.013900 | 74627 | 0 | 0 | 0 | 1 | 0.002186 | 0.012788 | 14.6% | 0.001112 | 0.012788 | 8.0% | 196.6% | 100.0% | 107.7% | 31.5 | 16.0 | 184.0 | 184.0 | SngFast | 191100312786 | 191102101882 | 4 | 18202:800001B6 | 191100432905 | 1 | 18202:8122F9B3 | 191100528740 | 1 | 2024-08-20 22:02:10 |
|---|
| 14689117 | 🟢 | 0.000752 | 0.000693 | 3718 | 0 | 0 | 0 | 1 | 0.000114 | 0.000637 | 15.2% | 0.000055 | 0.000637 | 8.0% | 206.0% | 100.0% | 108.5% | 33.0 | 16.0 | 184.0 | 184.0 | SngFast | 191100312785 | 191102101878 | 5 | 18202:8122FA8D | 191101399011 | 1 | 18202:81312CEB | 191100535766 | 1 | 2024-08-20 22:02:10 |
|---|
| sum | 2 | 0.015728 | 0.014593 | 78345 | 0 | 0 | 0 | 2 | 0.002301 | 0.013426 | 14.6% | 0.001167 | 0.013425 | 8.0% | 197.1% | 100.0% | 107.8% | 31.5 | 16.0 | 184.0 | 184.0 | SngFast | 191100312785 | 191102101882 | 0 | 18202:800001B6 | 191100432905 | 1 | 18202:81312CEB | 191100535766 | 1 | 2024-08-20 22:02:10 |
|---|
level = 3, file count = 2, total zip = 0.173 GB, raw = 0.241 GB, over prev level: zip = 10.979846, raw = 16.488251
| 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 |
|---|
| 14689071 | 🟢 | 0.089720 | 0.125000 | 671089 | 0 | 0 | 0 | 1 | 0.003825 | 0.084738 | 4.3% | 0.010000 | 0.115000 | 8.0% | 38.3% | 73.7% | 70.9% | 6.1 | 16.0 | 135.6 | 184.0 | FlatZip | 190996030830 | 191100312339 | 5 | 18202:8000005E | 191093996859 | 1 | 18202:80B3E2EC | 191095762345 | 1 | 2024-08-20 22:00:23 |
|---|
| 14689072 | 🟢 | 0.082967 | 0.115611 | 620683 | 0 | 0 | 0 | 1 | 0.003074 | 0.078826 | 3.8% | 0.009249 | 0.106362 | 8.0% | 33.2% | 74.1% | 70.8% | 5.3 | 16.0 | 136.4 | 184.0 | FlatZip | 191040787938 | 191100312340 | 4 | 18202:80B3E2FF | 191074009685 | 1 | 18202:81312CFA | 191089287542 | 1 | 2024-08-20 22:00:27 |
|---|
| sum | 2 | 0.172687 | 0.240611 | 1291772 | 0 | 0 | 0 | 2 | 0.006899 | 0.163564 | 4.0% | 0.019249 | 0.221362 | 8.0% | 35.8% | 73.9% | 70.8% | 5.7 | 16.0 | 136.0 | 184.0 | FlatZip | 190996030830 | 191100312340 | 0 | 18202:8000005E | 191093996859 | 1 | 18202:81312CFA | 191089287542 | 1 | 2024-08-20 22:00:23 |
|---|
|
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 |
|---|
| 14688545 | 190690616628 | 191087663499 | 0.180725 | 0.180725 | 18202:80000003 | 190873058373 | 1 | 18202:802DB995 | 191021134883 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 14688546 | 189635000700 | 191087663495 | 0.180936 | 0.180936 | 18202:802DB996 | 191023484892 | 1 | 18202:804E7823 | 191028544884 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 14688547 | 189635024845 | 191087663496 | 0.153158 | 0.153158 | 18202:804E7824 | 190895997816 | 1 | 18202:806B681A | 190992960329 | 1 | 1121835 | 0 | 0.017949 | 0.206418 | 0 | | 14687762 | 190788404552 | 191073218552 | 0.180853 | 0.180853 | 18202:806B681F | 190896636711 | 1 | 18202:80A52BDF | 190940870542 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 14687763 | 190697743307 | 191073218549 | 0.180846 | 0.180846 | 18202:80A52BE1 | 190979912305 | 1 | 18202:80DD1526 | 191019190245 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 14687764 | 190841705457 | 191073218448 | 0.070177 | 0.070177 | 18202:80DD1527 | 190988914748 | 1 | 18202:80F09976 | 191037063269 | 1 | 485617 | 0 | 0.007770 | 0.089354 | 0 | | 14687633 | 189635046017 | 191069620498 | 0.181218 | 0.181218 | 18202:80F09977 | 190884095833 | 1 | 18202:812DFAAE | 190840181439 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 14687634 | 189635020986 | 191069619055 | 0.026541 | 0.026541 | 18202:812DFAAF | 190474226481 | 1 | 18202:81312CEE | 191067110793 | 1 | 141086 | 0 | 0.002257 | 0.025960 | 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 | 191102145206 |
| last_allocated_sequence | 191102145206 |
| last_published_sequence | 189793095786 |
| next_file_number | 14689144 |
| min_log_number_to_keep | 14688925 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 26346 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.995894 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 190996030830 |
| earliest_write_conflict_snapshot | 191102144929 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18202:8000005E |
| largest_user_key | 18202:81312CFA |
| existing_snapshots |
191102144929 |
|---|
| 191102145094 |
| 191102145147 |
| 191102145169 |
| 191102145202 |
| 191102145206 |
| extra_serde_files | |
| shutting_down | |
|
|---|