| overview |
| job_id | 31804 |
| 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-31804/att-00 |
|
|---|
| inputs |
all levels summary: version# 16267, file count = 4, total size = 0.077 GB, avg size = 0.019 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.022789 | 0.022871 | 170670 | 0 | 0 | 0 | 1 | 0.004367 | 0.018421 | 19.2% | 0.004451 | 0.018421 | 19.5% | 98.1% | 100.0% | 99.6% | 27.5 | 28.0 | 115.9 | 115.9 | SngFast | 190589699638 | 190591468333 | 0 | 18263:800000B98000000280025F608000000D | 190591317876 | 1 | 18263:8000010B8000000780025BD280000003 | 190589917389 | 1 | 2024-08-20 13:23:35 | 22.033 MiB | 23.420 MiB |
|---|
| L2 | 3 | 3 | 0.053831 | 0.167792 | 1252498 | 0 | 0 | 0 | 3 | 0.006028 | 0.046426 | 11.5% | 0.032661 | 0.135131 | 19.5% | 18.5% | 34.4% | 31.3% | 5.2 | 28.0 | 39.8 | 115.8 | FlatZip | 190552803361 | 190589699491 | 0 | 18263:800000B98000000280021D458000000E | 190587731707 | 1 | 18263:8000010B8000000A800258CB80000006 | 190589691774 | 1 | 2024-08-20 13:22:20 | 16.610 MiB | 57.273 MiB |
|---|
| sum | 4 | 4 | 0.076620 | 0.190664 | 1423168 | 0 | 0 | 0 | 4 | 0.010395 | 0.064847 | 13.8% | 0.037112 | 0.153552 | 19.5% | 28.0% | 42.2% | 39.5% | 7.8 | 28.0 | 48.9 | 115.9 | FlatZip=3
SngFast=1 | 190552803361 | 190591468333 | 0 | 18263:800000B98000000280021D458000000E | 190587731707 | 1 | 18263:8000010B8000000A800258CB80000006 | 190589691774 | 1 | 2024-08-20 13:22:20 | 17.966 MiB | 48.810 MiB |
|---|
level = 1, file count = 1, total zip = 0.023 GB, raw = 0.023 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 |
|---|
| 14665896 | 🟢 | 0.022789 | 0.022871 | 170670 | 0 | 0 | 0 | 1 | 0.004367 | 0.018421 | 19.2% | 0.004451 | 0.018421 | 19.5% | 98.1% | 100.0% | 99.6% | 27.5 | 28.0 | 115.9 | 115.9 | SngFast | 190589699638 | 190591468333 | 6 | 18263:800000B98000000280025F608000000D | 190591317876 | 1 | 18263:8000010B8000000780025BD280000003 | 190589917389 | 1 | 2024-08-20 13:23:35 |
|---|
level = 2, file count = 3, total zip = 0.054 GB, raw = 0.168 GB, over prev level: zip = 2.362148, raw = 7.336349
| 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 |
|---|
| 14665855 | 🟢 | 0.019639 | 0.062500 | 466191 | 0 | 0 | 0 | 1 | 0.002243 | 0.016886 | 11.7% | 0.012157 | 0.050343 | 19.5% | 18.5% | 33.5% | 30.6% | 5.2 | 28.0 | 38.9 | 116.0 | FlatZip | 190552803888 | 190589697863 | 11 | 18263:800000B98000000280021D458000000E | 190587731707 | 1 | 18263:800000B98000000A800253D680000008 | 190572810639 | 1 | 2024-08-20 13:22:20 |
|---|
| 14665856 | 🟢 | 0.020023 | 0.062500 | 466632 | 0 | 0 | 0 | 1 | 0.002246 | 0.017267 | 11.5% | 0.012168 | 0.050332 | 19.5% | 18.5% | 34.3% | 31.2% | 5.2 | 28.0 | 39.7 | 115.8 | FlatZip | 190552803527 | 190589699352 | 7 | 18263:800000B98000000A800253D680000009 | 190572810640 | 1 | 18263:800000F780000003800E81948000000A | 190588965385 | 1 | 2024-08-20 13:22:21 |
|---|
| 14665857 | 🟢 | 0.014169 | 0.042792 | 319675 | 0 | 0 | 0 | 1 | 0.001539 | 0.012272 | 11.1% | 0.008336 | 0.034456 | 19.5% | 18.5% | 35.6% | 32.3% | 5.2 | 28.0 | 41.2 | 115.7 | FlatZip | 190552803361 | 190589699491 | 6 | 18263:800000F780000003800E81948000000B | 190588965386 | 1 | 18263:8000010B8000000A800258CB80000006 | 190589691774 | 1 | 2024-08-20 13:22:23 |
|---|
| sum | 3 | 0.053831 | 0.167792 | 1252498 | 0 | 0 | 0 | 3 | 0.006028 | 0.046426 | 11.5% | 0.032661 | 0.135131 | 19.5% | 18.5% | 34.4% | 31.3% | 5.2 | 28.0 | 39.8 | 115.8 | FlatZip | 190552803361 | 190589699491 | 0 | 18263:800000B98000000280021D458000000E | 190587731707 | 1 | 18263:8000010B8000000A800258CB80000006 | 190589691774 | 1 | 2024-08-20 13:22:20 |
|---|
|
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 |
|---|
| 14665659 | 189724223277 | 190586135161 | 0.032537 | 0.032537 | 18263:800000B4800000048000B2C380000004 | 189770027191 | 1 | 18263:800000B9800000038002183D8000000F | 190579619845 | 1 | 778486 | 0 | 0.021798 | 0.091016 | 0 | | 14665542 | 190427162050 | 190582600494 | 0.038719 | 0.038719 | 18263:800000B980000003800218EB80000006 | 190580705184 | 1 | 18263:800000B9800000078001CC218000000C | 190458994654 | 1 | 932837 | 0 | 0.026119 | 0.108098 | 0 | | 14664177 | 189706194419 | 190552799604 | 0.039325 | 0.039325 | 18263:800000B9800000098002067280000007 | 190550635419 | 1 | 18263:800000DC800000018001B44280000006 | 190422228442 | 1 | 925969 | 0 | 0.025927 | 0.108291 | 0 | | 14665762 | 190472317207 | 190587917581 | 0.039604 | 0.039604 | 18263:800000DC8000000180020FE580000005 | 190566067966 | 1 | 18263:800000DC80000005800220E88000000B | 190503059920 | 1 | 931301 | 0 | 0.026076 | 0.108141 | 0 | | 14665763 | 190441248923 | 190587917038 | 0.033098 | 0.033098 | 18263:800000DC80000005800220E88000000C | 190503059921 | 1 | 18263:800000DC8000000980020EF480000005 | 190564579008 | 1 | 783854 | 0 | 0.021948 | 0.090789 | 0 | | 14664361 | 190303065801 | 190552802663 | 0.039613 | 0.039613 | 18263:800000DC800000098002263C80000006 | 190512229749 | 1 | 18263:800000F7800000058010234480000005 | 190550995007 | 1 | 929912 | 0 | 0.026038 | 0.108180 | 0 | | 14665853 | 190444682033 | 190587916799 | 0.040068 | 0.040068 | 18263:800000F78000000A800E7C1C80000003 | 190566830641 | 1 | 18263:8000010B80000006800212DF80000005 | 190575262557 | 1 | 930441 | 0 | 0.026052 | 0.108165 | 0 | | 14665854 | 190504593427 | 190582599858 | 0.019100 | 0.019100 | 18263:8000010B80000006800212DF80000006 | 190575262558 | 1 | 18263:8000010B800000088002064080000007 | 190554909897 | 1 | 443488 | 0 | 0.012418 | 0.051286 | 0 | | 14665645 | 190435966858 | 190582600847 | 0.029431 | 0.029431 | 18263:8000010B800000088002064080000008 | 190554909898 | 1 | 18263:8000010B8000000A80024F1F8000000A | 190575851263 | 1 | 696767 | 0 | 0.019509 | 0.080909 | 0 | | 14665489 | 190575851264 | 190582578735 | 0.000689 | 0.000689 | 18263:8000010B8000000A80024F1F8000000B | 190575851264 | 1 | 18263:8000010B8000000A8002540780000008 | 190582578735 | 1 | 12448 | 0 | 0.000349 | 0.001419 | 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 | 190591489421 |
| last_allocated_sequence | 190591489421 |
| last_published_sequence | 189793095786 |
| next_file_number | 14665901 |
| min_log_number_to_keep | 14665770 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 16265 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.999782 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 190552803361 |
| earliest_write_conflict_snapshot | 190591488552 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18263:800000B98000000280021D458000000E |
| largest_user_key | 18263:8000010B8000000A800258CB80000006 |
| existing_snapshots |
190591488552 |
|---|
| 190591488563 |
| 190591489173 |
| 190591489229 |
| 190591489233 |
| 190591489399 |
| 190591489410 |
| 190591489421 |
| extra_serde_files | |
| shutting_down | |
|
|---|