| overview |
| job_id | 46663 |
| 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-46663/att-00 |
|
|---|
| inputs |
all levels summary: version# 23746, file count = 4, total size = 0.114 GB, avg size = 0.029 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.031223 | 0.030820 | 31910 | 0 | 0 | 0 | 1 | 0.000996 | 0.030226 | 3.2% | 0.000594 | 0.030226 | 1.9% | 167.6% | 100.0% | 101.3% | 33.5 | 20.0 | 1017.1 | 1017.1 | SngFast | 190958905723 | 190962367334 | 0 | 18265:800000228000B5EA | 190961748793 | 1 | 18265:800000A380014C3F | 190960278990 | 1 | 2024-08-20 19:32:43 | 31.728 MiB | 31.560 MiB |
|---|
| L3 | 3 | 3 | 0.083194 | 0.255381 | 264426 | 0 | 0 | 0 | 3 | 0.002300 | 0.078268 | 2.9% | 0.004925 | 0.250455 | 1.9% | 46.7% | 31.3% | 31.5% | 9.3 | 20.0 | 317.8 | 1017.0 | FlatZip | 189798001762 | 190962367377 | 0 | 18265:8000000180000742 | 190954497500 | 1 | 18265:800000B980001719 | 190951341668 | 1 | 2024-08-20 19:32:45 | 27.185 MiB | 87.170 MiB |
|---|
| sum | 4 | 4 | 0.114417 | 0.286201 | 296336 | 0 | 0 | 0 | 4 | 0.003296 | 0.108494 | 2.9% | 0.005520 | 0.280681 | 1.9% | 59.7% | 38.7% | 39.1% | 11.9 | 20.0 | 393.1 | 1017.0 | FlatZip=3
SngFast=1 | 189798001762 | 190962367377 | 0 | 18265:8000000180000742 | 190954497500 | 1 | 18265:800000B980001719 | 190951341668 | 1 | 2024-08-20 19:32:43 | 28.321 MiB | 73.267 MiB |
|---|
level = 2, file count = 1, total zip = 0.031 GB, raw = 0.031 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 |
|---|
| 14682908 | 🟢 | 0.031223 | 0.030820 | 31910 | 0 | 0 | 0 | 1 | 0.000996 | 0.030226 | 3.2% | 0.000594 | 0.030226 | 1.9% | 167.6% | 100.0% | 101.3% | 33.5 | 20.0 | 1017.1 | 1017.1 | SngFast | 190958905723 | 190962367334 | 7 | 18265:800000228000B5EA | 190961748793 | 1 | 18265:800000A380014C3F | 190960278990 | 1 | 2024-08-20 19:32:43 |
|---|
level = 3, file count = 3, total zip = 0.083 GB, raw = 0.255 GB, over prev level: zip = 2.664551, raw = 8.286154
| 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 |
|---|
| 14682922 | 🟢 | 0.040735 | 0.125000 | 129428 | 0 | 0 | 0 | 1 | 0.001165 | 0.038284 | 3.0% | 0.002411 | 0.122589 | 1.9% | 48.3% | 31.2% | 31.6% | 9.7 | 20.0 | 317.6 | 1017.0 | FlatZip | 189798001762 | 190962367080 | 7 | 18265:8000000180000742 | 190954497500 | 1 | 18265:8000004280004861 | 189878002147 | 1 | 2024-08-20 19:32:45 |
|---|
| 14682923 | 🟢 | 0.001816 | 0.005380 | 5570 | 0 | 0 | 0 | 1 | 0.000068 | 0.001693 | 3.9% | 0.000104 | 0.005276 | 1.9% | 65.7% | 32.1% | 32.7% | 13.1 | 20.0 | 326.3 | 1017.1 | FlatZip | 189798654284 | 190958829297 | 7 | 18265:80000042800048E2 | 190723276269 | 1 | 18265:8000004580008054 | 190803323424 | 1 | 2024-08-20 19:32:50 |
|---|
| 14682959 | 🟢 | 0.040643 | 0.125000 | 129428 | 0 | 0 | 0 | 1 | 0.001066 | 0.038292 | 2.7% | 0.002411 | 0.122590 | 1.9% | 44.2% | 31.2% | 31.5% | 8.8 | 20.0 | 317.7 | 1017.0 | FlatZip | 190671153632 | 190962367377 | 7 | 18265:800000458000805C | 190875440984 | 1 | 18265:800000B980001719 | 190951341668 | 1 | 2024-08-20 19:32:58 |
|---|
| sum | 3 | 0.083194 | 0.255381 | 264426 | 0 | 0 | 0 | 3 | 0.002300 | 0.078268 | 2.9% | 0.004925 | 0.250455 | 1.9% | 46.7% | 31.3% | 31.5% | 9.3 | 20.0 | 317.8 | 1017.0 | FlatZip | 189798001762 | 190962367377 | 0 | 18265:8000000180000742 | 190954497500 | 1 | 18265:800000B980001719 | 190951341668 | 1 | 2024-08-20 19:32:45 |
|---|
|
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 |
|---|
| 14682117 | 189652114988 | 190943374250 | 0.086816 | 0.086816 | 18265:8000000180000043 | 190486645115 | 1 | 18265:800000188001804C | 190086468530 | 1 | 258860 | 0 | 0.005177 | 0.263259 | 0 | | 14682118 | 189652141705 | 190943397584 | 0.086831 | 0.086831 | 18265:800000188001805E | 190587466089 | 1 | 18265:8000002980000A7F | 189936870042 | 1 | 258857 | 0 | 0.005177 | 0.263258 | 0 | | 14682119 | 189652933788 | 190841650082 | 0.001724 | 0.001724 | 18265:8000002980000A83 | 189895762710 | 1 | 18265:8000002A80002943 | 190382146924 | 1 | 4887 | 0 | 0.000098 | 0.004970 | 0 | | 14679711 | 189655985296 | 190841068442 | 0.000122 | 0.000122 | 18265:8000002A8000294F | 190695009754 | 1 | 18265:8000002A800044DA | 190750788495 | 1 | 335 | 0 | 0.000007 | 0.000341 | 0 | | 14679602 | 189652602071 | 190841682579 | 0.001567 | 0.001567 | 18265:8000002A800044E3 | 190663821122 | 1 | 18265:8000002B8000334C | 190538887375 | 1 | 4433 | 0 | 0.000089 | 0.004508 | 0 | | 14677521 | 189652153279 | 190841700241 | 0.008304 | 0.008304 | 18265:8000002B80003353 | 190303495832 | 1 | 18265:800000308000DA04 | 189838207455 | 1 | 24207 | 0 | 0.000484 | 0.024619 | 2024-08-20 17:31:58 | | 14669812 | 189650404365 | 190676351780 | 0.067868 | 0.067868 | 18265:800000308000DA2A | 190042623293 | 1 | 18265:8000004180018432 | 189746640501 | 1 | 201545 | 0 | 0.004031 | 0.204969 | 0 | | 14678612 | 189650408341 | 190867394137 | 0.086686 | 0.086686 | 18265:8000004180018433 | 189781151419 | 1 | 18265:8000006A8000870E | 190192202214 | 1 | 258852 | 0 | 0.005177 | 0.263259 | 0 | | 14678613 | 189650409518 | 190867419259 | 0.086678 | 0.086678 | 18265:8000006A80008723 | 190099225970 | 1 | 18265:800000A28000C02C | 189924527967 | 1 | 258864 | 0 | 0.005177 | 0.263259 | 0 | | 14682242 | 189650419945 | 190948636622 | 0.086903 | 0.086903 | 18265:800000A28000C05C | 189948821307 | 1 | 18265:800000B28000EC68 | 190061798399 | 1 | 258859 | 0 | 0.005177 | 0.263259 | 0 | | 14682243 | 189650640610 | 190890990859 | 0.000072 | 0.000072 | 18265:800000B28000EC82 | 189676577633 | 1 | 18265:800000B28000FE63 | 190576037080 | 1 | 195 | 0 | 0.000004 | 0.000198 | 0 | | 14682224 | 189651289393 | 190897494510 | 0.000273 | 0.000273 | 18265:800000B28000FE68 | 189793468367 | 1 | 18265:800000B280013EE2 | 190413431584 | 1 | 770 | 0 | 0.000015 | 0.000783 | 0 | | 14679958 | 189650398659 | 190898347618 | 0.086780 | 0.086780 | 18265:800000B280013EEC | 190163654570 | 1 | 18265:800000C28000506E | 189792178935 | 1 | 258864 | 0 | 0.005177 | 0.263259 | 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 | 190962712393 |
| last_allocated_sequence | 190962712393 |
| last_published_sequence | 189793095786 |
| next_file_number | 14682963 |
| min_log_number_to_keep | 14682873 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 23744 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.998255 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 189798001762 |
| earliest_write_conflict_snapshot | 190962712142 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18265:8000000180000742 |
| largest_user_key | 18265:800000B980001719 |
| existing_snapshots |
190962712142 |
|---|
| 190962712299 |
| 190962712360 |
| 190962712371 |
| 190962712382 |
| 190962712393 |
| extra_serde_files | |
| shutting_down | |
|
|---|