## Summary **No review yet** ## Minimized query ```sql .stats stmt PRAGMA vdbe_addoptrace = YES; .eqp off PRAGMA application_id; PRAGMA ignore_check_constraints = FALSE; PRAGMA table_list("users"); .eqp auto DROP TABLE IF EXISTS t1; DROP TABLE IF EXISTS t2; CREATE TABLE t1(x); INSERT INTO t1 VALUES(1); CREATE TABLE t2(y,z); INSERT INTO t2 VALUES(2,3); CREATE INDEX t2y ON t2(y); WITH _m AS MATERIALIZED (SELECT * FROM t1) SELECT * FROM _m,(SELECT * FROM t2 WHERE y=2 ORDER BY y,z); INSERT INTO t1 VALUES (NULL); WITH RECURSIVE vals(x) AS (SELECT z FROM t2 WHERE z IS NOT NULL UNION ALL SELECT z FROM t2 WHERE z IS NOT NULL LIMIT 10) SELECT * FROM vals; CREATE TRIGGER IF NOT EXISTS trg_t1_3163 AFTER DELETE ON t1 FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'abort'); END; SELECT * FROM t2 AS a LEFT OUTER JOIN t1 AS b ON a.rowid = b.rowid; ``` ## Actual output ```sql Number of output columns: 0 Memory Used: 62592 (max 62592) bytes Number of Outstanding Allocations: 122 (max 122) Number of Pcache Overflow Bytes: 4104 (max 4104) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4104 bytes Lookaside Slots Used: 35 (max 36) Successful lookaside attempts: 37 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 4904 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 0 bytes Statement Heap/Lookaside Usage: 2528 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 3 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2528 Bytes received by read(): 7095 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 0 Number of output columns: 1 Column 0 name: application_id Column 0 declared type: (null) Memory Used: 66952 (max 66992) bytes Number of Outstanding Allocations: 123 (max 124) Number of Pcache Overflow Bytes: 8464 (max 8464) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 36 (max 37) Successful lookaside attempts: 43 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: 0 bytes Statement Heap/Lookaside Usage: 2656 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 6 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2656 Bytes received by read(): 7189 Bytes sent to write(): 1324 Read() system calls: 15 Write() system calls: 1 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 66952 (max 66992) bytes Number of Outstanding Allocations: 123 (max 124) Number of Pcache Overflow Bytes: 8464 (max 8464) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 35 (max 37) Successful lookaside attempts: 48 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: 0 bytes Statement Heap/Lookaside Usage: 2528 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 4 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2528 Bytes received by read(): 7286 Bytes sent to write(): 2749 Read() system calls: 17 Write() system calls: 2 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 6 Column 0 name: schema Column 0 declared type: (null) Column 1 name: name Column 1 declared type: (null) Column 2 name: type Column 2 declared type: (null) Column 3 name: ncol Column 3 declared type: (null) Column 4 name: wr Column 4 declared type: (null) Column 5 name: strict Column 5 declared type: (null) Memory Used: 67704 (max 67704) bytes Number of Outstanding Allocations: 141 (max 141) Number of Pcache Overflow Bytes: 8464 (max 8464) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 76) Successful lookaside attempts: 103 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 9248 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 736 bytes Statement Heap/Lookaside Usage: 3856 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 5 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3856 Bytes received by read(): 7383 Bytes sent to write(): 4076 Read() system calls: 19 Write() system calls: 3 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 67704 (max 67704) bytes Number of Outstanding Allocations: 141 (max 141) Number of Pcache Overflow Bytes: 8464 (max 8464) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 36 (max 76) Successful lookaside attempts: 110 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 9248 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 736 bytes Statement Heap/Lookaside Usage: 2656 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 5 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2656 Bytes received by read(): 7480 Bytes sent to write(): 5975 Read() system calls: 21 Write() system calls: 5 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 67704 (max 67704) bytes Number of Outstanding Allocations: 141 (max 141) Number of Pcache Overflow Bytes: 8464 (max 8464) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 36 (max 76) Successful lookaside attempts: 117 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 9248 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 736 bytes Statement Heap/Lookaside Usage: 2656 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 5 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2656 Bytes received by read(): 7577 Bytes sent to write(): 7305 Read() system calls: 23 Write() system calls: 6 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 78792 (max 80344) bytes Number of Outstanding Allocations: 161 (max 175) Number of Pcache Overflow Bytes: 16928 (max 16928) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 88) Successful lookaside attempts: 192 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 13592 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 968 bytes Statement Heap/Lookaside Usage: 2368 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 30 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2368 Bytes received by read(): 7930 Bytes sent to write(): 8635 Read() system calls: 26 Write() system calls: 7 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 76448 (max 82128) bytes Number of Outstanding Allocations: 150 (max 175) Number of Pcache Overflow Bytes: 16928 (max 16928) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 88) Successful lookaside attempts: 207 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 13592 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 992 bytes Statement Heap/Lookaside Usage: 2784 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 9 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2784 Bytes received by read(): 8027 Bytes sent to write(): 9969 Read() system calls: 28 Write() system calls: 8 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 83448 (max 89128) bytes Number of Outstanding Allocations: 169 (max 184) Number of Pcache Overflow Bytes: 21288 (max 21288) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 88) Successful lookaside attempts: 282 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 17936 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1240 bytes Statement Heap/Lookaside Usage: 2384 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 28 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2384 Bytes received by read(): 8124 Bytes sent to write(): 11302 Read() system calls: 30 Write() system calls: 9 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 81088 (max 89128) bytes Number of Outstanding Allocations: 158 (max 184) Number of Pcache Overflow Bytes: 21288 (max 21288) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 88) Successful lookaside attempts: 298 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 17936 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1264 bytes Statement Heap/Lookaside Usage: 2784 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 10 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2784 Bytes received by read(): 8222 Bytes sent to write(): 12638 Read() system calls: 32 Write() system calls: 10 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 88400 (max 98144) bytes Number of Outstanding Allocations: 176 (max 187) Number of Pcache Overflow Bytes: 25648 (max 25648) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 91) Successful lookaside attempts: 377 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22280 bytes Page cache hits: 5 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1448 bytes Statement Heap/Lookaside Usage: 2704 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 35 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2704 Bytes received by read(): 8321 Bytes sent to write(): 13975 Read() system calls: 34 Write() system calls: 11 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 1|2|3 Number of output columns: 3 Column 0 name: x Column 0 declared type: (null) Column 1 name: y Column 1 declared type: (null) Column 2 name: z Column 2 declared type: (null) Memory Used: 85664 (max 184392) bytes Number of Outstanding Allocations: 162 (max 187) Number of Pcache Overflow Bytes: 25648 (max 33856) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 51 (max 102) Successful lookaside attempts: 489 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22280 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1472 bytes Statement Heap/Lookaside Usage: 6592 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 27 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 6592 Bytes received by read(): 8420 Bytes sent to write(): 15312 Read() system calls: 36 Write() system calls: 12 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 85664 (max 184392) bytes Number of Outstanding Allocations: 162 (max 187) Number of Pcache Overflow Bytes: 25648 (max 33856) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 102) Successful lookaside attempts: 504 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22280 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1472 bytes Statement Heap/Lookaside Usage: 2784 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 9 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2784 Bytes received by read(): 8519 Bytes sent to write(): 16906 Read() system calls: 38 Write() system calls: 13 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 3 3 Number of output columns: 1 Column 0 name: x Column 0 declared type: (null) Memory Used: 85664 (max 184392) bytes Number of Outstanding Allocations: 162 (max 187) Number of Pcache Overflow Bytes: 25648 (max 33856) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 46 (max 119) Successful lookaside attempts: 621 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22280 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1472 bytes Statement Heap/Lookaside Usage: 7152 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 22 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 7152 Bytes received by read(): 8618 Bytes sent to write(): 18244 Read() system calls: 40 Write() system calls: 14 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 88224 (max 184392) bytes Number of Outstanding Allocations: 184 (max 193) Number of Pcache Overflow Bytes: 25648 (max 33856) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 119) Successful lookaside attempts: 695 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22280 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2272 bytes Statement Heap/Lookaside Usage: 1752 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 15 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 1752 Bytes received by read(): 8717 Bytes sent to write(): 19670 Read() system calls: 42 Write() system calls: 15 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 2|3|1 Number of output columns: 3 Column 0 name: y Column 0 declared type: (null) Column 1 name: z Column 1 declared type: (null) Column 2 name: x Column 2 declared type: (null) Memory Used: 86472 (max 184392) bytes Number of Outstanding Allocations: 173 (max 193) Number of Pcache Overflow Bytes: 25648 (max 33856) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 48 (max 119) Successful lookaside attempts: 759 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22280 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2272 bytes Statement Heap/Lookaside Usage: 5264 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 17 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5264 Bytes received by read(): 8816 Bytes sent to write(): 21009 Read() system calls: 45 Write() system calls: 16 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Expectation ```sql Number of output columns: 0 Memory Used: 63416 (max 63416) bytes Number of Outstanding Allocations: 132 (max 132) Number of Pcache Overflow Bytes: 4104 (max 4104) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4104 bytes Lookaside Slots Used: 51 (max 52) Successful lookaside attempts: 53 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 4904 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: 0 bytes Statement Heap/Lookaside Usage: 2528 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 4 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2528 Bytes received by read(): 7871 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 0 Number of output columns: 1 Column 0 name: application_id Column 0 declared type: (null) Memory Used: 67784 (max 67816) bytes Number of Outstanding Allocations: 133 (max 134) Number of Pcache Overflow Bytes: 8472 (max 8472) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 52 (max 53) Successful lookaside attempts: 59 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: 0 bytes Statement Heap/Lookaside Usage: 2656 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: 2656 Bytes received by read(): 7965 Bytes sent to write(): 1363 Read() system calls: 16 Write() system calls: 1 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 67784 (max 67816) bytes Number of Outstanding Allocations: 133 (max 134) Number of Pcache Overflow Bytes: 8472 (max 8472) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 51 (max 53) Successful lookaside attempts: 64 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: 0 bytes Statement Heap/Lookaside Usage: 2528 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 5 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2528 Bytes received by read(): 8062 Bytes sent to write(): 2827 Read() system calls: 18 Write() system calls: 2 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 6 Column 0 name: schema Column 0 declared type: (null) Column 1 name: name Column 1 declared type: (null) Column 2 name: type Column 2 declared type: (null) Column 3 name: ncol Column 3 declared type: (null) Column 4 name: wr Column 4 declared type: (null) Column 5 name: strict Column 5 declared type: (null) Memory Used: 68416 (max 68416) bytes Number of Outstanding Allocations: 151 (max 151) Number of Pcache Overflow Bytes: 8472 (max 8472) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 53 (max 87) Successful lookaside attempts: 114 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 9256 bytes Page cache hits: 2 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: 3856 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 5 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3856 Bytes received by read(): 8159 Bytes sent to write(): 4193 Read() system calls: 20 Write() system calls: 3 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 68416 (max 68416) bytes Number of Outstanding Allocations: 151 (max 151) Number of Pcache Overflow Bytes: 8472 (max 8472) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 52 (max 87) Successful lookaside attempts: 121 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 9256 bytes Page cache hits: 1 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: 2656 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 5 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2656 Bytes received by read(): 8256 Bytes sent to write(): 6131 Read() system calls: 22 Write() system calls: 5 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 68416 (max 68416) bytes Number of Outstanding Allocations: 151 (max 151) Number of Pcache Overflow Bytes: 8472 (max 8472) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 52 (max 87) Successful lookaside attempts: 128 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 9256 bytes Page cache hits: 1 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: 2656 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 5 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2656 Bytes received by read(): 8353 Bytes sent to write(): 7500 Read() system calls: 24 Write() system calls: 6 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 79352 (max 80888) bytes Number of Outstanding Allocations: 171 (max 185) Number of Pcache Overflow Bytes: 16936 (max 16936) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 97) Successful lookaside attempts: 196 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 13608 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 832 bytes Statement Heap/Lookaside Usage: 2272 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 30 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2272 Bytes received by read(): 8450 Bytes sent to write(): 8869 Read() system calls: 26 Write() system calls: 7 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 77088 (max 82720) bytes Number of Outstanding Allocations: 160 (max 185) Number of Pcache Overflow Bytes: 16936 (max 16936) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 53 (max 97) Successful lookaside attempts: 211 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 13608 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 840 bytes Statement Heap/Lookaside Usage: 2784 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 9 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2784 Bytes received by read(): 8547 Bytes sent to write(): 10242 Read() system calls: 28 Write() system calls: 8 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 83944 (max 89576) bytes Number of Outstanding Allocations: 179 (max 194) Number of Pcache Overflow Bytes: 21304 (max 21304) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 97) Successful lookaside attempts: 279 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 17960 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1056 bytes Statement Heap/Lookaside Usage: 2272 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 28 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2272 Bytes received by read(): 8645 Bytes sent to write(): 11615 Read() system calls: 30 Write() system calls: 9 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 81680 (max 89576) bytes Number of Outstanding Allocations: 168 (max 194) Number of Pcache Overflow Bytes: 21304 (max 21304) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 53 (max 97) Successful lookaside attempts: 295 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 17960 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1064 bytes Statement Heap/Lookaside Usage: 2784 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 10 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2784 Bytes received by read(): 8743 Bytes sent to write(): 12990 Read() system calls: 32 Write() system calls: 10 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 88840 (max 98528) bytes Number of Outstanding Allocations: 185 (max 196) Number of Pcache Overflow Bytes: 25672 (max 25672) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 100) Successful lookaside attempts: 367 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22312 bytes Page cache hits: 5 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1256 bytes Statement Heap/Lookaside Usage: 2544 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 35 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2544 Bytes received by read(): 8842 Bytes sent to write(): 14366 Read() system calls: 34 Write() system calls: 11 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 1|2|3 Number of output columns: 3 Column 0 name: x Column 0 declared type: (null) Column 1 name: y Column 1 declared type: (null) Column 2 name: z Column 2 declared type: (null) Memory Used: 86248 (max 185112) bytes Number of Outstanding Allocations: 172 (max 196) Number of Pcache Overflow Bytes: 25672 (max 33872) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 64 (max 116) Successful lookaside attempts: 478 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22312 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1264 bytes Statement Heap/Lookaside Usage: 10496 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 29 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 10496 Bytes received by read(): 8941 Bytes sent to write(): 15743 Read() system calls: 36 Write() system calls: 12 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 86248 (max 185112) bytes Number of Outstanding Allocations: 172 (max 196) Number of Pcache Overflow Bytes: 25672 (max 33872) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 53 (max 116) Successful lookaside attempts: 493 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22312 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1264 bytes Statement Heap/Lookaside Usage: 2784 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 9 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2784 Bytes received by read(): 9040 Bytes sent to write(): 17378 Read() system calls: 38 Write() system calls: 13 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 3 3 Number of output columns: 1 Column 0 name: x Column 0 declared type: (null) Memory Used: 86248 (max 185112) bytes Number of Outstanding Allocations: 172 (max 196) Number of Pcache Overflow Bytes: 25672 (max 33872) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 58 (max 123) Successful lookaside attempts: 598 Lookaside failures due to size: 0 Lookaside failures due to OOM: 9 Pager Heap Usage: 22312 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1264 bytes Statement Heap/Lookaside Usage: 4496 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 22 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4496 Bytes received by read(): 9139 Bytes sent to write(): 18755 Read() system calls: 40 Write() system calls: 14 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 88672 (max 185112) bytes Number of Outstanding Allocations: 195 (max 204) Number of Pcache Overflow Bytes: 25672 (max 33872) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 123) Successful lookaside attempts: 665 Lookaside failures due to size: 0 Lookaside failures due to OOM: 9 Pager Heap Usage: 22312 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 2016 bytes Statement Heap/Lookaside Usage: 1672 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 15 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 1672 Bytes received by read(): 9238 Bytes sent to write(): 20220 Read() system calls: 42 Write() system calls: 15 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 2|3|1 Number of output columns: 3 Column 0 name: y Column 0 declared type: (null) Column 1 name: z Column 1 declared type: (null) Column 2 name: x Column 2 declared type: (null) Memory Used: 87000 (max 185112) bytes Number of Outstanding Allocations: 184 (max 204) Number of Pcache Overflow Bytes: 25672 (max 33872) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 61 (max 123) Successful lookaside attempts: 726 Lookaside failures due to size: 0 Lookaside failures due to OOM: 9 Pager Heap Usage: 22312 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 2016 bytes Statement Heap/Lookaside Usage: 4880 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 17 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4880 Bytes received by read(): 9337 Bytes sent to write(): 21598 Read() system calls: 45 Write() system calls: 16 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Flag ``` ```