| overview |
| job_id | 13073 |
| 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-13073/att-00 |
|
|---|
| inputs |
all levels summary: version# 6720, file count = 7, total size = 0.148 GB, avg size = 0.021 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.031170 | 232600 | 0 | 0 | 0 | 1 | 0.005930 | 0.025104 | 19.1% | 0.006066 | 0.025104 | 19.5% | 97.8% | 100.0% | 99.6% | 27.4 | 28.0 | 115.9 | 115.9 | SngFast | 190116297017 | 190117990047 | 0 | 18263:8000001C800000018000E9F480000001 | 190116298203 | 1 | 18263:800000B9800000028000EB158000000A | 190117897142 | 1 | 2024-08-20 06:35:19 | 30.005 MiB | 31.918 MiB |
|---|
| L2 | 6 | 6 | 0.116740 | 0.372151 | 2771492 | 0 | 0 | 0 | 6 | 0.013533 | 0.100164 | 11.9% | 0.072272 | 0.299879 | 19.4% | 18.7% | 33.4% | 30.6% | 5.2 | 28.0 | 38.8 | 116.2 | FlatZip | 189768092390 | 190116296851 | 0 | 18263:8000001C800000018000B7A980000001 | 190041845189 | 1 | 18263:800000B9800000038000E97280000001 | 190115597363 | 1 | 2024-08-20 06:34:25 | 17.936 MiB | 63.514 MiB |
|---|
| sum | 7 | 7 | 0.147775 | 0.403321 | 3004092 | 0 | 0 | 0 | 7 | 0.019464 | 0.125268 | 13.4% | 0.078338 | 0.324983 | 19.4% | 24.8% | 38.5% | 35.9% | 7.0 | 28.0 | 44.8 | 116.2 | FlatZip=6
SngFast=1 | 189768092390 | 190117990047 | 0 | 18263:8000001C800000018000B7A980000001 | 190041845189 | 1 | 18263:800000B9800000038000E97280000001 | 190115597363 | 1 | 2024-08-20 06:34:25 | 19.660 MiB | 59.000 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 |
|---|
| 14644087 | 🟢 | 0.031035 | 0.031170 | 232600 | 0 | 0 | 0 | 1 | 0.005930 | 0.025104 | 19.1% | 0.006066 | 0.025104 | 19.5% | 97.8% | 100.0% | 99.6% | 27.4 | 28.0 | 115.9 | 115.9 | SngFast | 190116297017 | 190117990047 | 7 | 18263:8000001C800000018000E9F480000001 | 190116298203 | 1 | 18263:800000B9800000028000EB158000000A | 190117897142 | 1 | 2024-08-20 06:35:19 |
|---|
level = 2, file count = 6, total zip = 0.117 GB, raw = 0.372 GB, over prev level: zip = 3.761527, raw = 11.939526
| 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 |
|---|
| 14644063 | 🟢 | 0.019114 | 0.062500 | 463658 | 0 | 0 | 0 | 1 | 0.002279 | 0.016323 | 12.3% | 0.012091 | 0.050409 | 19.3% | 18.9% | 32.4% | 29.8% | 5.3 | 28.0 | 37.8 | 116.7 | FlatZip | 190041845189 | 190116293839 | 11 | 18263:8000001C800000018000B7A980000001 | 190041845189 | 1 | 18263:8000001C800000038000CECC80000008 | 190076189383 | 1 | 2024-08-20 06:34:25 |
|---|
| 14644064 | 🟢 | 0.020112 | 0.062500 | 466044 | 0 | 0 | 0 | 1 | 0.002237 | 0.017363 | 11.4% | 0.012153 | 0.050347 | 19.4% | 18.4% | 34.5% | 31.4% | 5.2 | 28.0 | 40.0 | 116.0 | FlatZip | 190076189384 | 190116296430 | 7 | 18263:8000001C800000038000CECC80000009 | 190076189384 | 1 | 18263:80000022800000038000FFBC80000004 | 190110605114 | 1 | 2024-08-20 06:34:27 |
|---|
| 14644065 | 🟢 | 0.019711 | 0.062500 | 466680 | 0 | 0 | 0 | 1 | 0.002240 | 0.016962 | 11.7% | 0.012170 | 0.050330 | 19.5% | 18.4% | 33.7% | 30.7% | 5.2 | 28.0 | 39.0 | 115.8 | FlatZip | 190079068958 | 190116295106 | 11 | 18263:80000022800000038000FFBC80000005 | 190110605115 | 1 | 18263:800000228000000A8000F94C80000008 | 190102072480 | 1 | 2024-08-20 06:34:28 |
|---|
| 14644066 | 🟢 | 0.018883 | 0.062500 | 463277 | 0 | 0 | 0 | 1 | 0.002391 | 0.015979 | 13.0% | 0.012081 | 0.050419 | 19.3% | 19.8% | 31.7% | 29.4% | 5.5 | 28.0 | 37.0 | 116.9 | FlatZip | 189768092390 | 190116296200 | 7 | 18263:800000228000000A8000F94C80000009 | 190102072481 | 1 | 18263:800000A380000002800103208000000E | 190111890189 | 1 | 2024-08-20 06:34:30 |
|---|
| 14644067 | 🟢 | 0.019796 | 0.062500 | 466358 | 0 | 0 | 0 | 1 | 0.002190 | 0.017097 | 11.4% | 0.012161 | 0.050339 | 19.5% | 18.0% | 34.0% | 30.9% | 5.0 | 28.0 | 39.4 | 115.9 | FlatZip | 190093920960 | 190116296851 | 11 | 18263:800000A380000002800103208000000F | 190111890190 | 1 | 18263:800000A38000000A8000FFE680000006 | 190110778865 | 1 | 2024-08-20 06:34:31 |
|---|
| 14644068 | 🟢 | 0.019124 | 0.059651 | 445475 | 0 | 0 | 0 | 1 | 0.002196 | 0.016438 | 11.8% | 0.011617 | 0.048034 | 19.5% | 18.9% | 34.2% | 31.2% | 5.3 | 28.0 | 39.6 | 115.8 | FlatZip | 190005768370 | 190116296585 | 7 | 18263:800000A38000000A8000FFE680000007 | 190110778866 | 1 | 18263:800000B9800000038000E97280000001 | 190115597363 | 1 | 2024-08-20 06:34:34 |
|---|
| sum | 6 | 0.116740 | 0.372151 | 2771492 | 0 | 0 | 0 | 6 | 0.013533 | 0.100164 | 11.9% | 0.072272 | 0.299879 | 19.4% | 18.7% | 33.4% | 30.6% | 5.2 | 28.0 | 38.8 | 116.2 | FlatZip | 189768092390 | 190116296851 | 0 | 18263:8000001C800000018000B7A980000001 | 190041845189 | 1 | 18263:800000B9800000038000E97280000001 | 190115597363 | 1 | 2024-08-20 06:34:25 |
|---|
|
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 |
|---|
| 14640739 | 189703638130 | 190041837695 | 0.041026 | 0.041026 | 18263:8000000E800000098000875580000008 | 189742643039 | 1 | 18263:8000001C800000018000C44580000004 | 190029809607 | 1 | 926217 | 0 | 0.025934 | 0.108284 | 0 | | 14643634 | 189974433765 | 190107826000 | 0.039716 | 0.039716 | 18263:8000001C800000018000C44580000005 | 190029809608 | 1 | 18263:8000001C8000000780009CD280000006 | 190002392621 | 1 | 928205 | 0 | 0.025990 | 0.108228 | 0 | | 14643748 | 189907031157 | 190107826055 | 0.039377 | 0.039377 | 18263:8000001C800000088000E38880000005 | 190106720558 | 1 | 18263:80000022800000018000F58D80000007 | 190097843349 | 1 | 926763 | 0 | 0.025949 | 0.108268 | 0 | | 14643750 | 190029649737 | 190107821555 | 0.012085 | 0.012085 | 18263:80000022800000018000F58D80000008 | 190097843350 | 1 | 18263:80000022800000038000C74F80000005 | 190071202803 | 1 | 261527 | 0 | 0.007323 | 0.030622 | 0 | | 14643077 | 189919094276 | 190093917463 | 0.040200 | 0.040200 | 18263:80000022800000038000C74F80000006 | 190071202804 | 1 | 18263:80000022800000078000D39D80000002 | 190089937289 | 1 | 927695 | 0 | 0.025975 | 0.108242 | 0 | | 14643423 | 190062046918 | 190102625305 | 0.009945 | 0.009945 | 18263:80000022800000078000D6F38000000A | 190094938940 | 1 | 18263:800000228000000A8000E89580000007 | 190079068957 | 1 | 213697 | 0 | 0.005984 | 0.024794 | 0 | | 14638277 | 189689290795 | 189793092486 | 0.040063 | 0.040063 | 18263:8000003C800000038003031080000005 | 189788892406 | 1 | 18263:800000468000000480009B1480000004 | 189768092389 | 1 | 877414 | 0 | 0.024568 | 0.101803 | 0 | | 14637899 | 189747081125 | 189976173861 | 0.041239 | 0.041239 | 18263:800000468000000480009C5B80000002 | 189769778009 | 1 | 18263:800000A38000000280003F5980000003 | 189869884659 | 1 | 926700 | 0 | 0.025948 | 0.108270 | 0 | | 14643436 | 189965751958 | 190102625011 | 0.040567 | 0.040567 | 18263:800000A3800000048000F55080000003 | 190095689043 | 1 | 18263:800000A88000000180034DDD80000001 | 190088082556 | 1 | 928801 | 0 | 0.026006 | 0.108211 | 0 | | 14643841 | 190024444127 | 190111201726 | 0.039535 | 0.039535 | 18263:800000A88000000180034DDD80000002 | 190088082557 | 1 | 18263:800000A88000000680033FFC80000001 | 190057616063 | 1 | 933175 | 0 | 0.026129 | 0.108089 | 0 | | 14643842 | 189724223277 | 190111201193 | 0.040416 | 0.040416 | 18263:800000A88000000680033FFC80000002 | 190057616064 | 1 | 18263:800000B4800000058000851180000006 | 189737160851 | 1 | 934813 | 0 | 0.026175 | 0.108043 | 0 | | 14643843 | 189737160852 | 189969865355 | 0.004855 | 0.004855 | 18263:800000B4800000058000851180000007 | 189737160852 | 1 | 18263:800000B9800000018000862580000005 | 189969865355 | 1 | 97557 | 0 | 0.002732 | 0.011512 | 0 | | 14643304 | 190048815534 | 190099144647 | 0.040133 | 0.040133 | 18263:800000B9800000018000C3BF80000004 | 190059828873 | 1 | 18263:800000B9800000078000BE5080000005 | 190051817255 | 1 | 930911 | 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 | 190118012875 |
| last_allocated_sequence | 190118012875 |
| last_published_sequence | 189793095786 |
| next_file_number | 14644104 |
| min_log_number_to_keep | 14644061 |
| manifest_file_number | 14629260 |
| options_file_number | 0 |
| prev_log_number | 0 |
| current_version_number | 6718 |
|
|---|
| Others |
| allow_ingest_behind | false |
| preserve_deletes | false |
| bottommost_level | false |
| is_deserialized | true |
| score | 0.995093 |
| preserve_deletes_seqnum | 0 |
| smallest_seqno | 189768092390 |
| earliest_write_conflict_snapshot | 190118012619 |
| paranoid_file_checks | false |
| full_history_ts_low | |
| smallest_user_key | 18263:8000001C800000018000B7A980000001 |
| largest_user_key | 18263:800000B9800000038000E97280000001 |
| existing_snapshots |
190118012619 |
|---|
| 190118012753 |
| 190118012774 |
| 190118012830 |
| 190118012838 |
| 190118012864 |
| 190118012875 |
| extra_serde_files | |
| shutting_down | |
|
|---|