| overview |
| job_id | 10460 |
| 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-10460/att-00 |
|
|---|
| inputs |
all levels summary: version# 5820, file count = 3, total size = 0.074 GB, avg size = 0.025 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.013873 | 0.012841 | 68939 | 0 | 0 | 0 | 1 | 0.002059 | 0.011814 | 14.8% | 0.001027 | 0.011814 | 8.0% | 200.4% | 100.0% | 108.0% | 32.1 | 16.0 | 184.0 | 184.0 | SngFast | 147404500285 | 147406239141 | 0 | 18197:80000151 | 147405941752 | 1 | 18197:81312C78 | 147405565178 | 1 | 2024-07-08 18:18:45 | 13.680 MiB | 13.149 MiB |
|---|
| L2 | 2 | 2 | 0.060547 | 0.076135 | 408746 | 0 | 0 | 0 | 2 | 0.003018 | 0.056936 | 5.0% | 0.006091 | 0.070044 | 8.0% | 49.5% | 81.3% | 78.7% | 7.9 | 16.0 | 149.6 | 184.0 | FlatZip | 147367996785 | 147404499886 | 0 | 18197:8000007D | 147402662983 | 1 | 18197:81312CE8 | 147397424945 | 1 | 2024-07-08 18:17:00 | 30.072 MiB | 38.981 MiB |
|---|
| sum | 3 | 3 | 0.074420 | 0.088976 | 477685 | 0 | 0 | 0 | 3 | 0.005077 | 0.068750 | 6.9% | 0.007118 | 0.081858 | 8.0% | 71.3% | 84.0% | 83.0% | 11.4 | 16.0 | 154.5 | 184.0 | FlatZip=2
SngFast=1 | 147367996785 | 147406239141 | 0 | 18197:8000007D | 147402662983 | 1 | 18197:81312CE8 | 147397424945 | 1 | 2024-07-08 18:17:00 | 24.608 MiB | 30.370 MiB |
|---|
level = 1, file count = 1, total zip = 0.014 GB, raw = 0.013 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 |
|---|
| 12636285 | 🟢 | 0.013873 | 0.012841 | 68939 | 0 | 0 | 0 | 1 | 0.002059 | 0.011814 | 14.8% | 0.001027 | 0.011814 | 8.0% | 200.4% | 100.0% | 108.0% | 32.1 | 16.0 | 184.0 | 184.0 | SngFast | 147404500285 | 147406239141 | 4 | 18197:80000151 | 147405941752 | 1 | 18197:81312C78 | 147405565178 | 1 | 2024-07-08 18:18:45 |
|---|
level = 2, file count = 2, total zip = 0.061 GB, raw = 0.076 GB, over prev level: zip = 4.364191, raw = 5.929097
| 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 |
|---|
| 12636167 | 🟢 | 0.047306 | 0.062500 | 335545 | 0 | 0 | 0 | 1 | 0.002323 | 0.044392 | 5.0% | 0.005000 | 0.057500 | 8.0% | 46.5% | 77.2% | 74.7% | 7.4 | 16.0 | 142.1 | 184.0 | FlatZip | 147367996785 | 147404499886 | 5 | 18197:8000007D | 147402662983 | 1 | 18197:80FAE219 | 147402329069 | 1 | 2024-07-08 18:17:00 |
|---|
| 12636168 | 🟢 | 0.013240 | 0.013635 | 73201 | 0 | 0 | 0 | 1 | 0.000695 | 0.012544 | 5.2% | 0.001091 | 0.012544 | 8.0% | 63.7% | 100.0% | 97.1% | 10.2 | 16.0 | 184.0 | 184.0 | FlatZip | 147394038583 | 147404499878 | 4 | 18197:80FAE22A | 147394106144 | 1 | 18197:81312CE8 | 147397424945 | 1 | 2024-07-08 18:17:04 |
|---|
| sum | 2 | 0.060547 | 0.076135 | 408746 | 0 | 0 | 0 | 2 | 0.003018 | 0.056936 | 5.0% | 0.006091 | 0.070044 | 8.0% | 49.5% | 81.3% | 78.7% | 7.9 | 16.0 | 149.6 | 184.0 | FlatZip | 147367996785 | 147404499886 | 0 | 18197:8000007D | 147402662983 | 1 | 18197:81312CE8 | 147397424945 | 1 | 2024-07-08 18:17:00 |
|---|
|
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 |
|---|
| 12636025 | 147270612254 | 147401034964 | 0.095372 | 0.095372 | 18197:8000002C | 147401033442 | 1 | 18197:8056BE6E | 147316868943 | 1 | 671089 | 0 | 0.010737 | 0.123480 | 0 | | 12636026 | 147241136056 | 147401034795 | 0.094968 | 0.094968 | 18197:8056BE7D | 147317437653 | 1 | 18197:807CD9D0 | 147348867260 | 1 | 671089 | 0 | 0.010737 | 0.123480 | 0 | | 12636027 | 147241155168 | 147401034962 | 0.028368 | 0.028368 | 18197:807CD9D6 | 147291536637 | 1 | 18197:809D56E1 | 147384658728 | 1 | 149512 | 0 | 0.002392 | 0.027510 | 0 | | 12635635 | 147241136421 | 147394038377 | 0.095048 | 0.095048 | 18197:80AB7452 | 147299842589 | 1 | 18197:80D98294 | 147357901876 | 1 | 671089 | 0 | 0.010737 | 0.123480 | 0 | | 12635636 | 147329676621 | 147394038374 | 0.056996 | 0.056996 | 18197:80D98298 | 147385497935 | 1 | 18197:81312CE8 | 147384491209 | 1 | 384328 | 0 | 0.006149 | 0.070716 | 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 | 147406339404 |
| last_allocated_sequence | 147406339404 |
| last_published_sequence | 147176466927 |
| next_file_number | 12636321 |
| min_log_number_to_keep | 12636279 |
| manifest_file_number | 12625661 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 5818 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.909430 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 147367996785 |
| earliest_write_conflict_snapshot | 147406339257 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18197:8000007D |
| largest_user_key | 18197:81312CE8 |
| existing_snapshots |
147406339257 |
|---|
| 147406339310 |
| 147406339367 |
| 147406339382 |
| extra_serde_files | |
| shutting_down | |
|
|---|