| overview |
| job_id | 19283 |
| 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 | 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-19283/att-00 |
|
|---|
| inputs |
all levels summary: version# 9902, file count = 3, total size = 0.097 GB, avg size = 0.032 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.013535 | 0.012519 | 67209 | 0 | 0 | 0 | 1 | 0.002017 | 0.011517 | 14.9% | 0.001001 | 0.011517 | 8.0% | 201.4% | 100.0% | 108.1% | 32.2 | 16.0 | 184.0 | 184.0 | SngFast | 190273525531 | 190275264183 | 0 | 18200:80000265 | 190274484907 | 1 | 18200:81312BF9 | 190274382054 | 1 | 2024-08-20 08:42:57 | 13.346 MiB | 12.819 MiB |
|---|
| L2 | 2 | 2 | 0.083538 | 0.099531 | 534352 | 0 | 0 | 0 | 2 | 0.004481 | 0.078463 | 5.4% | 0.007962 | 0.091568 | 8.0% | 56.3% | 85.7% | 83.3% | 9.0 | 16.0 | 157.7 | 184.0 | FlatZip | 190224979834 | 190273525184 | 0 | 18200:80000017 | 190273387431 | 1 | 18200:81312CEB | 190272326630 | 1 | 2024-08-20 08:41:34 | 41.639 MiB | 50.960 MiB |
|---|
| sum | 3 | 3 | 0.097072 | 0.112049 | 601561 | 0 | 0 | 0 | 3 | 0.006498 | 0.089980 | 6.7% | 0.008964 | 0.103086 | 8.0% | 72.5% | 87.3% | 86.1% | 11.6 | 16.0 | 160.6 | 184.0 | FlatZip=2
SngFast=1 | 190224979834 | 190275264183 | 0 | 18200:80000017 | 190273387431 | 1 | 18200:81312CEB | 190272326630 | 1 | 2024-08-20 08:41:34 | 32.208 MiB | 38.246 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 |
|---|
| 14651251 | 🟢 | 0.013535 | 0.012519 | 67209 | 0 | 0 | 0 | 1 | 0.002017 | 0.011517 | 14.9% | 0.001001 | 0.011517 | 8.0% | 201.4% | 100.0% | 108.1% | 32.2 | 16.0 | 184.0 | 184.0 | SngFast | 190273525531 | 190275264183 | 4 | 18200:80000265 | 190274484907 | 1 | 18200:81312BF9 | 190274382054 | 1 | 2024-08-20 08:42:57 |
|---|
level = 2, file count = 2, total zip = 0.084 GB, raw = 0.100 GB, over prev level: zip = 6.172192, raw = 7.950602
| 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 |
|---|
| 14651180 | 🟢 | 0.047639 | 0.062500 | 335545 | 0 | 0 | 0 | 1 | 0.002653 | 0.044395 | 5.6% | 0.005000 | 0.057500 | 8.0% | 53.1% | 77.2% | 75.3% | 8.5 | 16.0 | 142.1 | 184.0 | FlatZip | 190230235103 | 190273525183 | 5 | 18200:80000017 | 190273387431 | 1 | 18200:80B499A5 | 190256762457 | 1 | 2024-08-20 08:41:34 |
|---|
| 14651182 | 🟢 | 0.035899 | 0.037031 | 198807 | 0 | 0 | 0 | 1 | 0.001828 | 0.034068 | 5.1% | 0.002962 | 0.034068 | 8.0% | 61.7% | 100.0% | 96.9% | 9.9 | 16.0 | 184.0 | 184.0 | FlatZip | 190224979834 | 190273525184 | 4 | 18200:80B499A9 | 190262802696 | 1 | 18200:81312CEB | 190272326630 | 1 | 2024-08-20 08:41:37 |
|---|
| sum | 2 | 0.083538 | 0.099531 | 534352 | 0 | 0 | 0 | 2 | 0.004481 | 0.078463 | 5.4% | 0.007962 | 0.091568 | 8.0% | 56.3% | 85.7% | 83.3% | 9.0 | 16.0 | 157.7 | 184.0 | FlatZip | 190224979834 | 190273525184 | 0 | 18200:80000017 | 190273387431 | 1 | 18200:81312CEB | 190272326630 | 1 | 2024-08-20 08:41:34 |
|---|
|
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 |
|---|
| 14650911 | 189864202019 | 190266741227 | 0.095189 | 0.095189 | 18200:803A60B7 | 190113419493 | 1 | 18200:806E5D98 | 190245248587 | 1 | 671089 | 0 | 0.010737 | 0.123480 | 0 | | 14650912 | 190109520012 | 190266741462 | 0.036365 | 0.036365 | 18200:806E5DA0 | 190213896445 | 1 | 18200:80A8C13D | 190232330734 | 1 | 236379 | 0 | 0.003782 | 0.043494 | 0 | | 14650570 | 189920824198 | 190257954926 | 0.094969 | 0.094969 | 18200:80B07E09 | 190068238298 | 1 | 18200:80CF16F3 | 190104854287 | 1 | 671089 | 0 | 0.010737 | 0.123480 | 0 | | 14651004 | 189995325888 | 190268500223 | 0.095252 | 0.095252 | 18200:80F22F35 | 190251650889 | 1 | 18200:812C8FFC | 190228505833 | 1 | 671089 | 0 | 0.010737 | 0.123480 | 0 | | 14651005 | 190209324985 | 190268499888 | 0.006398 | 0.006398 | 18200:812C8FFD | 190212610752 | 1 | 18200:81312CFE | 190255576628 | 1 | 33905 | 0 | 0.000542 | 0.006239 | 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 | 190275279933 |
| last_allocated_sequence | 190275279933 |
| last_published_sequence | 189793095786 |
| next_file_number | 14651274 |
| min_log_number_to_keep | 14651235 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 9900 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.993109 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 190224979834 |
| earliest_write_conflict_snapshot | 190275279777 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18200:80000017 |
| largest_user_key | 18200:81312CEB |
| existing_snapshots |
190275279777 |
|---|
| 190275279900 |
| 190275279922 |
| extra_serde_files | |
| shutting_down | |
|
|---|