| overview |
| job_id | 59248 |
| 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-59248/att-00 |
|
|---|
| inputs |
all levels summary: version# 29854, file count = 4, total size = 0.098 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 |
|---|
| L2 | 2 | 2 | 0.033193 | 0.036802 | 38107 | 0 | 0 | 0 | 2 | 0.000979 | 0.032152 | 3.0% | 0.000710 | 0.036092 | 1.9% | 138.0% | 89.1% | 90.0% | 27.6 | 20.0 | 905.9 | 1017.0 | FlatZip=1
SngFast=1 | 191284984350 | 191286711357 | 0 | 18265:800000B980004863 | 191286600154 | 1 | 18265:8000010B80006763 | 191286649373 | 1 | 2024-08-21 01:26:56 | 16.834 MiB | 18.843 MiB |
|---|
| L3 | 2 | 2 | 0.065181 | 0.200074 | 207165 | 0 | 0 | 0 | 2 | 0.001747 | 0.061388 | 2.8% | 0.003859 | 0.196215 | 1.9% | 45.3% | 31.3% | 31.6% | 9.1 | 20.0 | 318.2 | 1017.0 | FlatZip | 191127184699 | 191286711264 | 0 | 18265:800000B98000C4D9 | 191283943148 | 1 | 18265:8000012C8001836B | 191220651333 | 1 | 2024-08-21 01:25:03 | 31.984 MiB | 102.438 MiB |
|---|
| sum | 4 | 4 | 0.098374 | 0.236876 | 245272 | 0 | 0 | 0 | 4 | 0.002726 | 0.093540 | 2.8% | 0.004569 | 0.232307 | 1.9% | 59.7% | 40.3% | 40.6% | 11.9 | 20.0 | 409.5 | 1017.0 | FlatZip=3
SngFast=1 | 191127184699 | 191286711357 | 0 | 18265:800000B980004863 | 191286600154 | 1 | 18265:8000012C8001836B | 191220651333 | 1 | 2024-08-21 01:25:03 | 24.409 MiB | 60.640 MiB |
|---|
level = 2, file count = 2, total zip = 0.033 GB, raw = 0.037 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 |
|---|
| 14697372 | 🟢 | 0.001970 | 0.005943 | 6153 | 0 | 0 | 0 | 1 | 0.000022 | 0.001888 | 1.1% | 0.000115 | 0.005828 | 1.9% | 18.8% | 32.4% | 32.1% | 3.8 | 20.0 | 329.5 | 1017.0 | FlatZip | 191284988467 | 191286711354 | 10 | 18265:800000B980004863 | 191286600154 | 1 | 18265:800000B98000EFFF | 191286690546 | 1 | 2024-08-21 01:27:02 |
|---|
| 14697344 | 🟢 | 0.031223 | 0.030859 | 31954 | 0 | 0 | 0 | 1 | 0.000958 | 0.030264 | 3.1% | 0.000595 | 0.030264 | 1.9% | 160.9% | 100.0% | 101.2% | 32.2 | 20.0 | 1017.0 | 1017.0 | SngFast | 191284984350 | 191286711357 | 6 | 18265:800000B98000F003 | 191286604231 | 1 | 18265:8000010B80006763 | 191286649373 | 1 | 2024-08-21 01:26:56 |
|---|
| sum | 2 | 0.033193 | 0.036802 | 38107 | 0 | 0 | 0 | 2 | 0.000979 | 0.032152 | 3.0% | 0.000710 | 0.036092 | 1.9% | 138.0% | 89.1% | 90.0% | 27.6 | 20.0 | 905.9 | 1017.0 | FlatZip=1
SngFast=1 | 191284984350 | 191286711357 | 0 | 18265:800000B980004863 | 191286600154 | 1 | 18265:8000010B80006763 | 191286649373 | 1 | 2024-08-21 01:26:56 |
|---|
level = 3, file count = 2, total zip = 0.065 GB, raw = 0.200 GB, over prev level: zip = 1.963701, raw = 5.436505
| 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 |
|---|
| 14697236 | 🟢 | 0.040617 | 0.125001 | 129432 | 0 | 0 | 0 | 1 | 0.001047 | 0.038284 | 2.7% | 0.002411 | 0.122590 | 1.9% | 43.4% | 31.2% | 31.5% | 8.7 | 20.0 | 317.6 | 1017.0 | FlatZip | 191127184699 | 191284984126 | 7 | 18265:800000B98000C4D9 | 191283943148 | 1 | 18265:800000F78000ACAC | 191277482498 | 1 | 2024-08-21 01:25:03 |
|---|
| 14697368 | 🟢 | 0.024564 | 0.075073 | 77733 | 0 | 0 | 0 | 1 | 0.000699 | 0.023104 | 2.9% | 0.001448 | 0.073625 | 1.9% | 48.3% | 31.4% | 31.7% | 9.7 | 20.0 | 319.1 | 1017.0 | FlatZip | 191192065010 | 191286711264 | 6 | 18265:800000F78000ACB2 | 191281377908 | 1 | 18265:8000012C8001836B | 191220651333 | 1 | 2024-08-21 01:27:00 |
|---|
| sum | 2 | 0.065181 | 0.200074 | 207165 | 0 | 0 | 0 | 2 | 0.001747 | 0.061388 | 2.8% | 0.003859 | 0.196215 | 1.9% | 45.3% | 31.3% | 31.6% | 9.1 | 20.0 | 318.2 | 1017.0 | FlatZip | 191127184699 | 191286711264 | 0 | 18265:800000B98000C4D9 | 191283943148 | 1 | 18265:8000012C8001836B | 191220651333 | 1 | 2024-08-21 01:25:03 |
|---|
|
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 |
|---|
| 14697264 | 189650398659 | 191284983113 | 0.086793 | 0.086793 | 18265:800000AA80002310 | 190432485760 | 1 | 18265:800000B980017B69 | 190961556382 | 1 | 258864 | 0 | 0.005177 | 0.263259 | 0 | | 14697265 | 189820356342 | 191206459893 | 0.000077 | 0.000077 | 18265:800000B980017B6A | 191081301607 | 1 | 18265:800000B980017C3C | 190904699710 | 1 | 211 | 0 | 0.000004 | 0.000215 | 0 | | 14697167 | 189799217967 | 191206515468 | 0.000560 | 0.000560 | 18265:800000B980017C3D | 191201076272 | 1 | 18265:800000B98001829A | 190956259470 | 1 | 1599 | 0 | 0.000032 | 0.001626 | 0 | | 14696174 | 189650497291 | 191134347843 | 0.001030 | 0.001030 | 18265:800000B98001829B | 191130364858 | 1 | 18265:800000BA80008984 | 190944191124 | 1 | 2914 | 0 | 0.000058 | 0.002964 | 0 | | 14694436 | 189650398772 | 191134335620 | 0.013243 | 0.013243 | 18265:800000BA80008988 | 189666566820 | 1 | 18265:800000C18000C329 | 191006866210 | 1 | 38966 | 0 | 0.000779 | 0.039627 | 0 | | 14690698 | 189650399593 | 191134349085 | 0.086607 | 0.086607 | 18265:800000C18000C32C | 190993616954 | 1 | 18265:800000DC800096A4 | 191118963155 | 1 | 258857 | 0 | 0.005177 | 0.263259 | 0 | | 14696699 | 189650408151 | 191269625106 | 0.086841 | 0.086841 | 18265:800000DC800096A5 | 191108454167 | 1 | 18265:800000F78000CC63 | 191269053145 | 1 | 258857 | 0 | 0.005177 | 0.263259 | 0 | | 14696700 | 189650424519 | 191269624748 | 0.087184 | 0.087184 | 18265:800000F78000CC64 | 191252343758 | 1 | 18265:8000010D80007C68 | 190908873441 | 1 | 258854 | 0 | 0.005177 | 0.263258 | 0 | | 14696701 | 189652404788 | 191185305838 | 0.000175 | 0.000175 | 18265:8000010D80007C78 | 189786782856 | 1 | 18265:8000010D80009F54 | 190448044286 | 1 | 489 | 0 | 0.000010 | 0.000497 | 0 | | 14696592 | 189650430237 | 191191768603 | 0.001697 | 0.001697 | 18265:8000010D80009F5C | 190289240429 | 1 | 18265:8000010E80006E23 | 190919574280 | 1 | 4807 | 0 | 0.000096 | 0.004890 | 0 | | 14695217 | 189650409033 | 191192050146 | 0.038135 | 0.038135 | 18265:8000010E80006E40 | 191000062833 | 1 | 18265:8000011480011EA6 | 190788973351 | 1 | 113127 | 0 | 0.002263 | 0.115053 | 0 | | 14693486 | 189650406054 | 191192050147 | 0.045132 | 0.045132 | 18265:8000011480011EDC | 191084755888 | 1 | 18265:8000012C80018663 | 190200441993 | 1 | 134308 | 0 | 0.002686 | 0.136586 | 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 | 191286982717 |
| last_allocated_sequence | 191286982717 |
| last_published_sequence | 189793095786 |
| next_file_number | 14697403 |
| min_log_number_to_keep | 14697302 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 29852 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.995629 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 191127184699 |
| earliest_write_conflict_snapshot | 191286981906 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18265:800000B980004863 |
| largest_user_key | 18265:8000012C8001836B |
| existing_snapshots |
191286981906 |
|---|
| 191286982467 |
| 191286982478 |
| 191286982511 |
| 191286982568 |
| 191286982684 |
| 191286982695 |
| 191286982706 |
| 191286982717 |
| extra_serde_files | |
| shutting_down | |
|
|---|