## Summary **No review yet** ## Minimized query ```sql .stats stmt SAVEPOINT sp4970; .scanstats on DROP TABLE IF EXISTS t0; CREATE TABLE t0(c0 REAL UNIQUE); INSERT INTO t0(c0) VALUES (0.0); SELECT 3175546974276630385 < c0 FROM t0; SELECT 1 FROM t0 WHERE NOT NOT /**/ (3175546974276630385 < c0) ; ALTER TABLE t0 ADD COLUMN extra_80 DOUBLE COLLATE NOCASE; ANALYZE t0; REINDEX t0; SELECT STRING_AGG(c0, '|') FROM t0; RELEASE sp4970; ALTER TABLE t0 ADD COLUMN extra_3988 TEXT NOT NULL DEFAULT 0; ALTER TABLE t0 ADD COLUMN extra_7474 DOUB DEFAULT 0; ``` ## 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(): 6803 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: 67720 (max 67720) bytes Number of Outstanding Allocations: 141 (max 141) Number of Pcache Overflow Bytes: 8464 (max 8464) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 75) Successful lookaside attempts: 92 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 9248 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 736 bytes Statement Heap/Lookaside Usage: 2656 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 5 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2656 Bytes received by read(): 6897 Bytes sent to write(): 1373 Read() system calls: 15 Write() system calls: 2 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 86640 (max 92528) bytes Number of Outstanding Allocations: 172 (max 181) Number of Pcache Overflow Bytes: 21288 (max 21288) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 33 (max 91) Successful lookaside attempts: 169 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 17936 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1168 bytes Statement Heap/Lookaside Usage: 4040 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 41 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4040 Bytes received by read(): 7250 Bytes sent to write(): 2702 Read() system calls: 18 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: 82624 (max 92528) bytes Number of Outstanding Allocations: 156 (max 181) Number of Pcache Overflow Bytes: 21288 (max 21288) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 47 (max 91) Successful lookaside attempts: 197 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 17936 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1192 bytes Statement Heap/Lookaside Usage: 3808 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: 3808 Bytes received by read(): 7347 Bytes sent to write(): 4037 Read() system calls: 20 Write() system calls: 4 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 0 Number of output columns: 1 Column 0 name: 3175546974276630385 < c0 Column 0 declared type: (null) Memory Used: 82624 (max 92528) bytes Number of Outstanding Allocations: 156 (max 181) Number of Pcache Overflow Bytes: 21288 (max 21288) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 42 (max 91) Successful lookaside attempts: 222 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 17936 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1192 bytes Statement Heap/Lookaside Usage: 3296 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 14 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3296 Bytes received by read(): 7444 Bytes sent to write(): 5372 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: 1 Column 0 name: 1 Column 0 declared type: (null) Memory Used: 82624 (max 92528) bytes Number of Outstanding Allocations: 156 (max 181) Number of Pcache Overflow Bytes: 21288 (max 21288) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 42 (max 91) Successful lookaside attempts: 249 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 17936 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1192 bytes Statement Heap/Lookaside Usage: 3296 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: 3296 Bytes received by read(): 7541 Bytes sent to write(): 6815 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: 87144 (max 191632) bytes Number of Outstanding Allocations: 181 (max 220) Number of Pcache Overflow Bytes: 21288 (max 29496) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 33 (max 91) Successful lookaside attempts: 320 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 17936 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1184 bytes Statement Heap/Lookaside Usage: 4528 bytes Fullscan Steps: 1 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 51 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4528 Bytes received by read(): 7638 Bytes sent to write(): 8233 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: 92096 (max 191632) bytes Number of Outstanding Allocations: 188 (max 220) Number of Pcache Overflow Bytes: 25648 (max 29496) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 92) Successful lookaside attempts: 437 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22280 bytes Page cache hits: 6 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1496 bytes Statement Heap/Lookaside Usage: 5944 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 50 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5944 Bytes received by read(): 7735 Bytes sent to write(): 9569 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: 87296 (max 191632) bytes Number of Outstanding Allocations: 164 (max 220) Number of Pcache Overflow Bytes: 25648 (max 29496) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 42 (max 92) Successful lookaside attempts: 453 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22280 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1496 bytes Statement Heap/Lookaside Usage: 3168 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 24 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3168 Bytes received by read(): 7832 Bytes sent to write(): 10905 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: 85688 (max 191632) bytes Number of Outstanding Allocations: 161 (max 220) Number of Pcache Overflow Bytes: 25648 (max 29496) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 38 (max 92) Successful lookaside attempts: 472 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: 1496 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(): 7930 Bytes sent to write(): 12360 Read() system calls: 32 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: 90472 (max 194792) bytes Number of Outstanding Allocations: 189 (max 228) Number of Pcache Overflow Bytes: 25648 (max 33856) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 92) Successful lookaside attempts: 575 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22280 bytes Page cache hits: 5 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1720 bytes Statement Heap/Lookaside Usage: 4560 bytes Fullscan Steps: 2 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 56 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4560 Bytes received by read(): 8029 Bytes sent to write(): 13697 Read() system calls: 34 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: 90552 (max 194872) bytes Number of Outstanding Allocations: 191 (max 234) Number of Pcache Overflow Bytes: 25648 (max 33856) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 92) Successful lookaside attempts: 678 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22280 bytes Page cache hits: 5 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1832 bytes Statement Heap/Lookaside Usage: 4528 bytes Fullscan Steps: 2 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 56 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4528 Bytes received by read(): 8128 Bytes sent to write(): 15035 Read() system calls: 37 Write() system calls: 13 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Expectation ```sql ``` ## Flag ``` ```