## Summary **No review yet** ## Minimized query ```sql .stats stmt SAVEPOINT sp8248; CREATE TABLE T ( a INTEGER, b REAL, c REAL ); INSERT INTO T VALUES ((-(-(atan2(1, 1))) - 0),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0); WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d; INSERT INTO T SELECT * FROM T; INSERT OR ABORT INTO T VALUES (8, 0, 3); RELEASE sp8248; SELECT COUNT(*) FROM T; SELECT * FROM (SELECT * FROM T ORDER BY c) AS sub LIMIT 10; VACUUM main; SELECT * FROM (SELECT * FROM T) AS sub; DELETE FROM T WHERE 1; CREATE TRIGGER IF NOT EXISTS trg_T_7142 BEFORE DELETE ON T FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'rb'); END; REINDEX T; DELETE FROM T WHERE a > (SELECT AVG(a) FROM T); ANALYZE T; UPDATE T SET b = '' WHERE b BETWEEN 0 AND 100; PRAGMA secure_delete = FALSE; INSERT INTO T SELECT * FROM T; ``` ## Actual output ```sql Number of output columns: 0 Memory Used: 62608 (max 62608) 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: 37 (max 37) 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: 2656 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: 2656 Bytes received by read(): 7094 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 Number of output columns: 0 Memory Used: 80576 (max 86256) bytes Number of Outstanding Allocations: 166 (max 177) Number of Pcache Overflow Bytes: 16928 (max 16928) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 33 (max 89) Successful lookaside attempts: 112 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: 1048 bytes Statement Heap/Lookaside Usage: 2464 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: 2464 Bytes received by read(): 7444 Bytes sent to write(): 1324 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: 78136 (max 86256) bytes Number of Outstanding Allocations: 155 (max 177) Number of Pcache Overflow Bytes: 16928 (max 16928) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 47 (max 89) Successful lookaside attempts: 167 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 13592 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1072 bytes Statement Heap/Lookaside Usage: 5008 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 44 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5008 Bytes received by read(): 7541 Bytes sent to write(): 2659 Read() system calls: 18 Write() system calls: 2 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 0.785398163397448|21.0 1|-70.875 2|-Inf Number of output columns: 2 Column 0 name: a Column 0 declared type: INTEGER Column 1 name: e Column 1 declared type: (null) Memory Used: 81976 (max 86288) bytes Number of Outstanding Allocations: 157 (max 177) Number of Pcache Overflow Bytes: 16928 (max 16928) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 64 (max 115) Successful lookaside attempts: 271 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 13592 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1072 bytes Statement Heap/Lookaside Usage: 26976 bytes Fullscan Steps: 2 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 140 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 26976 Bytes received by read(): 7638 Bytes sent to write(): 3994 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: 78136 (max 176776) bytes Number of Outstanding Allocations: 155 (max 177) Number of Pcache Overflow Bytes: 16928 (max 25136) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 44 (max 115) Successful lookaside attempts: 306 Lookaside failures due to size: 2 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: 1072 bytes Statement Heap/Lookaside Usage: 4624 bytes Fullscan Steps: 2 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 70 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4624 Bytes received by read(): 7735 Bytes sent to write(): 5540 Read() system calls: 22 Write() system calls: 4 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 78136 (max 176776) bytes Number of Outstanding Allocations: 155 (max 177) Number of Pcache Overflow Bytes: 16928 (max 25136) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 39 (max 115) Successful lookaside attempts: 324 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 13592 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1072 bytes Statement Heap/Lookaside Usage: 2912 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 11 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2912 Bytes received by read(): 7832 Bytes sent to write(): 6877 Read() system calls: 24 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: 76528 (max 176776) bytes Number of Outstanding Allocations: 152 (max 177) Number of Pcache Overflow Bytes: 16928 (max 25136) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 36 (max 115) Successful lookaside attempts: 328 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 13592 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1072 bytes Statement Heap/Lookaside Usage: 2656 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 2 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2656 Bytes received by read(): 7929 Bytes sent to write(): 8214 Read() system calls: 26 Write() system calls: 6 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 7 Number of output columns: 1 Column 0 name: COUNT(*) Column 0 declared type: (null) Memory Used: 76528 (max 176776) bytes Number of Outstanding Allocations: 152 (max 177) Number of Pcache Overflow Bytes: 16928 (max 25136) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 38 (max 115) Successful lookaside attempts: 346 Lookaside failures due to size: 2 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: 1072 bytes Statement Heap/Lookaside Usage: 2912 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: 2912 Bytes received by read(): 8026 Bytes sent to write(): 9550 Read() system calls: 28 Write() system calls: 7 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 2|Inf|-1.0 2|Inf|-1.0 8|0.0|3.0 0.785398163397448|2.0|10.5 0.785398163397448|2.0|10.5 1|-3.5|20.25 1|-3.5|20.25 Number of output columns: 3 Column 0 name: a Column 0 declared type: INTEGER Column 1 name: b Column 1 declared type: REAL Column 2 name: c Column 2 declared type: REAL Memory Used: 76528 (max 176776) bytes Number of Outstanding Allocations: 152 (max 177) Number of Pcache Overflow Bytes: 16928 (max 25136) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 54 (max 115) Successful lookaside attempts: 419 Lookaside failures due to size: 2 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: 1072 bytes Statement Heap/Lookaside Usage: 6976 bytes Fullscan Steps: 6 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 128 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 6976 Bytes received by read(): 8123 Bytes sent to write(): 10978 Read() system calls: 30 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: 71328 (max 310600) bytes Number of Outstanding Allocations: 124 (max 205) Number of Pcache Overflow Bytes: 12824 (max 25136) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 35 (max 115) Successful lookaside attempts: 797 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 13592 bytes Page cache hits: 7 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(): 8221 Bytes sent to write(): 12675 Read() system calls: 32 Write() system calls: 9 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 0.785398163397448|2.0|10.5 1|-3.5|20.25 2|Inf|-1.0 0.785398163397448|2.0|10.5 1|-3.5|20.25 2|Inf|-1.0 8|0.0|3.0 Number of output columns: 3 Column 0 name: a Column 0 declared type: INTEGER Column 1 name: b Column 1 declared type: REAL Column 2 name: c Column 2 declared type: REAL Memory Used: 72376 (max 310600) bytes Number of Outstanding Allocations: 149 (max 205) Number of Pcache Overflow Bytes: 12824 (max 25136) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 47 (max 115) Successful lookaside attempts: 908 Lookaside failures due to size: 2 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: 1024 bytes Statement Heap/Lookaside Usage: 5136 bytes Fullscan Steps: 6 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 55 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5136 Bytes received by read(): 8319 Bytes sent to write(): 14009 Read() system calls: 34 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: 76480 (max 310600) bytes Number of Outstanding Allocations: 150 (max 205) Number of Pcache Overflow Bytes: 16928 (max 25136) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 38 (max 115) Successful lookaside attempts: 923 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 13592 bytes Page cache hits: 9 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1024 bytes Statement Heap/Lookaside Usage: 2912 bytes Fullscan Steps: 6 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 28 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2912 Bytes received by read(): 8418 Bytes sent to write(): 15706 Read() system calls: 36 Write() system calls: 11 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 79064 (max 310600) bytes Number of Outstanding Allocations: 173 (max 205) Number of Pcache Overflow Bytes: 16928 (max 25136) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 115) Successful lookaside attempts: 997 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 13592 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1848 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(): 8517 Bytes sent to write(): 17045 Read() system calls: 38 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: 77312 (max 310600) bytes Number of Outstanding Allocations: 162 (max 205) Number of Pcache Overflow Bytes: 16928 (max 25136) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 35 (max 115) Successful lookaside attempts: 1002 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 13592 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1848 bytes Statement Heap/Lookaside Usage: 2528 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 2 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2528 Bytes received by read(): 8616 Bytes sent to write(): 18384 Read() system calls: 40 Write() system calls: 13 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 77312 (max 310600) bytes Number of Outstanding Allocations: 162 (max 205) Number of Pcache Overflow Bytes: 16928 (max 25136) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 53 (max 115) Successful lookaside attempts: 1061 Lookaside failures due to size: 2 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: 1848 bytes Statement Heap/Lookaside Usage: 6976 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: 6976 Bytes received by read(): 8715 Bytes sent to write(): 19723 Read() system calls: 42 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: 86304 (max 310600) bytes Number of Outstanding Allocations: 186 (max 205) Number of Pcache Overflow Bytes: 21288 (max 25136) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 33 (max 115) Successful lookaside attempts: 1171 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 17936 bytes Page cache hits: 6 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2136 bytes Statement Heap/Lookaside Usage: 5536 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: 5536 Bytes received by read(): 8814 Bytes sent to write(): 21062 Read() system calls: 44 Write() system calls: 15 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 81992 (max 310600) bytes Number of Outstanding Allocations: 171 (max 205) Number of Pcache Overflow Bytes: 21288 (max 25136) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 43 (max 115) Successful lookaside attempts: 1208 Lookaside failures due to size: 2 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: 2160 bytes Statement Heap/Lookaside Usage: 4624 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: 4624 Bytes received by read(): 8913 Bytes sent to write(): 22402 Read() system calls: 46 Write() system calls: 16 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 0 Number of output columns: 1 Column 0 name: secure_delete Column 0 declared type: (null) Memory Used: 81992 (max 310600) bytes Number of Outstanding Allocations: 171 (max 205) Number of Pcache Overflow Bytes: 21288 (max 25136) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 115) Successful lookaside attempts: 1216 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 17936 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2160 bytes Statement Heap/Lookaside Usage: 2784 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: 2784 Bytes received by read(): 9012 Bytes sent to write(): 23742 Read() system calls: 48 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: 81992 (max 310600) bytes Number of Outstanding Allocations: 171 (max 205) Number of Pcache Overflow Bytes: 21288 (max 29496) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 43 (max 115) Successful lookaside attempts: 1249 Lookaside failures due to size: 2 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: 2160 bytes Statement Heap/Lookaside Usage: 4624 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 13 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4624 Bytes received by read(): 9111 Bytes sent to write(): 25178 Read() system calls: 51 Write() system calls: 18 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: 53 (max 53) 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: 2656 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: 2656 Bytes received by read(): 7870 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 Number of output columns: 0 Memory Used: 81056 (max 86688) bytes Number of Outstanding Allocations: 176 (max 187) Number of Pcache Overflow Bytes: 16936 (max 16936) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 49 (max 98) Successful lookaside attempts: 121 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: 880 bytes Statement Heap/Lookaside Usage: 2336 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: 2336 Bytes received by read(): 7964 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: 80016 (max 86688) bytes Number of Outstanding Allocations: 166 (max 187) Number of Pcache Overflow Bytes: 16936 (max 16936) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 62 (max 98) Successful lookaside attempts: 178 Lookaside failures due to size: 1 Lookaside failures due to OOM: 0 Pager Heap Usage: 13608 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: 888 bytes Statement Heap/Lookaside Usage: 5096 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 44 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5096 Bytes received by read(): 8061 Bytes sent to write(): 2736 Read() system calls: 18 Write() system calls: 2 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 0.785398163397448|21.0 1|-70.875 2|-Inf Number of output columns: 2 Column 0 name: a Column 0 declared type: INTEGER Column 1 name: e Column 1 declared type: (null) Memory Used: 82680 (max 86984) bytes Number of Outstanding Allocations: 172 (max 187) Number of Pcache Overflow Bytes: 16936 (max 16936) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 71 (max 123) Successful lookaside attempts: 273 Lookaside failures due to size: 3 Lookaside failures due to OOM: 8 Pager Heap Usage: 13608 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: 888 bytes Statement Heap/Lookaside Usage: 25936 bytes Fullscan Steps: 2 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 144 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 25936 Bytes received by read(): 8158 Bytes sent to write(): 4109 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: 78728 (max 177512) bytes Number of Outstanding Allocations: 165 (max 187) Number of Pcache Overflow Bytes: 16936 (max 25136) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 57 (max 123) Successful lookaside attempts: 305 Lookaside failures due to size: 3 Lookaside failures due to OOM: 8 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: 888 bytes Statement Heap/Lookaside Usage: 4240 bytes Fullscan Steps: 2 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 70 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4240 Bytes received by read(): 8255 Bytes sent to write(): 5693 Read() system calls: 22 Write() system calls: 4 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 78728 (max 177512) bytes Number of Outstanding Allocations: 165 (max 187) Number of Pcache Overflow Bytes: 16936 (max 25136) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 55 (max 123) Successful lookaside attempts: 323 Lookaside failures due to size: 3 Lookaside failures due to OOM: 8 Pager Heap Usage: 13608 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: 888 bytes Statement Heap/Lookaside Usage: 2912 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 11 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2912 Bytes received by read(): 8352 Bytes sent to write(): 7068 Read() system calls: 24 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: 77136 (max 177512) bytes Number of Outstanding Allocations: 162 (max 187) Number of Pcache Overflow Bytes: 16936 (max 25136) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 52 (max 123) Successful lookaside attempts: 327 Lookaside failures due to size: 3 Lookaside failures due to OOM: 8 Pager Heap Usage: 13608 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: 888 bytes Statement Heap/Lookaside Usage: 2656 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: 2656 Bytes received by read(): 8449 Bytes sent to write(): 8443 Read() system calls: 26 Write() system calls: 6 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 7 Number of output columns: 1 Column 0 name: COUNT(*) Column 0 declared type: (null) Memory Used: 77136 (max 177512) bytes Number of Outstanding Allocations: 162 (max 187) Number of Pcache Overflow Bytes: 16936 (max 25136) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 54 (max 123) Successful lookaside attempts: 345 Lookaside failures due to size: 3 Lookaside failures due to OOM: 8 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: 888 bytes Statement Heap/Lookaside Usage: 2912 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: 2912 Bytes received by read(): 8546 Bytes sent to write(): 9817 Read() system calls: 28 Write() system calls: 7 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 2|Inf|-1.0 2|Inf|-1.0 8|0.0|3.0 0.785398163397448|2.0|10.5 0.785398163397448|2.0|10.5 1|-3.5|20.25 1|-3.5|20.25 Number of output columns: 3 Column 0 name: a Column 0 declared type: INTEGER Column 1 name: b Column 1 declared type: REAL Column 2 name: c Column 2 declared type: REAL Memory Used: 77136 (max 177512) bytes Number of Outstanding Allocations: 162 (max 187) Number of Pcache Overflow Bytes: 16936 (max 25136) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 66 (max 123) Successful lookaside attempts: 415 Lookaside failures due to size: 3 Lookaside failures due to OOM: 8 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: 888 bytes Statement Heap/Lookaside Usage: 6464 bytes Fullscan Steps: 6 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 128 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 6464 Bytes received by read(): 8643 Bytes sent to write(): 11283 Read() system calls: 30 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: 76248 (max 311104) bytes Number of Outstanding Allocations: 135 (max 215) Number of Pcache Overflow Bytes: 16936 (max 25136) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 51 (max 123) Successful lookaside attempts: 764 Lookaside failures due to size: 3 Lookaside failures due to OOM: 8 Pager Heap Usage: 13608 bytes Page cache hits: 7 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(): 8785 Bytes sent to write(): 13018 Read() system calls: 33 Write() system calls: 9 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 0.785398163397448|2.0|10.5 1|-3.5|20.25 2|Inf|-1.0 0.785398163397448|2.0|10.5 1|-3.5|20.25 2|Inf|-1.0 8|0.0|3.0 Number of output columns: 3 Column 0 name: a Column 0 declared type: INTEGER Column 1 name: b Column 1 declared type: REAL Column 2 name: c Column 2 declared type: REAL Memory Used: 77120 (max 311104) bytes Number of Outstanding Allocations: 160 (max 215) Number of Pcache Overflow Bytes: 16936 (max 25136) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 60 (max 123) Successful lookaside attempts: 868 Lookaside failures due to size: 3 Lookaside failures due to OOM: 8 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: 872 bytes Statement Heap/Lookaside Usage: 4752 bytes Fullscan Steps: 6 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 55 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4752 Bytes received by read(): 8883 Bytes sent to write(): 14391 Read() system calls: 35 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: 77120 (max 311104) bytes Number of Outstanding Allocations: 160 (max 215) Number of Pcache Overflow Bytes: 16936 (max 25136) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 54 (max 123) Successful lookaside attempts: 883 Lookaside failures due to size: 3 Lookaside failures due to OOM: 8 Pager Heap Usage: 13608 bytes Page cache hits: 9 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 872 bytes Statement Heap/Lookaside Usage: 2912 bytes Fullscan Steps: 6 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 28 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2912 Bytes received by read(): 8982 Bytes sent to write(): 16126 Read() system calls: 37 Write() system calls: 11 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 79552 (max 311104) bytes Number of Outstanding Allocations: 184 (max 215) Number of Pcache Overflow Bytes: 16936 (max 25136) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 123) Successful lookaside attempts: 950 Lookaside failures due to size: 3 Lookaside failures due to OOM: 8 Pager Heap Usage: 13608 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: 1632 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(): 9081 Bytes sent to write(): 17503 Read() system calls: 39 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: 77880 (max 311104) bytes Number of Outstanding Allocations: 173 (max 215) Number of Pcache Overflow Bytes: 16936 (max 25136) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 51 (max 123) Successful lookaside attempts: 955 Lookaside failures due to size: 3 Lookaside failures due to OOM: 8 Pager Heap Usage: 13608 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: 1632 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(): 9180 Bytes sent to write(): 18881 Read() system calls: 41 Write() system calls: 13 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 77880 (max 311104) bytes Number of Outstanding Allocations: 173 (max 215) Number of Pcache Overflow Bytes: 16936 (max 25136) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 68 (max 123) Successful lookaside attempts: 1014 Lookaside failures due to size: 3 Lookaside failures due to OOM: 8 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: 1632 bytes Statement Heap/Lookaside Usage: 6848 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: 6848 Bytes received by read(): 9279 Bytes sent to write(): 20258 Read() system calls: 43 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: 86672 (max 311104) bytes Number of Outstanding Allocations: 197 (max 215) Number of Pcache Overflow Bytes: 21304 (max 25136) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 49 (max 123) Successful lookaside attempts: 1114 Lookaside failures due to size: 3 Lookaside failures due to OOM: 8 Pager Heap Usage: 17960 bytes Page cache hits: 6 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1880 bytes Statement Heap/Lookaside Usage: 5376 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: 5376 Bytes received by read(): 9378 Bytes sent to write(): 21636 Read() system calls: 45 Write() system calls: 15 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 82504 (max 311104) bytes Number of Outstanding Allocations: 182 (max 215) Number of Pcache Overflow Bytes: 21304 (max 25136) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 56 (max 123) Successful lookaside attempts: 1148 Lookaside failures due to size: 3 Lookaside failures due to OOM: 8 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: 1888 bytes Statement Heap/Lookaside Usage: 4240 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: 4240 Bytes received by read(): 9477 Bytes sent to write(): 23015 Read() system calls: 47 Write() system calls: 16 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 0 Number of output columns: 1 Column 0 name: secure_delete Column 0 declared type: (null) Memory Used: 82504 (max 311104) bytes Number of Outstanding Allocations: 182 (max 215) Number of Pcache Overflow Bytes: 21304 (max 25136) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 53 (max 123) Successful lookaside attempts: 1156 Lookaside failures due to size: 3 Lookaside failures due to OOM: 8 Pager Heap Usage: 17960 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: 1888 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(): 9576 Bytes sent to write(): 24394 Read() system calls: 49 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: 82504 (max 311104) bytes Number of Outstanding Allocations: 182 (max 215) Number of Pcache Overflow Bytes: 21304 (max 29504) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 56 (max 123) Successful lookaside attempts: 1186 Lookaside failures due to size: 3 Lookaside failures due to OOM: 8 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: 1888 bytes Statement Heap/Lookaside Usage: 4240 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 13 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4240 Bytes received by read(): 9675 Bytes sent to write(): 25869 Read() system calls: 52 Write() system calls: 18 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Flag ``` ```