## Summary **No review yet** ## Minimized query ```sql ATTACH DATABASE ':memory:' AS aux22; creATE VIRTUAL TABLE t0 USING fts3("x", "y", "z"); DROP TABLE t0; DETACH DATABASE aux22; ``` ## Actual output ```sql 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 ```sql 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 ```