## Summary **No review yet** ## Minimized query ```sql PRAGMA vdbe_debug = ON; ATTACH DATABASE ':memory:' AS aux42; .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; PRAGMA foreign_keys = 1; DETACH DATABASE aux42; ALTER TABLE t1 RENAME TO t1_r4421; PRAGMA index_info(idx1); UPDATE t2 SET z = '' RETURNING *; ``` ## Actual output ```sql Number of output columns: 0 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: 37 (max 80) Successful lookaside attempts: 148 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: 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(): 7298 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: 79920 (max 79960) bytes Number of Outstanding Allocations: 158 (max 159) Number of Pcache Overflow Bytes: 16928 (max 16928) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 38 (max 80) Successful lookaside attempts: 154 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 18496 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1104 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(): 7392 Bytes sent to write(): 1331 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: 79920 (max 79960) bytes Number of Outstanding Allocations: 158 (max 159) Number of Pcache Overflow Bytes: 16928 (max 16928) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 80) Successful lookaside attempts: 159 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: 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(): 7489 Bytes sent to write(): 2763 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: 79920 (max 79960) bytes Number of Outstanding Allocations: 158 (max 159) 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: 167 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 18496 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1104 bytes Statement Heap/Lookaside Usage: 3984 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: 3984 Bytes received by read(): 7586 Bytes sent to write(): 4097 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: 79920 (max 79960) bytes Number of Outstanding Allocations: 158 (max 159) Number of Pcache Overflow Bytes: 16928 (max 16928) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 39 (max 80) Successful lookaside attempts: 175 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 18496 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1104 bytes Statement Heap/Lookaside Usage: 2784 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: 2784 Bytes received by read(): 7683 Bytes sent to write(): 6000 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: 79920 (max 79960) bytes Number of Outstanding Allocations: 158 (max 159) Number of Pcache Overflow Bytes: 16928 (max 16928) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 39 (max 80) Successful lookaside attempts: 183 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 18496 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1104 bytes Statement Heap/Lookaside Usage: 2784 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: 2784 Bytes received by read(): 7780 Bytes sent to write(): 7334 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: 91008 (max 92560) bytes Number of Outstanding Allocations: 178 (max 192) Number of Pcache Overflow Bytes: 25392 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 90) Successful lookaside attempts: 258 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22840 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1336 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(): 8133 Bytes sent to write(): 8668 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: 88664 (max 94344) bytes Number of Outstanding Allocations: 167 (max 192) Number of Pcache Overflow Bytes: 25392 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 39 (max 90) Successful lookaside attempts: 273 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22840 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1360 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(): 8230 Bytes sent to write(): 10003 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: 95664 (max 101344) bytes Number of Outstanding Allocations: 186 (max 201) Number of Pcache Overflow Bytes: 29752 (max 29752) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 90) Successful lookaside attempts: 348 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 27184 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1608 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(): 8328 Bytes sent to write(): 11338 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: 93304 (max 101344) bytes Number of Outstanding Allocations: 175 (max 201) Number of Pcache Overflow Bytes: 29752 (max 29752) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 39 (max 90) Successful lookaside attempts: 364 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 27184 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1632 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(): 8426 Bytes sent to write(): 12675 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: 100616 (max 110360) bytes Number of Outstanding Allocations: 193 (max 204) Number of Pcache Overflow Bytes: 34112 (max 34112) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 93) Successful lookaside attempts: 443 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31528 bytes Page cache hits: 5 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1816 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(): 8525 Bytes sent to write(): 14013 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: 97880 (max 196608) bytes Number of Outstanding Allocations: 179 (max 204) Number of Pcache Overflow Bytes: 34112 (max 42320) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 53 (max 102) Successful lookaside attempts: 555 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31528 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1840 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(): 8624 Bytes sent to write(): 15352 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: 97880 (max 196608) bytes Number of Outstanding Allocations: 179 (max 204) Number of Pcache Overflow Bytes: 34112 (max 42320) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 39 (max 102) Successful lookaside attempts: 570 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31528 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1840 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(): 8723 Bytes sent to write(): 16946 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: 97880 (max 196608) bytes Number of Outstanding Allocations: 179 (max 204) Number of Pcache Overflow Bytes: 34112 (max 42320) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 48 (max 121) Successful lookaside attempts: 687 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31528 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1840 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(): 8822 Bytes sent to write(): 18284 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: 100440 (max 196608) bytes Number of Outstanding Allocations: 201 (max 210) Number of Pcache Overflow Bytes: 34112 (max 42320) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 121) Successful lookaside attempts: 761 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31528 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2640 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(): 8921 Bytes sent to write(): 19710 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: 98688 (max 196608) bytes Number of Outstanding Allocations: 190 (max 210) Number of Pcache Overflow Bytes: 34112 (max 42320) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 50 (max 121) Successful lookaside attempts: 825 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31528 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2640 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(): 9020 Bytes sent to write(): 21050 Read() system calls: 44 Write() system calls: 16 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 98688 (max 196608) bytes Number of Outstanding Allocations: 190 (max 210) Number of Pcache Overflow Bytes: 34112 (max 42320) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 121) Successful lookaside attempts: 830 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31528 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2640 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(): 9119 Bytes sent to write(): 22644 Read() system calls: 46 Write() system calls: 17 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 86472 (max 196608) bytes Number of Outstanding Allocations: 173 (max 210) Number of Pcache Overflow Bytes: 25648 (max 42320) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 121) Successful lookaside attempts: 836 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22280 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2272 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(): 9218 Bytes sent to write(): 23982 Read() system calls: 48 Write() system calls: 18 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 201304 (max 574568) bytes Number of Outstanding Allocations: 215 (max 291) Number of Pcache Overflow Bytes: 33856 (max 58480) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 102 (max 123) Successful lookaside attempts: 1171 Lookaside failures due to size: 3 Lookaside failures due to OOM: 174 Pager Heap Usage: 31496 bytes Page cache hits: 10 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2216 bytes Statement Heap/Lookaside Usage: 47736 bytes Fullscan Steps: 9 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 240 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 47736 Bytes received by read(): 9317 Bytes sent to write(): 25320 Read() system calls: 50 Write() system calls: 19 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 3 Column 0 name: seqno Column 0 declared type: (null) Column 1 name: cid Column 1 declared type: (null) Column 2 name: name Column 2 declared type: (null) Memory Used: 185040 (max 574568) bytes Number of Outstanding Allocations: 178 (max 291) Number of Pcache Overflow Bytes: 33856 (max 58480) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 36 (max 123) Successful lookaside attempts: 1177 Lookaside failures due to size: 3 Lookaside failures due to OOM: 174 Pager Heap Usage: 31496 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2216 bytes Statement Heap/Lookaside Usage: 3728 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: 3728 Bytes received by read(): 9416 Bytes sent to write(): 26668 Read() system calls: 52 Write() system calls: 20 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 2| Number of output columns: 2 Column 0 name: y Column 0 declared type: (null) Column 1 name: z Column 1 declared type: (null) Memory Used: 185064 (max 574568) bytes Number of Outstanding Allocations: 179 (max 291) Number of Pcache Overflow Bytes: 33856 (max 58480) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 46 (max 123) Successful lookaside attempts: 1227 Lookaside failures due to size: 3 Lookaside failures due to OOM: 174 Pager Heap Usage: 31496 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2240 bytes Statement Heap/Lookaside Usage: 6080 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 35 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 6080 Bytes received by read(): 9515 Bytes sent to write(): 28268 Read() system calls: 55 Write() system calls: 21 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Expectation ```sql Number of output columns: 0 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: 53 (max 91) Successful lookaside attempts: 154 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: 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(): 8074 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: 80568 (max 80600) bytes Number of Outstanding Allocations: 168 (max 169) Number of Pcache Overflow Bytes: 16944 (max 16944) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 54 (max 91) Successful lookaside attempts: 160 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 18512 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: 944 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(): 8168 Bytes sent to write(): 1369 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: 80568 (max 80600) bytes Number of Outstanding Allocations: 168 (max 169) Number of Pcache Overflow Bytes: 16944 (max 16944) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 53 (max 91) Successful lookaside attempts: 165 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: 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(): 8265 Bytes sent to write(): 2839 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: 80568 (max 80600) bytes Number of Outstanding Allocations: 168 (max 169) 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: 173 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 18512 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: 944 bytes Statement Heap/Lookaside Usage: 3984 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: 3984 Bytes received by read(): 8362 Bytes sent to write(): 4211 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: 80568 (max 80600) bytes Number of Outstanding Allocations: 168 (max 169) Number of Pcache Overflow Bytes: 16944 (max 16944) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 55 (max 91) Successful lookaside attempts: 181 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 18512 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: 944 bytes Statement Heap/Lookaside Usage: 2784 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: 2784 Bytes received by read(): 8459 Bytes sent to write(): 6152 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: 80568 (max 80600) bytes Number of Outstanding Allocations: 168 (max 169) Number of Pcache Overflow Bytes: 16944 (max 16944) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 55 (max 91) Successful lookaside attempts: 189 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 18512 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: 944 bytes Statement Heap/Lookaside Usage: 2784 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: 2784 Bytes received by read(): 8556 Bytes sent to write(): 7524 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: 91504 (max 93040) bytes Number of Outstanding Allocations: 188 (max 202) Number of Pcache Overflow Bytes: 25408 (max 25408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 50 (max 99) Successful lookaside attempts: 257 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22864 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: 1144 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(): 8653 Bytes sent to write(): 8896 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: 89240 (max 94872) bytes Number of Outstanding Allocations: 177 (max 202) Number of Pcache Overflow Bytes: 25408 (max 25408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 55 (max 99) Successful lookaside attempts: 272 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22864 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: 1152 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(): 8750 Bytes sent to write(): 10270 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: 96096 (max 101728) bytes Number of Outstanding Allocations: 196 (max 211) Number of Pcache Overflow Bytes: 29776 (max 29776) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 50 (max 99) Successful lookaside attempts: 340 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 27216 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: 1368 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(): 8848 Bytes sent to write(): 11644 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: 93832 (max 101728) bytes Number of Outstanding Allocations: 185 (max 211) Number of Pcache Overflow Bytes: 29776 (max 29776) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 55 (max 99) Successful lookaside attempts: 356 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 27216 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: 1376 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(): 8946 Bytes sent to write(): 13020 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: 100992 (max 110680) bytes Number of Outstanding Allocations: 202 (max 213) Number of Pcache Overflow Bytes: 34144 (max 34144) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 50 (max 102) Successful lookaside attempts: 428 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31568 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: 1568 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(): 9045 Bytes sent to write(): 14397 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: 98400 (max 197264) bytes Number of Outstanding Allocations: 189 (max 213) Number of Pcache Overflow Bytes: 34144 (max 42344) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 66 (max 118) Successful lookaside attempts: 539 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31568 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: 1576 bytes Statement Heap/Lookaside Usage: 11568 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: 11568 Bytes received by read(): 9144 Bytes sent to write(): 15776 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: 98400 (max 197264) bytes Number of Outstanding Allocations: 189 (max 213) Number of Pcache Overflow Bytes: 34144 (max 42344) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 55 (max 118) Successful lookaside attempts: 554 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31568 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: 1576 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(): 9243 Bytes sent to write(): 17411 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: 98400 (max 197264) bytes Number of Outstanding Allocations: 189 (max 213) Number of Pcache Overflow Bytes: 34144 (max 42344) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 60 (max 123) Successful lookaside attempts: 657 Lookaside failures due to size: 0 Lookaside failures due to OOM: 11 Pager Heap Usage: 31568 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: 1576 bytes Statement Heap/Lookaside Usage: 5568 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: 5568 Bytes received by read(): 9342 Bytes sent to write(): 18788 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: 100824 (max 197264) bytes Number of Outstanding Allocations: 212 (max 221) Number of Pcache Overflow Bytes: 34144 (max 42344) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 50 (max 123) Successful lookaside attempts: 724 Lookaside failures due to size: 0 Lookaside failures due to OOM: 11 Pager Heap Usage: 31568 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: 2328 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(): 9441 Bytes sent to write(): 20254 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: 99152 (max 197264) bytes Number of Outstanding Allocations: 201 (max 221) Number of Pcache Overflow Bytes: 34144 (max 42344) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 63 (max 123) Successful lookaside attempts: 785 Lookaside failures due to size: 0 Lookaside failures due to OOM: 11 Pager Heap Usage: 31568 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: 2328 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(): 9540 Bytes sent to write(): 21634 Read() system calls: 44 Write() system calls: 16 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 99152 (max 197264) bytes Number of Outstanding Allocations: 201 (max 221) Number of Pcache Overflow Bytes: 34144 (max 42344) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 53 (max 123) Successful lookaside attempts: 790 Lookaside failures due to size: 0 Lookaside failures due to OOM: 11 Pager Heap Usage: 31568 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: 2328 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(): 9639 Bytes sent to write(): 23268 Read() system calls: 46 Write() system calls: 17 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 87000 (max 197264) bytes Number of Outstanding Allocations: 184 (max 221) Number of Pcache Overflow Bytes: 25672 (max 42344) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 53 (max 123) Successful lookaside attempts: 796 Lookaside failures due to size: 0 Lookaside failures due to OOM: 11 Pager Heap Usage: 22312 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: 2016 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(): 9738 Bytes sent to write(): 24646 Read() system calls: 48 Write() system calls: 18 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 201320 (max 573448) bytes Number of Outstanding Allocations: 202 (max 265) Number of Pcache Overflow Bytes: 33872 (max 58472) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 97 (max 123) Successful lookaside attempts: 1129 Lookaside failures due to size: 3 Lookaside failures due to OOM: 130 Pager Heap Usage: 31544 bytes Page cache hits: 10 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 2000 bytes Statement Heap/Lookaside Usage: 35760 bytes Fullscan Steps: 9 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 240 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 35760 Bytes received by read(): 9881 Bytes sent to write(): 26024 Read() system calls: 51 Write() system calls: 19 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 3 Column 0 name: seqno Column 0 declared type: (null) Column 1 name: cid Column 1 declared type: (null) Column 2 name: name Column 2 declared type: (null) Memory Used: 185768 (max 573448) bytes Number of Outstanding Allocations: 188 (max 265) Number of Pcache Overflow Bytes: 33872 (max 58472) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 52 (max 123) Successful lookaside attempts: 1135 Lookaside failures due to size: 3 Lookaside failures due to OOM: 130 Pager Heap Usage: 31544 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: 2000 bytes Statement Heap/Lookaside Usage: 3728 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: 3728 Bytes received by read(): 9980 Bytes sent to write(): 27410 Read() system calls: 53 Write() system calls: 20 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 2| Number of output columns: 2 Column 0 name: y Column 0 declared type: (null) Column 1 name: z Column 1 declared type: (null) Memory Used: 185776 (max 573448) bytes Number of Outstanding Allocations: 189 (max 265) Number of Pcache Overflow Bytes: 33872 (max 58472) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 59 (max 123) Successful lookaside attempts: 1182 Lookaside failures due to size: 3 Lookaside failures due to OOM: 130 Pager Heap Usage: 31544 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: 2008 bytes Statement Heap/Lookaside Usage: 5696 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 35 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5696 Bytes received by read(): 10079 Bytes sent to write(): 29049 Read() system calls: 56 Write() system calls: 21 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Flag ``` ```