11 KiB
11 KiB
Summary
**No review yet**Minimized query
ATTACH DATABASE ':memory:' AS aux22;
creATE VIRTUAL TABLE t0 USING fts3("x", "y", "z");
DROP TABLE t0;
DETACH DATABASE aux22;
Actual output
Memory Used: 79920 (max 79920) bytes
Number of Outstanding Allocations: 158 (max 158)
Number of Pcache Overflow Bytes: 16928 (max 16928) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 40 (max 80)
Successful lookaside attempts: 138
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 18496 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1104 bytes
Statement Heap/Lookaside Usage: 2912 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 7
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2912
Bytes received by read(): 6438
Bytes sent to write(): 0
Read() system calls: 13
Write() system calls: 0
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 106952 (max 118920) bytes
Number of Outstanding Allocations: 223 (max 262)
Number of Pcache Overflow Bytes: 38472 (max 38472) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 34 (max 96)
Successful lookaside attempts: 449
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 35872 bytes
Page cache hits: 14
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2928 bytes
Statement Heap/Lookaside Usage: 2720 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 33
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2720
Bytes received by read(): 6788
Bytes sent to write(): 1292
Read() system calls: 16
Write() system calls: 1
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 101488 (max 333968) bytes
Number of Outstanding Allocations: 164 (max 262)
Number of Pcache Overflow Bytes: 38472 (max 54888) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 46 (max 96)
Successful lookaside attempts: 717
Lookaside failures due to size: 4
Lookaside failures due to OOM: 0
Pager Heap Usage: 35872 bytes
Page cache hits: 21
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1128 bytes
Statement Heap/Lookaside Usage: 3680 bytes
Fullscan Steps: 4
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 32
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3680
Bytes received by read(): 6885
Bytes sent to write(): 2591
Read() system calls: 18
Write() system calls: 2
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 89272 (max 333968) bytes
Number of Outstanding Allocations: 147 (max 262)
Number of Pcache Overflow Bytes: 30008 (max 54888) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 37 (max 96)
Successful lookaside attempts: 723
Lookaside failures due to size: 4
Lookaside failures due to OOM: 0
Pager Heap Usage: 26624 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 760 bytes
Statement Heap/Lookaside Usage: 2784 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 7
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2784
Bytes received by read(): 6982
Bytes sent to write(): 3890
Read() system calls: 21
Write() system calls: 3
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Expectation
Memory Used: 80568 (max 80568) bytes
Number of Outstanding Allocations: 168 (max 168)
Number of Pcache Overflow Bytes: 16944 (max 16944) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 56 (max 91)
Successful lookaside attempts: 144
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 18512 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 944 bytes
Statement Heap/Lookaside Usage: 2912 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 8
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2912
Bytes received by read(): 7214
Bytes sent to write(): 0
Read() system calls: 14
Write() system calls: 0
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 107400 (max 118928) bytes
Number of Outstanding Allocations: 234 (max 263)
Number of Pcache Overflow Bytes: 38512 (max 38512) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 50 (max 105)
Successful lookaside attempts: 427
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 35920 bytes
Page cache hits: 14
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 2704 bytes
Statement Heap/Lookaside Usage: 2616 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 33
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2616
Bytes received by read(): 7308
Bytes sent to write(): 1330
Read() system calls: 16
Write() system calls: 1
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 102384 (max 334544) bytes
Number of Outstanding Allocations: 175 (max 265)
Number of Pcache Overflow Bytes: 38512 (max 54912) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 60 (max 105)
Successful lookaside attempts: 667
Lookaside failures due to size: 4
Lookaside failures due to OOM: 0
Pager Heap Usage: 35920 bytes
Page cache hits: 21
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1192 bytes
Statement Heap/Lookaside Usage: 3424 bytes
Fullscan Steps: 4
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 32
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3424
Bytes received by read(): 7405
Bytes sent to write(): 2669
Read() system calls: 18
Write() system calls: 2
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Memory Used: 90232 (max 334544) bytes
Number of Outstanding Allocations: 158 (max 265)
Number of Pcache Overflow Bytes: 30040 (max 54912) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 53 (max 105)
Successful lookaside attempts: 673
Lookaside failures due to size: 4
Lookaside failures due to OOM: 0
Pager Heap Usage: 26664 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 880 bytes
Statement Heap/Lookaside Usage: 2784 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 8
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2784
Bytes received by read(): 7502
Bytes sent to write(): 4008
Read() system calls: 21
Write() system calls: 3
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Flag
-stats