## 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; ``` ## 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(): 6916 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(): 7266 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(): 7363 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(): 7460 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(): 7557 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(): 7654 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(): 7751 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(): 7848 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(): 7945 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(): 8043 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(): 8141 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(): 8240 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(): 8339 Bytes sent to write(): 17045 Read() system calls: 39 Write() system calls: 12 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(): 7692 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(): 7786 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(): 7883 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(): 7980 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(): 8077 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(): 8174 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(): 8271 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(): 8368 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(): 8465 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(): 8607 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(): 8705 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(): 8804 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(): 8903 Bytes sent to write(): 17503 Read() system calls: 40 Write() system calls: 12 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Flag ``` ```