| overview |
| job_id | 23912 |
| 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 | 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-23912/att-00 |
|
|---|
| inputs |
all levels summary: version# 12659, file count = 3, total size = 0.171 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.047066 | 0.062500 | 335545 | 0 | 0 | 0 | 1 | 0.002088 | 0.044387 | 4.5% | 0.005000 | 0.057500 | 8.0% | 41.8% | 77.2% | 74.4% | 6.7 | 16.0 | 142.0 | 184.0 | FlatZip | 147685840406 | 147773431674 | 0 | 18199:80000002 | 147771066852 | 1 | 18199:806C4B6A | 147708862721 | 1 | 2024-07-09 01:02:16 | 46.511 MiB | 64.000 MiB |
|---|
| L3 | 2 | 2 | 0.124324 | 0.163039 | 875308 | 0 | 0 | 0 | 2 | 0.003436 | 0.119730 | 2.8% | 0.013043 | 0.149996 | 8.0% | 26.3% | 79.8% | 75.5% | 4.2 | 16.0 | 146.9 | 184.0 | FlatZip | 147275818799 | 147762687395 | 0 | 18199:80350975 | 147710998881 | 1 | 18199:8069DA69 | 147670228550 | 1 | 2024-07-09 00:50:26 | 61.560 MiB | 83.476 MiB |
|---|
| sum | 3 | 3 | 0.171390 | 0.225539 | 1210853 | 0 | 0 | 0 | 3 | 0.005523 | 0.164118 | 3.3% | 0.018043 | 0.207496 | 8.0% | 30.6% | 79.1% | 75.2% | 4.9 | 16.0 | 145.5 | 184.0 | FlatZip | 147275818799 | 147773431674 | 0 | 18199:80000002 | 147771066852 | 1 | 18199:806C4B6A | 147708862721 | 1 | 2024-07-09 00:50:26 | 56.544 MiB | 76.984 MiB |
|---|
level = 2, file count = 1, total zip = 0.047 GB, raw = 0.063 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 |
|---|
| 12652846 | 🟢 | 0.047066 | 0.062500 | 335545 | 0 | 0 | 0 | 1 | 0.002088 | 0.044387 | 4.5% | 0.005000 | 0.057500 | 8.0% | 41.8% | 77.2% | 74.4% | 6.7 | 16.0 | 142.0 | 184.0 | FlatZip | 147685840406 | 147773431674 | 5 | 18199:80000002 | 147771066852 | 1 | 18199:806C4B6A | 147708862721 | 1 | 2024-07-09 01:02:16 |
|---|
level = 3, file count = 2, total zip = 0.124 GB, raw = 0.163 GB, over prev level: zip = 2.641487, raw = 2.608616
| 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 |
|---|
| 12652455 | 🟢 | 0.088554 | 0.125000 | 671089 | 0 | 0 | 0 | 1 | 0.002662 | 0.084735 | 3.0% | 0.010000 | 0.115000 | 8.0% | 26.6% | 73.7% | 69.9% | 4.3 | 16.0 | 135.6 | 184.0 | FlatZip | 147275818799 | 147762687395 | 5 | 18199:80350975 | 147710998881 | 1 | 18199:805E9776 | 147711143991 | 1 | 2024-07-09 00:50:26 |
|---|
| 12652456 | 🟢 | 0.035770 | 0.038039 | 204219 | 0 | 0 | 0 | 1 | 0.000773 | 0.034996 | 2.2% | 0.003043 | 0.034996 | 8.0% | 25.4% | 100.0% | 94.0% | 4.1 | 16.0 | 184.0 | 184.0 | FlatZip | 147488790548 | 147732275891 | 5 | 18199:805E9783 | 147692586921 | 1 | 18199:8069DA69 | 147670228550 | 1 | 2024-07-09 00:50:31 |
|---|
| sum | 2 | 0.124324 | 0.163039 | 875308 | 0 | 0 | 0 | 2 | 0.003436 | 0.119730 | 2.8% | 0.013043 | 0.149996 | 8.0% | 26.3% | 79.8% | 75.5% | 4.2 | 16.0 | 146.9 | 184.0 | FlatZip | 147275818799 | 147762687395 | 0 | 18199:80350975 | 147710998881 | 1 | 18199:8069DA69 | 147670228550 | 1 | 2024-07-09 00:50:26 |
|---|
|
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 |
|---|
| 12652481 | 147180688430 | 147762686849 | 0.180724 | 0.180724 | 18199:80000001 | 147529558920 | 1 | 18199:801D4911 | 147399719215 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 12652482 | 147180692311 | 147762687394 | 0.177413 | 0.177413 | 18199:801D4912 | 147760054352 | 1 | 18199:803C7CCA | 147238493800 | 1 | 1315670 | 0 | 0.021051 | 0.242083 | 0 | | 12647832 | 147180690143 | 147644952933 | 0.180598 | 0.180598 | 18199:803C7CD1 | 147225986324 | 1 | 18199:805E8F36 | 147585346742 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 | | 12647833 | 147180689961 | 147644932418 | 0.050220 | 0.050220 | 18199:805E8F37 | 147600294404 | 1 | 18199:80680B61 | 147205613532 | 1 | 339859 | 0 | 0.005438 | 0.062534 | 0 | | 12652878 | 147180689295 | 147773431676 | 0.180738 | 0.180738 | 18199:80680B62 | 147353846010 | 1 | 18199:8085CB61 | 147482240464 | 1 | 1342178 | 0 | 0.021475 | 0.246961 | 0 |
|
| compaction |
| compaction_reason | kLevelMaxLevelSize |
| 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 | 147776973256 |
| last_allocated_sequence | 147776973256 |
| last_published_sequence | 147176466927 |
| next_file_number | 12652925 |
| min_log_number_to_keep | 12652882 |
| manifest_file_number | 12625661 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 12657 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 1.012900 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 147275818799 |
| earliest_write_conflict_snapshot | 147776971711 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18199:80000002 |
| largest_user_key | 18199:806C4B6A |
| existing_snapshots |
147776971711 |
|---|
| 147776971740 |
| 147776972772 |
| 147776973037 |
| 147776973230 |
| 147776973245 |
| 147776973256 |
| extra_serde_files | |
| shutting_down | |
|
|---|