| overview |
| job_id | 43789 |
| 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-43789/att-00 |
|
|---|
| inputs |
all levels summary: version# 22299, file count = 4, total size = 0.117 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.031222 | 0.030838 | 31930 | 0 | 0 | 0 | 1 | 0.000979 | 0.030243 | 3.1% | 0.000595 | 0.030243 | 1.9% | 164.5% | 100.0% | 101.2% | 32.9 | 20.0 | 1017.0 | 1017.0 | SngFast | 190889686258 | 190893158604 | 0 | 18265:800000A380014FDA | 190891845622 | 1 | 18265:800000B98000AD4F | 190892847534 | 1 | 2024-08-20 18:20:43 | 31.727 MiB | 31.578 MiB |
|---|
| L3 | 3 | 3 | 0.085966 | 0.264027 | 273384 | 0 | 0 | 0 | 3 | 0.002254 | 0.081006 | 2.7% | 0.005092 | 0.258935 | 1.9% | 44.3% | 31.3% | 31.5% | 8.9 | 20.0 | 318.2 | 1017.0 | FlatZip | 189798001762 | 190893158644 | 0 | 18265:800000228000B368 | 190892087135 | 1 | 18265:800000F7800020EC | 190892907747 | 1 | 2024-08-20 18:20:44 | 28.111 MiB | 90.121 MiB |
|---|
| sum | 4 | 4 | 0.117188 | 0.294865 | 305314 | 0 | 0 | 0 | 4 | 0.003233 | 0.111249 | 2.8% | 0.005687 | 0.289178 | 1.9% | 56.8% | 38.5% | 38.8% | 11.4 | 20.0 | 391.2 | 1017.0 | FlatZip=3
SngFast=1 | 189798001762 | 190893158644 | 0 | 18265:800000228000B368 | 190892087135 | 1 | 18265:800000F7800020EC | 190892907747 | 1 | 2024-08-20 18:20:43 | 29.015 MiB | 75.485 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 |
|---|
| 14679651 | 🟢 | 0.031222 | 0.030838 | 31930 | 0 | 0 | 0 | 1 | 0.000979 | 0.030243 | 3.1% | 0.000595 | 0.030243 | 1.9% | 164.5% | 100.0% | 101.2% | 32.9 | 20.0 | 1017.0 | 1017.0 | SngFast | 190889686258 | 190893158604 | 7 | 18265:800000A380014FDA | 190891845622 | 1 | 18265:800000B98000AD4F | 190892847534 | 1 | 2024-08-20 18:20:43 |
|---|
level = 3, file count = 3, total zip = 0.086 GB, raw = 0.264 GB, over prev level: zip = 2.753335, raw = 8.561809
| 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 |
|---|
| 14679662 | 🟢 | 0.040738 | 0.125001 | 129429 | 0 | 0 | 0 | 1 | 0.001185 | 0.038268 | 3.0% | 0.002411 | 0.122590 | 1.9% | 49.1% | 31.2% | 31.6% | 9.8 | 20.0 | 317.5 | 1017.0 | FlatZip | 189798001762 | 190893158545 | 7 | 18265:800000228000B368 | 190892087135 | 1 | 18265:800000A880004C35 | 190877813182 | 1 | 2024-08-20 18:20:44 |
|---|
| 14679663 | 🟢 | 0.004596 | 0.014026 | 14523 | 0 | 0 | 0 | 1 | 0.000048 | 0.004411 | 1.1% | 0.000271 | 0.013755 | 1.9% | 17.7% | 32.1% | 31.8% | 3.5 | 20.0 | 326.2 | 1017.0 | FlatZip | 190839941177 | 190889686001 | 10 | 18265:800000A880004C36 | 190875826268 | 1 | 18265:800000A88000AC9A | 190887897323 | 1 | 2024-08-20 18:20:46 |
|---|
| 14679673 | 🟢 | 0.040633 | 0.125000 | 129432 | 0 | 0 | 0 | 1 | 0.001022 | 0.038326 | 2.6% | 0.002411 | 0.122590 | 1.9% | 42.4% | 31.3% | 31.5% | 8.5 | 20.0 | 317.9 | 1017.0 | FlatZip | 190839942602 | 190893158644 | 7 | 18265:800000A88000AC9B | 190887670632 | 1 | 18265:800000F7800020EC | 190892907747 | 1 | 2024-08-20 18:20:48 |
|---|
| sum | 3 | 0.085966 | 0.264027 | 273384 | 0 | 0 | 0 | 3 | 0.002254 | 0.081006 | 2.7% | 0.005092 | 0.258935 | 1.9% | 44.3% | 31.3% | 31.5% | 8.9 | 20.0 | 318.2 | 1017.0 | FlatZip | 189798001762 | 190893158644 | 0 | 18265:800000228000B368 | 190892087135 | 1 | 18265:800000F7800020EC | 190892907747 | 1 | 2024-08-20 18:20:44 |
|---|
|
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 |
|---|
| 14679601 | 189652141705 | 190889685972 | 0.086825 | 0.086825 | 18265:80000019800128EB | 189916608793 | 1 | 18265:8000002A800044DA | 190750788495 | 1 | 258858 | 0 | 0.005177 | 0.263259 | 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 | | 14678614 | 189650558627 | 190867420214 | 0.018069 | 0.018069 | 18265:800000A28000C05C | 189948821307 | 1 | 18265:800000A38000CEAE | 190697197210 | 1 | 53324 | 0 | 0.001066 | 0.054230 | 0 | | 14677347 | 189650419945 | 190839934386 | 0.086886 | 0.086886 | 18265:800000A38000CEAF | 190689344851 | 1 | 18265:800000B48000EEB0 | 189790754603 | 1 | 258858 | 0 | 0.005177 | 0.263259 | 0 | | 14679103 | 189650398659 | 190877631320 | 0.086781 | 0.086781 | 18265:800000B48000EEB1 | 189786191944 | 1 | 18265:800000C280015E6B | 189788978831 | 1 | 258864 | 0 | 0.005177 | 0.263258 | 0 | | 14679104 | 189650399593 | 190877632919 | 0.086646 | 0.086646 | 18265:800000C280015E6C | 190728124432 | 1 | 18265:800000E580003AFC | 190625122327 | 1 | 258861 | 0 | 0.005177 | 0.263259 | 0 | | 14679105 | 189658696512 | 190874064483 | 0.000131 | 0.000131 | 18265:800000E580003B3A | 190581716956 | 1 | 18265:800000E580005BE2 | 190324994414 | 1 | 365 | 0 | 0.000007 | 0.000371 | 0 | | 14679008 | 189650412181 | 190874191208 | 0.033566 | 0.033566 | 18265:800000E580005C63 | 190832051005 | 1 | 18265:800000F780004624 | 190825352506 | 1 | 99426 | 0 | 0.001989 | 0.101117 | 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 | 190893381130 |
| last_allocated_sequence | 190893381130 |
| last_published_sequence | 189793095786 |
| next_file_number | 14679675 |
| min_log_number_to_keep | 14679593 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 22297 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.988121 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 189798001762 |
| earliest_write_conflict_snapshot | 190893380439 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18265:800000228000B368 |
| largest_user_key | 18265:800000F7800020EC |
| existing_snapshots |
190893380439 |
|---|
| 190893380624 |
| 190893380635 |
| 190893380967 |
| 190893380982 |
| 190893380993 |
| 190893381130 |
| extra_serde_files | |
| shutting_down | |
|
|---|