ceremonyclient/pebble/testdata/metrics

721 lines
32 KiB
Plaintext
Raw Permalink Normal View History

2024-01-03 07:31:42 +00:00
example
----
| | | | ingested | moved | written | | amp | multilevel
level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w | top in read
------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+----------+------------------
0 | 101 102B 0B 101 | 103.0 | 104B | 112 104B | 113 106B | 221 217B | 107B | 1 2.1 | 104B 104B 104B
1 | 201 202B 0B 201 | 203.0 | 204B | 212 204B | 213 206B | 421 417B | 207B | 2 2.0 | 204B 204B 204B
2 | 301 302B 0B 301 | 303.0 | 304B | 312 304B | 313 306B | 621 617B | 307B | 3 2.0 | 304B 304B 304B
3 | 401 402B 0B 401 | 403.0 | 404B | 412 404B | 413 406B | 821 817B | 407B | 4 2.0 | 404B 404B 404B
4 | 501 502B 0B 501 | 503.0 | 504B | 512 504B | 513 506B | 1.0K 1017B | 507B | 5 2.0 | 504B 504B 504B
5 | 601 602B 0B 601 | 603.0 | 604B | 612 604B | 613 606B | 1.2K 1.2KB | 607B | 6 2.0 | 604B 604B 604B
6 | 701 702B 0B 701 | - | 704B | 712 704B | 713 706B | 1.4K 1.4KB | 707B | 7 2.0 | 704B 704B 704B
total | 2.8K 2.7KB 0B 2.8K | - | 2.8KB | 2.9K 2.8KB | 2.9K 2.8KB | 5.7K 8.4KB | 2.8KB | 28 3.0 | 2.8KB 2.8KB 2.8KB
---------------------------------------------------------------------------------------------------------------------------------------
WAL: 22 files (24B) in: 25B written: 26B (4% overhead)
Flushes: 8
Compactions: 5 estimated debt: 6B in progress: 2 (7B)
default: 27 delete: 28 elision: 29 move: 30 read: 31 rewrite: 32 multi-level: 33
MemTables: 12 (11B) zombie: 14 (13B)
Zombie tables: 16 (15B)
Backing tables: 1 (2.0MB)
Virtual tables: 2807 (2.8KB)
Block cache: 2 entries (1B) hit rate: 42.9%
Table cache: 18 entries (17B) hit rate: 48.7%
Secondary cache: 0 entries (0B) hit rate: 0.0%
Snapshots: 4 earliest seq num: 1024
Table iters: 21
Filter utility: 47.4%
Ingestions: 27 as flushable: 36 (34B in 35 tables)
batch
set a 1
----
iter-new a category=a qos=non-latency
----
flush
----
0.0:
000005:[a#10,SET-a#10,SET]
# iter b references both a memtable and sstable 5.
iter-new b category=b qos=latency
----
metrics
----
| | | | ingested | moved | written | | amp
level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w
------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+---------
0 | 1 661B 0B 0 | 0.25 | 28B | 0 0B | 0 0B | 1 661B | 0B | 1 23.6
1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
6 | 0 0B 0B 0 | - | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
total | 1 661B 0B 0 | - | 56B | 0 0B | 0 0B | 1 717B | 0B | 1 12.8
-------------------------------------------------------------------------------------------------------------------
WAL: 1 files (28B) in: 17B written: 56B (229% overhead)
Flushes: 1
Compactions: 0 estimated debt: 0B in progress: 0 (0B)
default: 0 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0
MemTables: 1 (256KB) zombie: 1 (256KB)
Zombie tables: 0 (0B)
Backing tables: 0 (0B)
Virtual tables: 0 (0B)
Block cache: 3 entries (556B) hit rate: 0.0%
Table cache: 1 entries (800B) hit rate: 0.0%
Secondary cache: 0 entries (0B) hit rate: 0.0%
Snapshots: 0 earliest seq num: 0
Table iters: 1
Filter utility: 0.0%
Ingestions: 0 as flushable: 0 (0B in 0 tables)
disk-usage
----
1.9KB
batch
set b 2
----
flush
----
0.0:
000005:[a#10,SET-a#10,SET]
000007:[b#11,SET-b#11,SET]
# iter c references both a memtable and sstables 5 and 7.
iter-new c category=c qos=non-latency
----
compact a-z
----
6:
000008:[a#0,SET-b#0,SET]
metrics
----
| | | | ingested | moved | written | | amp
level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w
------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+---------
0 | 0 0B 0B 0 | 0.00 | 56B | 0 0B | 0 0B | 2 1.3KB | 0B | 0 23.6
1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
6 | 1 667B 0B 0 | - | 1.3KB | 0 0B | 0 0B | 1 667B | 1.3KB | 1 0.5
total | 1 667B 0B 0 | - | 84B | 0 0B | 0 0B | 3 2.0KB | 1.3KB | 1 24.7
-------------------------------------------------------------------------------------------------------------------
WAL: 1 files (28B) in: 34B written: 84B (147% overhead)
Flushes: 2
Compactions: 1 estimated debt: 0B in progress: 0 (0B)
default: 1 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0
MemTables: 1 (256KB) zombie: 2 (512KB)
Zombie tables: 2 (1.3KB)
Backing tables: 0 (0B)
Virtual tables: 0 (0B)
Block cache: 5 entries (1.1KB) hit rate: 42.9%
Table cache: 2 entries (1.6KB) hit rate: 66.7%
Secondary cache: 0 entries (0B) hit rate: 0.0%
Snapshots: 0 earliest seq num: 0
Table iters: 2
Filter utility: 0.0%
Ingestions: 0 as flushable: 0 (0B in 0 tables)
Iter category stats:
pebble-compaction, non-latency: {BlockBytes:132 BlockBytesInCache:88}
disk-usage
----
3.3KB
# Closing iter a will release one of the zombie memtables.
iter-close a
----
metrics
----
| | | | ingested | moved | written | | amp
level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w
------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+---------
0 | 0 0B 0B 0 | 0.00 | 56B | 0 0B | 0 0B | 2 1.3KB | 0B | 0 23.6
1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
6 | 1 667B 0B 0 | - | 1.3KB | 0 0B | 0 0B | 1 667B | 1.3KB | 1 0.5
total | 1 667B 0B 0 | - | 84B | 0 0B | 0 0B | 3 2.0KB | 1.3KB | 1 24.7
-------------------------------------------------------------------------------------------------------------------
WAL: 1 files (28B) in: 34B written: 84B (147% overhead)
Flushes: 2
Compactions: 1 estimated debt: 0B in progress: 0 (0B)
default: 1 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0
MemTables: 1 (256KB) zombie: 2 (512KB)
Zombie tables: 2 (1.3KB)
Backing tables: 0 (0B)
Virtual tables: 0 (0B)
Block cache: 5 entries (1.1KB) hit rate: 42.9%
Table cache: 2 entries (1.6KB) hit rate: 66.7%
Secondary cache: 0 entries (0B) hit rate: 0.0%
Snapshots: 0 earliest seq num: 0
Table iters: 2
Filter utility: 0.0%
Ingestions: 0 as flushable: 0 (0B in 0 tables)
Iter category stats:
pebble-compaction, non-latency: {BlockBytes:132 BlockBytesInCache:88}
# Closing iter c will release one of the zombie sstables. The other
# zombie sstable is still referenced by iter b.
iter-close c
----
metrics
----
| | | | ingested | moved | written | | amp
level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w
------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+---------
0 | 0 0B 0B 0 | 0.00 | 56B | 0 0B | 0 0B | 2 1.3KB | 0B | 0 23.6
1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
6 | 1 667B 0B 0 | - | 1.3KB | 0 0B | 0 0B | 1 667B | 1.3KB | 1 0.5
total | 1 667B 0B 0 | - | 84B | 0 0B | 0 0B | 3 2.0KB | 1.3KB | 1 24.7
-------------------------------------------------------------------------------------------------------------------
WAL: 1 files (28B) in: 34B written: 84B (147% overhead)
Flushes: 2
Compactions: 1 estimated debt: 0B in progress: 0 (0B)
default: 1 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0
MemTables: 1 (256KB) zombie: 2 (512KB)
Zombie tables: 1 (661B)
Backing tables: 0 (0B)
Virtual tables: 0 (0B)
Block cache: 3 entries (556B) hit rate: 42.9%
Table cache: 1 entries (800B) hit rate: 66.7%
Secondary cache: 0 entries (0B) hit rate: 0.0%
Snapshots: 0 earliest seq num: 0
Table iters: 1
Filter utility: 0.0%
Ingestions: 0 as flushable: 0 (0B in 0 tables)
Iter category stats:
c, non-latency: {BlockBytes:44 BlockBytesInCache:44}
pebble-compaction, non-latency: {BlockBytes:132 BlockBytesInCache:88}
disk-usage
----
2.7KB
# Closing iter b will release the last zombie sstable and the last zombie memtable.
iter-close b
----
metrics
----
| | | | ingested | moved | written | | amp
level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w
------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+---------
0 | 0 0B 0B 0 | 0.00 | 56B | 0 0B | 0 0B | 2 1.3KB | 0B | 0 23.6
1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
6 | 1 667B 0B 0 | - | 1.3KB | 0 0B | 0 0B | 1 667B | 1.3KB | 1 0.5
total | 1 667B 0B 0 | - | 84B | 0 0B | 0 0B | 3 2.0KB | 1.3KB | 1 24.7
-------------------------------------------------------------------------------------------------------------------
WAL: 1 files (28B) in: 34B written: 84B (147% overhead)
Flushes: 2
Compactions: 1 estimated debt: 0B in progress: 0 (0B)
default: 1 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0
MemTables: 1 (256KB) zombie: 1 (256KB)
Zombie tables: 0 (0B)
Backing tables: 0 (0B)
Virtual tables: 0 (0B)
Block cache: 0 entries (0B) hit rate: 42.9%
Table cache: 0 entries (0B) hit rate: 66.7%
Secondary cache: 0 entries (0B) hit rate: 0.0%
Snapshots: 0 earliest seq num: 0
Table iters: 0
Filter utility: 0.0%
Ingestions: 0 as flushable: 0 (0B in 0 tables)
Iter category stats:
b, latency: {BlockBytes:44 BlockBytesInCache:0}
c, non-latency: {BlockBytes:44 BlockBytesInCache:44}
pebble-compaction, non-latency: {BlockBytes:132 BlockBytesInCache:88}
disk-usage
----
2.0KB
additional-metrics
----
block bytes written:
__level___data-block__value-block
0 54B 0B
1 0B 0B
2 0B 0B
3 0B 0B
4 0B 0B
5 0B 0B
6 33B 0B
batch
set c@20 c20
set c@19 c19
set c@18 c18
set c@17 c17
set c@16 c16
set c@15 c15
set c@14 c14
----
flush
----
0.0:
000010:[c@20#12,SET-c@18#14,SET]
000011:[c@17#15,SET-c@15#17,SET]
000012:[c@14#18,SET-c@14#18,SET]
6:
000008:[a#0,SET-b#0,SET]
metrics
----
| | | | ingested | moved | written | | amp
level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w
------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+---------
0 | 3 2.2KB 38B 0 | 0.25 | 149B | 0 0B | 0 0B | 5 3.5KB | 0B | 1 24.2
1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
6 | 1 667B 0B 0 | - | 1.3KB | 0 0B | 0 0B | 1 667B | 1.3KB | 1 0.5
total | 4 2.9KB 38B 0 | - | 242B | 0 0B | 0 0B | 6 4.4KB | 1.3KB | 2 18.6
-------------------------------------------------------------------------------------------------------------------
WAL: 1 files (93B) in: 116B written: 242B (109% overhead)
Flushes: 3
Compactions: 1 estimated debt: 2.9KB in progress: 0 (0B)
default: 1 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0
MemTables: 1 (256KB) zombie: 1 (256KB)
Zombie tables: 0 (0B)
Backing tables: 0 (0B)
Virtual tables: 0 (0B)
Block cache: 0 entries (0B) hit rate: 42.9%
Table cache: 0 entries (0B) hit rate: 66.7%
Secondary cache: 0 entries (0B) hit rate: 0.0%
Snapshots: 0 earliest seq num: 0
Table iters: 0
Filter utility: 0.0%
Ingestions: 0 as flushable: 0 (0B in 0 tables)
Iter category stats:
b, latency: {BlockBytes:44 BlockBytesInCache:0}
c, non-latency: {BlockBytes:44 BlockBytesInCache:44}
pebble-compaction, non-latency: {BlockBytes:132 BlockBytesInCache:88}
additional-metrics
----
block bytes written:
__level___data-block__value-block
0 198B 38B
1 0B 0B
2 0B 0B
3 0B 0B
4 0B 0B
5 0B 0B
6 33B 0B
compact a-z
----
6:
000008:[a#0,SET-b#0,SET]
000013:[c@20#0,SET-c@16#0,SET]
000014:[c@15#0,SET-c@14#0,SET]
metrics
----
| | | | ingested | moved | written | | amp
level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w
------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+---------
0 | 0 0B 0B 0 | 0.00 | 149B | 0 0B | 0 0B | 5 3.5KB | 0B | 0 24.2
1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
6 | 3 2.2KB 41B 0 | - | 3.5KB | 0 0B | 0 0B | 3 2.2KB | 3.5KB | 1 0.6
total | 3 2.2KB 41B 0 | - | 242B | 0 0B | 0 0B | 8 6.0KB | 3.5KB | 1 25.3
-------------------------------------------------------------------------------------------------------------------
WAL: 1 files (93B) in: 116B written: 242B (109% overhead)
Flushes: 3
Compactions: 2 estimated debt: 0B in progress: 0 (0B)
default: 2 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0
MemTables: 1 (256KB) zombie: 1 (256KB)
Zombie tables: 0 (0B)
Backing tables: 0 (0B)
Virtual tables: 0 (0B)
Block cache: 0 entries (0B) hit rate: 27.3%
Table cache: 0 entries (0B) hit rate: 58.3%
Secondary cache: 0 entries (0B) hit rate: 0.0%
Snapshots: 0 earliest seq num: 0
Table iters: 0
Filter utility: 0.0%
Ingestions: 0 as flushable: 0 (0B in 0 tables)
Iter category stats:
b, latency: {BlockBytes:44 BlockBytesInCache:0}
c, non-latency: {BlockBytes:44 BlockBytesInCache:44}
pebble-compaction, non-latency: {BlockBytes:411 BlockBytesInCache:154}
additional-metrics
----
block bytes written:
__level___data-block__value-block
0 198B 38B
1 0B 0B
2 0B 0B
3 0B 0B
4 0B 0B
5 0B 0B
6 143B 41B
# Flushable ingestion metrics. This requires there be data in a memtable that
# would overlap with the ingested table(s). Delayed flushes are disabled here to
# prevent the ingestion from immediately triggering a flush of the memtable.
# Instead, we wish to flush manually _after_ the ingestion of the two tables has
# completed, linking the two tables into the flushable queue.
delay-flush
enable
----
batch
set d d
set e e
set f f
----
build ext1.sst
set d d
----
build ext2.sst
set e e
----
ingest ext1.sst ext2.sst
----
build ext3.sst
set f f
----
ingest ext3.sst
----
delay-flush
disable
----
flush
----
0.1:
000015:[d#22,SET-d#22,SET]
000016:[e#23,SET-e#23,SET]
000019:[f#24,SET-f#24,SET]
0.0:
000023:[d#19,SET-f#21,SET]
6:
000008:[a#0,SET-b#0,SET]
000013:[c@20#0,SET-c@16#0,SET]
000014:[c@15#0,SET-c@14#0,SET]
# We expect the ingested-as-flushable count to be three (one for each ingested
# table). The unknown category in the iter category stats is because of a gap
# in instrumentation for checking overlap with an existing flushable ingest,
# where we open and close a point iterator when constructing a range-del
# iterator.
metrics
----
| | | | ingested | moved | written | | amp
level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w
------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+---------
0 | 4 2.8KB 0B 0 | 0.50 | 149B | 3 2.1KB | 0 0B | 6 4.2KB | 0B | 2 28.8
1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
6 | 3 2.2KB 41B 0 | - | 3.5KB | 0 0B | 0 0B | 3 2.2KB | 3.5KB | 1 0.6
total | 7 5.0KB 41B 0 | - | 2.3KB | 3 2.1KB | 0 0B | 9 8.7KB | 3.5KB | 3 3.8
-------------------------------------------------------------------------------------------------------------------
WAL: 1 files (26B) in: 176B written: 175B (-1% overhead)
Flushes: 8
Compactions: 2 estimated debt: 5.0KB in progress: 0 (0B)
default: 2 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0
MemTables: 1 (1.0MB) zombie: 1 (1.0MB)
Zombie tables: 0 (0B)
Backing tables: 0 (0B)
Virtual tables: 0 (0B)
Block cache: 12 entries (2.4KB) hit rate: 31.1%
Table cache: 3 entries (2.3KB) hit rate: 57.9%
Secondary cache: 0 entries (0B) hit rate: 0.0%
Snapshots: 0 earliest seq num: 0
Table iters: 0
Filter utility: 0.0%
Ingestions: 0 as flushable: 2 (2.1KB in 3 tables)
Iter category stats:
_unknown, latency: {BlockBytes:88 BlockBytesInCache:88}
b, latency: {BlockBytes:44 BlockBytesInCache:0}
c, non-latency: {BlockBytes:44 BlockBytesInCache:44}
pebble-compaction, non-latency: {BlockBytes:411 BlockBytesInCache:154}
pebble-ingest, latency: {BlockBytes:192 BlockBytesInCache:128}
batch
set g g
set h h
set i i
set j j
set k k
set l l
set m m
----
flush
----
0.1:
000015:[d#22,SET-d#22,SET]
000016:[e#23,SET-e#23,SET]
000019:[f#24,SET-f#24,SET]
0.0:
000023:[d#19,SET-f#21,SET]
000025:[g#25,SET-i#27,SET]
000026:[j#28,SET-l#30,SET]
000027:[m#31,SET-m#31,SET]
6:
000008:[a#0,SET-b#0,SET]
000013:[c@20#0,SET-c@16#0,SET]
000014:[c@15#0,SET-c@14#0,SET]
metrics
----
| | | | ingested | moved | written | | amp
level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w
------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+---------
0 | 7 4.7KB 0B 0 | 0.50 | 207B | 3 2.1KB | 0 0B | 9 6.2KB | 0B | 2 30.5
1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
6 | 3 2.2KB 41B 0 | - | 3.5KB | 0 0B | 0 0B | 3 2.2KB | 3.5KB | 1 0.6
total | 10 7.0KB 41B 0 | - | 2.4KB | 3 2.1KB | 0 0B | 12 11KB | 3.5KB | 3 4.6
-------------------------------------------------------------------------------------------------------------------
WAL: 1 files (58B) in: 223B written: 265B (19% overhead)
Flushes: 9
Compactions: 2 estimated debt: 7.0KB in progress: 0 (0B)
default: 2 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0
MemTables: 1 (1.0MB) zombie: 1 (1.0MB)
Zombie tables: 0 (0B)
Backing tables: 0 (0B)
Virtual tables: 0 (0B)
Block cache: 12 entries (2.4KB) hit rate: 31.1%
Table cache: 3 entries (2.3KB) hit rate: 57.9%
Secondary cache: 0 entries (0B) hit rate: 0.0%
Snapshots: 0 earliest seq num: 0
Table iters: 0
Filter utility: 0.0%
Ingestions: 0 as flushable: 2 (2.1KB in 3 tables)
Iter category stats:
_unknown, latency: {BlockBytes:88 BlockBytesInCache:88}
b, latency: {BlockBytes:44 BlockBytesInCache:0}
c, non-latency: {BlockBytes:44 BlockBytesInCache:44}
pebble-compaction, non-latency: {BlockBytes:411 BlockBytesInCache:154}
pebble-ingest, latency: {BlockBytes:192 BlockBytesInCache:128}
build ext1
set z z
----
ingest-and-excise ext1 excise=i-k
----
# sstable 29, 30 were created as virtual when i-k was excised.
lsm
----
0.1:
000015:[d#22,SET-d#22,SET]
000016:[e#23,SET-e#23,SET]
000019:[f#24,SET-f#24,SET]
0.0:
000023:[d#19,SET-f#21,SET]
000029:[g#25,SET-h#26,SET]
000030:[k#29,SET-l#30,SET]
000027:[m#31,SET-m#31,SET]
6:
000008:[a#0,SET-b#0,SET]
000013:[c@20#0,SET-c@16#0,SET]
000014:[c@15#0,SET-c@14#0,SET]
000028:[z#32,SET-z#32,SET]
# There should be 2 backing tables. Note that tiny sstables have inaccurate
# virtual sstable sizes.
metrics-value
num-backing
backing-size
num-virtual
num-virtual 0
virtual-size
----
2
1.3KB
2
2
102B
metrics zero-cache-hits-misses
----
| | | | ingested | moved | written | | amp
level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w
------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+---------
0 | 7 3.5KB 0B 2 | 0.50 | 207B | 3 2.1KB | 0 0B | 9 6.2KB | 0B | 2 30.5
1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
6 | 4 2.9KB 41B 0 | - | 3.5KB | 1 716B | 0 0B | 3 2.2KB | 3.5KB | 1 0.6
total | 11 6.4KB 41B 2 | - | 3.1KB | 4 2.8KB | 0 0B | 12 12KB | 3.5KB | 3 3.7
-------------------------------------------------------------------------------------------------------------------
WAL: 1 files (58B) in: 223B written: 265B (19% overhead)
Flushes: 9
Compactions: 2 estimated debt: 6.4KB in progress: 0 (0B)
default: 2 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0
MemTables: 1 (1.0MB) zombie: 1 (1.0MB)
Zombie tables: 0 (0B)
Backing tables: 2 (1.3KB)
Virtual tables: 2 (102B)
Block cache: 21 entries (4.1KB) hit rate: 0.0%
Table cache: 5 entries (3.9KB) hit rate: 0.0%
Secondary cache: 0 entries (0B) hit rate: 0.0%
Snapshots: 0 earliest seq num: 0
Table iters: 0
Filter utility: 0.0%
Ingestions: 1 as flushable: 2 (2.1KB in 3 tables)
Iter category stats:
_unknown, latency: {BlockBytes:0 BlockBytesInCache:0}
b, latency: {BlockBytes:44 BlockBytesInCache:0}
c, non-latency: {BlockBytes:44 BlockBytesInCache:44}
pebble-compaction, non-latency: {BlockBytes:411 BlockBytesInCache:154}
pebble-ingest, latency: {BlockBytes:328 BlockBytesInCache:128}
# Virtualize a virtual sstable.
build ext1
set zz zz
----
ingest-and-excise ext1 excise=k-l
----
# sstable 32 created when k-l was excised, but no new backing file should be
# created.
lsm
----
0.1:
000015:[d#22,SET-d#22,SET]
000016:[e#23,SET-e#23,SET]
000019:[f#24,SET-f#24,SET]
0.0:
000023:[d#19,SET-f#21,SET]
000029:[g#25,SET-h#26,SET]
000032:[l#30,SET-l#30,SET]
000027:[m#31,SET-m#31,SET]
6:
000008:[a#0,SET-b#0,SET]
000013:[c@20#0,SET-c@16#0,SET]
000014:[c@15#0,SET-c@14#0,SET]
000028:[z#32,SET-z#32,SET]
000031:[zz#33,SET-zz#33,SET]
metrics-value
num-backing
backing-size
num-virtual
num-virtual 0
virtual-size
----
2
1.3KB
2
2
102B
compact a-z
----
6:
000008:[a#0,SET-b#0,SET]
000013:[c@20#0,SET-c@16#0,SET]
000014:[c@15#0,SET-c@14#0,SET]
000033:[d#0,SET-m#0,SET]
000028:[z#32,SET-z#32,SET]
000031:[zz#33,SET-zz#33,SET]
# Virtual sstables metrics should be gone after the compaction.
metrics-value
num-backing
backing-size
num-virtual
num-virtual 0
virtual-size
----
0
0B
0
0
0B
metrics zero-cache-hits-misses
----
| | | | ingested | moved | written | | amp
level | tables size val-bl vtables | score | in | tables size | tables size | tables size | read | r w
------+-----------------------------+-------+-------+--------------+--------------+--------------+-------+---------
0 | 0 0B 0B 0 | 0.00 | 207B | 3 2.1KB | 0 0B | 9 6.2KB | 0B | 0 30.5
1 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
2 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
3 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
4 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
5 | 0 0B 0B 0 | 0.00 | 0B | 0 0B | 0 0B | 0 0B | 0B | 0 0.0
6 | 6 4.3KB 41B 0 | - | 7.0KB | 2 1.4KB | 0 0B | 4 2.9KB | 7.0KB | 1 0.4
total | 6 4.3KB 41B 0 | - | 3.8KB | 5 3.5KB | 0 0B | 13 13KB | 7.0KB | 1 3.4
-------------------------------------------------------------------------------------------------------------------
WAL: 1 files (58B) in: 223B written: 265B (19% overhead)
Flushes: 9
Compactions: 3 estimated debt: 0B in progress: 0 (0B)
default: 3 delete: 0 elision: 0 move: 0 read: 0 rewrite: 0 multi-level: 0
MemTables: 1 (1.0MB) zombie: 1 (1.0MB)
Zombie tables: 0 (0B)
Backing tables: 0 (0B)
Virtual tables: 0 (0B)
Block cache: 6 entries (1.2KB) hit rate: 0.0%
Table cache: 0 entries (0B) hit rate: 0.0%
Secondary cache: 0 entries (0B) hit rate: 0.0%
Snapshots: 0 earliest seq num: 0
Table iters: 0
Filter utility: 0.0%
Ingestions: 2 as flushable: 2 (2.1KB in 3 tables)
Iter category stats:
_unknown, latency: {BlockBytes:0 BlockBytesInCache:0}
b, latency: {BlockBytes:44 BlockBytesInCache:0}
c, non-latency: {BlockBytes:44 BlockBytesInCache:44}
pebble-compaction, non-latency: {BlockBytes:941 BlockBytesInCache:640}
pebble-ingest, latency: {BlockBytes:400 BlockBytesInCache:200}