| overview |
| job_id | 61184 |
| 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 | 465QC0QPK7Q93426EREI |
|
|---|
| 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-61184/att-00 |
|
|---|
| inputs |
all levels summary: version# 31411, file count = 4, total size = 0.090 GB, avg size = 0.022 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.031035 | 0.031229 | 232935 | 0 | 0 | 0 | 1 | 0.005880 | 0.025154 | 18.9% | 0.006074 | 0.025154 | 19.5% | 96.8% | 100.0% | 99.4% | 27.1 | 28.0 | 116.0 | 116.0 | SngFast | 148747585032 | 148751388092 | 0 | 18263:8000001880000001800422E780000001 | 148747756676 | 1 | 18263:80000028800000048004B1DD80000007 | 148749917163 | 1 | 2024-07-09 21:56:12 | 30.002 MiB | 31.978 MiB |
|---|
| L2 | 3 | 3 | 0.058822 | 0.187500 | 1399218 | 0 | 0 | 0 | 3 | 0.006771 | 0.050521 | 11.8% | 0.036487 | 0.151013 | 19.5% | 18.6% | 33.5% | 30.6% | 5.2 | 28.0 | 38.8 | 115.9 | FlatZip | 148665970305 | 148747750999 | 0 | 18263:800000188000000180041FB480000001 | 148742326376 | 1 | 18263:8000002880000003800412328000000E | 148690719694 | 1 | 2024-07-09 21:50:41 | 18.091 MiB | 64.000 MiB |
|---|
| sum | 4 | 4 | 0.089857 | 0.218729 | 1632153 | 0 | 0 | 0 | 4 | 0.012651 | 0.075676 | 14.3% | 0.042562 | 0.176167 | 19.5% | 29.7% | 43.0% | 40.4% | 8.3 | 28.0 | 49.8 | 115.9 | FlatZip=3
SngFast=1 | 148665970305 | 148751388092 | 0 | 18263:800000188000000180041FB480000001 | 148742326376 | 1 | 18263:80000028800000048004B1DD80000007 | 148749917163 | 1 | 2024-07-09 21:50:41 | 21.069 MiB | 55.995 MiB |
|---|
level = 1, 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 |
|---|
| 12696758 | 🟢 | 0.031035 | 0.031229 | 232935 | 0 | 0 | 0 | 1 | 0.005880 | 0.025154 | 18.9% | 0.006074 | 0.025154 | 19.5% | 96.8% | 100.0% | 99.4% | 27.1 | 28.0 | 116.0 | 116.0 | SngFast | 148747585032 | 148751388092 | 7 | 18263:8000001880000001800422E780000001 | 148747756676 | 1 | 18263:80000028800000048004B1DD80000007 | 148749917163 | 1 | 2024-07-09 21:56:12 |
|---|
level = 2, file count = 3, total zip = 0.059 GB, raw = 0.188 GB, over prev level: zip = 1.895349, raw = 6.004131
| 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 |
|---|
| 12696698 | 🟢 | 0.019474 | 0.062500 | 466702 | 0 | 0 | 0 | 1 | 0.002246 | 0.016719 | 11.8% | 0.012170 | 0.050330 | 19.5% | 18.5% | 33.2% | 30.3% | 5.2 | 28.0 | 38.5 | 115.8 | FlatZip | 148694825443 | 148747750999 | 11 | 18263:800000188000000180041FB480000001 | 148742326376 | 1 | 18263:8000001880000009800498F680000005 | 148737749254 | 1 | 2024-07-09 21:50:41 |
|---|
| 12696699 | 🟢 | 0.019730 | 0.062500 | 465708 | 0 | 0 | 0 | 1 | 0.002290 | 0.016929 | 11.9% | 0.012144 | 0.050356 | 19.4% | 18.9% | 33.6% | 30.8% | 5.3 | 28.0 | 39.0 | 116.1 | FlatZip | 148665970305 | 148747750270 | 7 | 18263:8000001880000009800498F780000001 | 148737749769 | 1 | 18263:80000020800000068011C81280000003 | 148734955286 | 1 | 2024-07-09 21:50:43 |
|---|
| 12696700 | 🟢 | 0.019618 | 0.062500 | 466808 | 0 | 0 | 0 | 1 | 0.002235 | 0.016873 | 11.7% | 0.012173 | 0.050327 | 19.5% | 18.4% | 33.5% | 30.6% | 5.1 | 28.0 | 38.8 | 115.8 | FlatZip | 148689416927 | 148747748874 | 7 | 18263:80000020800000068011C81280000004 | 148734955287 | 1 | 18263:8000002880000003800412328000000E | 148690719694 | 1 | 2024-07-09 21:50:49 |
|---|
| sum | 3 | 0.058822 | 0.187500 | 1399218 | 0 | 0 | 0 | 3 | 0.006771 | 0.050521 | 11.8% | 0.036487 | 0.151013 | 19.5% | 18.6% | 33.5% | 30.6% | 5.2 | 28.0 | 38.8 | 115.9 | FlatZip | 148665970305 | 148747750999 | 0 | 18263:800000188000000180041FB480000001 | 148742326376 | 1 | 18263:8000002880000003800412328000000E | 148690719694 | 1 | 2024-07-09 21:50:41 |
|---|
|
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 |
|---|
| 12696478 | 148637400190 | 148742319013 | 0.038222 | 0.038222 | 18263:80000018800000018003E12880000001 | 148637400190 | 1 | 18263:800000188000000380047C7280000005 | 148694022570 | 1 | 931668 | 0 | 0.026087 | 0.108131 | 0 | | 12696479 | 148637400227 | 148742318533 | 0.038710 | 0.038710 | 18263:800000188000000380047C7280000006 | 148694022571 | 1 | 18263:8000001880000006800460AC80000008 | 148645503235 | 1 | 931670 | 0 | 0.026087 | 0.108131 | 0 | | 12696480 | 148637400281 | 148742302486 | 0.019796 | 0.019796 | 18263:8000001880000006800460AC80000009 | 148645503236 | 1 | 18263:80000018800000088003EB9F8000000E | 148654837888 | 1 | 467851 | 0 | 0.013100 | 0.054009 | 0 | | 12695484 | 148637400305 | 148709257370 | 0.020360 | 0.020360 | 18263:80000018800000088003EBA080000001 | 148654842002 | 1 | 18263:800000188000000A80046ED280000004 | 148663484733 | 1 | 466376 | 0 | 0.013059 | 0.054050 | 0 | | 12694648 | 148663484734 | 148663484735 | 0.000002 | 0.000002 | 18263:800000188000000A80046ED280000005 | 148663484734 | 1 | 18263:800000188000000A80046ED280000006 | 148663484735 | 1 | 2 | 0 | 0.000000 | 0.000000 | 0 | | 12695924 | 148637414535 | 148726233656 | 0.040824 | 0.040824 | 18263:800000188000000A80046ED280000007 | 148663484736 | 1 | 18263:8000002080000007800FF3FA80000006 | 148712485388 | 1 | 932826 | 0 | 0.026119 | 0.108099 | 0 | | 12695925 | 148637400505 | 148726233243 | 0.040310 | 0.040310 | 18263:8000002080000007800FF3FA80000007 | 148712485389 | 1 | 18263:8000002880000002800482BF80000004 | 148685606264 | 1 | 933210 | 0 | 0.026130 | 0.108088 | 0 | | 12694046 | 148685606265 | 148685606265 | 0.000002 | 0.000002 | 18263:8000002880000002800482BF80000005 | 148685606265 | 1 | 18263:8000002880000002800482BF80000005 | 148685606265 | 1 | 1 | 0 | 0.000000 | 0.000000 | 0 | | 12696728 | 148637399111 | 148747747657 | 0.038304 | 0.038304 | 18263:8000002880000002800482BF80000006 | 148685606266 | 1 | 18263:80000028800000058004723380000001 | 148657533056 | 1 | 930920 | 0 | 0.026066 | 0.108152 | 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 | 148751427368 |
| last_allocated_sequence | 148751427368 |
| last_published_sequence | 147176466927 |
| next_file_number | 12696794 |
| min_log_number_to_keep | 12696744 |
| manifest_file_number | 12625661 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 31409 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.955433 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 148665970305 |
| earliest_write_conflict_snapshot | 148751426780 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18263:800000188000000180041FB480000001 |
| largest_user_key | 18263:80000028800000048004B1DD80000007 |
| existing_snapshots |
148751426780 |
|---|
| 148751427280 |
| 148751427291 |
| 148751427357 |
| 148751427368 |
| extra_serde_files | |
| shutting_down | |
|
|---|