## Summary **No review yet** ## Minimized query ```sql PRAGMA synchronous; .stats CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z"); DROP TABLE t0; VACUUM main; .stats CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z"); DROP TABLE t0; VACUUM main; .stats CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z"); DROP TABLE t0; VACUUM main; .stats CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z"); DROP TABLE t0; VACUUM main; .stats CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z"); DROP TABLE t0; VACUUM main; .stats CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z"); DROP TABLE t0; VACUUM main; VACUUM main; ``` ## Actual output ```sql 2 Memory Used: 67720 (max 67760) bytes Number of Outstanding Allocations: 141 (max 142) Number of Pcache Overflow Bytes: 8464 (max 8464) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 75) Successful lookaside attempts: 87 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 9248 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 736 bytes Statement Heap/Lookaside Usage: 0 bytes Bytes received by read(): 6868 Bytes sent to write(): 2 Read() system calls: 13 Write() system calls: 1 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 66968 (max 331016) bytes Number of Outstanding Allocations: 123 (max 259) Number of Pcache Overflow Bytes: 8464 (max 55144) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 96) Successful lookaside attempts: 1199 Lookaside failures due to size: 6 Lookaside failures due to OOM: 0 Pager Heap Usage: 9248 bytes Page cache hits: 56 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 0 bytes Statement Heap/Lookaside Usage: 0 bytes Bytes received by read(): 7218 Bytes sent to write(): 1010 Read() system calls: 16 Write() system calls: 2 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 66968 (max 331048) bytes Number of Outstanding Allocations: 123 (max 263) Number of Pcache Overflow Bytes: 8464 (max 55144) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 96) Successful lookaside attempts: 2311 Lookaside failures due to size: 12 Lookaside failures due to OOM: 0 Pager Heap Usage: 9248 bytes Page cache hits: 58 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 0 bytes Statement Heap/Lookaside Usage: 0 bytes Bytes received by read(): 7315 Bytes sent to write(): 2024 Read() system calls: 18 Write() system calls: 3 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 66968 (max 331048) bytes Number of Outstanding Allocations: 123 (max 263) Number of Pcache Overflow Bytes: 8464 (max 55144) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 96) Successful lookaside attempts: 3423 Lookaside failures due to size: 18 Lookaside failures due to OOM: 0 Pager Heap Usage: 9248 bytes Page cache hits: 58 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 0 bytes Statement Heap/Lookaside Usage: 0 bytes Bytes received by read(): 7412 Bytes sent to write(): 3039 Read() system calls: 20 Write() system calls: 4 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 66968 (max 331048) bytes Number of Outstanding Allocations: 123 (max 263) Number of Pcache Overflow Bytes: 8464 (max 55144) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 96) Successful lookaside attempts: 4535 Lookaside failures due to size: 24 Lookaside failures due to OOM: 0 Pager Heap Usage: 9248 bytes Page cache hits: 58 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 0 bytes Statement Heap/Lookaside Usage: 0 bytes Bytes received by read(): 7509 Bytes sent to write(): 4054 Read() system calls: 22 Write() system calls: 5 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 66968 (max 331048) bytes Number of Outstanding Allocations: 123 (max 263) Number of Pcache Overflow Bytes: 8464 (max 55144) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 96) Successful lookaside attempts: 5647 Lookaside failures due to size: 30 Lookaside failures due to OOM: 0 Pager Heap Usage: 9248 bytes Page cache hits: 58 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 0 bytes Statement Heap/Lookaside Usage: 0 bytes Bytes received by read(): 7606 Bytes sent to write(): 5069 Read() system calls: 24 Write() system calls: 6 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Expectation ```sql 2 Memory Used: 68416 (max 68448) bytes Number of Outstanding Allocations: 151 (max 152) Number of Pcache Overflow Bytes: 8472 (max 8472) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 86) Successful lookaside attempts: 98 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 9256 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: 632 bytes Statement Heap/Lookaside Usage: 0 bytes Bytes received by read(): 7644 Bytes sent to write(): 2 Read() system calls: 14 Write() system calls: 1 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 71880 (max 331576) bytes Number of Outstanding Allocations: 134 (max 262) Number of Pcache Overflow Bytes: 12568 (max 55176) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 104) Successful lookaside attempts: 1104 Lookaside failures due to size: 6 Lookaside failures due to OOM: 0 Pager Heap Usage: 9256 bytes Page cache hits: 56 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 0 bytes Statement Heap/Lookaside Usage: 0 bytes Bytes received by read(): 7782 Bytes sent to write(): 1049 Read() system calls: 17 Write() system calls: 2 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 71880 (max 331576) bytes Number of Outstanding Allocations: 134 (max 262) Number of Pcache Overflow Bytes: 12568 (max 55176) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 104) Successful lookaside attempts: 2110 Lookaside failures due to size: 12 Lookaside failures due to OOM: 0 Pager Heap Usage: 9256 bytes Page cache hits: 58 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 0 bytes Statement Heap/Lookaside Usage: 0 bytes Bytes received by read(): 7879 Bytes sent to write(): 2104 Read() system calls: 19 Write() system calls: 3 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 71880 (max 331576) bytes Number of Outstanding Allocations: 134 (max 262) Number of Pcache Overflow Bytes: 12568 (max 55176) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 104) Successful lookaside attempts: 3116 Lookaside failures due to size: 18 Lookaside failures due to OOM: 0 Pager Heap Usage: 9256 bytes Page cache hits: 58 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 0 bytes Statement Heap/Lookaside Usage: 0 bytes Bytes received by read(): 7976 Bytes sent to write(): 3160 Read() system calls: 21 Write() system calls: 4 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 71880 (max 331576) bytes Number of Outstanding Allocations: 134 (max 262) Number of Pcache Overflow Bytes: 12568 (max 55176) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 104) Successful lookaside attempts: 4122 Lookaside failures due to size: 24 Lookaside failures due to OOM: 0 Pager Heap Usage: 9256 bytes Page cache hits: 58 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 0 bytes Statement Heap/Lookaside Usage: 0 bytes Bytes received by read(): 8073 Bytes sent to write(): 4216 Read() system calls: 23 Write() system calls: 5 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 71880 (max 331576) bytes Number of Outstanding Allocations: 134 (max 262) Number of Pcache Overflow Bytes: 12568 (max 55176) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 104) Successful lookaside attempts: 5128 Lookaside failures due to size: 30 Lookaside failures due to OOM: 0 Pager Heap Usage: 9256 bytes Page cache hits: 58 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 0 bytes Statement Heap/Lookaside Usage: 0 bytes Bytes received by read(): 8170 Bytes sent to write(): 5272 Read() system calls: 25 Write() system calls: 6 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Flag ``` ```