## Summary **No review yet** ## Minimized query ```sql ATTACH DATABASE ':memory:' AS aux21; ATTACH DATABASE ':memory:' AS aux19; CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (like('%MiXeD%', julianday(jsonb_patch(octet_length(x'63bdc50207abcc33440473fe2daf'), 1))),'a',1.25), (2,'b',-3.5), (3,'c',0.0); SELECT * FROM T WHERE NOT c < 2.0 ORDER BY c; CREATE INDEX IF NOT EXISTS idx_T_5250 ON T(a COLLATE NOCASE) WHERE a IS NOT NULL; PRAGMA foreign_keys = FALSE; INSERT INTO T VALUES (NULL, NULL, NULL); CREATE VIEW IF NOT EXISTS v_T_27 AS SELECT c FROM T; REINDEX; WITH a AS (SELECT * FROM T WHERE b IS NOT NULL), b AS (SELECT * FROM a WHERE b > 0), c AS (SELECT * FROM b LIMIT 10) SELECT * FROM c; UPDATE T SET c = json_object('k', c) WHERE c BETWEEN 0 AND 100; SELECT * FROM T; REINDEX T; WITH cte(x) AS (VALUES(NULL),(1),(NULL)) SELECT * FROM cte WHERE x IS NOT NULL; CREATE TRIGGER IF NOT EXISTS trg_T_1047 BEFORE INSERT ON T FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'rb'); END; SELECT * FROM T; WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<82) SELECT x FROM cnt WHERE x > 41; DETACH DATABASE aux19; DETACH DATABASE aux21; ``` ## Actual output ```sql 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: 40 (max 80) Successful lookaside attempts: 138 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: 2912 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: 2912 Bytes received by read(): 7444 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 Memory Used: 92136 (max 92136) bytes Number of Outstanding Allocations: 175 (max 175) Number of Pcache Overflow Bytes: 25392 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 41 (max 81) Successful lookaside attempts: 195 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 27744 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1472 bytes Statement Heap/Lookaside Usage: 2912 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: 2912 Bytes received by read(): 7538 Bytes sent to write(): 1292 Read() system calls: 15 Write() system calls: 1 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 103352 (max 104904) bytes Number of Outstanding Allocations: 197 (max 211) Number of Pcache Overflow Bytes: 33856 (max 33856) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 35 (max 91) Successful lookaside attempts: 270 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 32088 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1784 bytes Statement Heap/Lookaside Usage: 2432 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: 2432 Bytes received by read(): 7891 Bytes sent to write(): 2587 Read() system calls: 18 Write() system calls: 2 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 100920 (max 105024) bytes Number of Outstanding Allocations: 185 (max 211) Number of Pcache Overflow Bytes: 33856 (max 33856) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 59 (max 92) Successful lookaside attempts: 361 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 32088 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1784 bytes Statement Heap/Lookaside Usage: 6976 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 10 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 6976 Bytes received by read(): 7988 Bytes sent to write(): 4076 Read() system calls: 20 Write() system calls: 5 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 109416 (max 118832) bytes Number of Outstanding Allocations: 207 (max 219) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 95) Successful lookaside attempts: 439 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 36432 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2144 bytes Statement Heap/Lookaside Usage: 3712 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 26 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3712 Bytes received by read(): 8085 Bytes sent to write(): 5374 Read() system calls: 22 Write() system calls: 6 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 105648 (max 118832) bytes Number of Outstanding Allocations: 190 (max 219) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 40 (max 95) Successful lookaside attempts: 444 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 36432 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2144 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(): 8182 Bytes sent to write(): 6672 Read() system calls: 24 Write() system calls: 7 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 105672 (max 118832) bytes Number of Outstanding Allocations: 191 (max 219) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 50 (max 95) Successful lookaside attempts: 472 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 36432 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2168 bytes Statement Heap/Lookaside Usage: 4752 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: 4752 Bytes received by read(): 8279 Bytes sent to write(): 7969 Read() system calls: 26 Write() system calls: 8 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 108736 (max 118832) bytes Number of Outstanding Allocations: 212 (max 234) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 95) Successful lookaside attempts: 547 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 36432 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2792 bytes Statement Heap/Lookaside Usage: 2432 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: 2432 Bytes received by read(): 8376 Bytes sent to write(): 9267 Read() system calls: 28 Write() system calls: 9 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 106304 (max 118832) bytes Number of Outstanding Allocations: 200 (max 234) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 46 (max 95) Successful lookaside attempts: 563 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 36432 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2792 bytes Statement Heap/Lookaside Usage: 3168 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 16 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3168 Bytes received by read(): 8473 Bytes sent to write(): 10565 Read() system calls: 30 Write() system calls: 10 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 106808 (max 118832) bytes Number of Outstanding Allocations: 205 (max 234) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 50 (max 123) Successful lookaside attempts: 692 Lookaside failures due to size: 0 Lookaside failures due to OOM: 23 Pager Heap Usage: 36432 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2792 bytes Statement Heap/Lookaside Usage: 11816 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: 11816 Bytes received by read(): 8572 Bytes sent to write(): 11865 Read() system calls: 32 Write() system calls: 11 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 106304 (max 118832) bytes Number of Outstanding Allocations: 200 (max 234) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 50 (max 123) Successful lookaside attempts: 735 Lookaside failures due to size: 0 Lookaside failures due to OOM: 23 Pager Heap Usage: 36432 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2792 bytes Statement Heap/Lookaside Usage: 4880 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: 4880 Bytes received by read(): 8671 Bytes sent to write(): 13169 Read() system calls: 34 Write() system calls: 12 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 || Memory Used: 106304 (max 118832) bytes Number of Outstanding Allocations: 200 (max 234) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 52 (max 123) Successful lookaside attempts: 767 Lookaside failures due to size: 0 Lookaside failures due to OOM: 23 Pager Heap Usage: 36432 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2792 bytes Statement Heap/Lookaside Usage: 5136 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 12 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5136 Bytes received by read(): 8770 Bytes sent to write(): 14471 Read() system calls: 36 Write() system calls: 13 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 106304 (max 118832) bytes Number of Outstanding Allocations: 200 (max 234) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 46 (max 123) Successful lookaside attempts: 785 Lookaside failures due to size: 0 Lookaside failures due to OOM: 23 Pager Heap Usage: 36432 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2792 bytes Statement Heap/Lookaside Usage: 3168 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 16 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3168 Bytes received by read(): 8869 Bytes sent to write(): 15776 Read() system calls: 38 Write() system calls: 14 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 1 Memory Used: 106304 (max 118832) bytes Number of Outstanding Allocations: 200 (max 234) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 46 (max 123) Successful lookaside attempts: 860 Lookaside failures due to size: 0 Lookaside failures due to OOM: 23 Pager Heap Usage: 36432 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2792 bytes Statement Heap/Lookaside Usage: 6512 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 26 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 6512 Bytes received by read(): 8968 Bytes sent to write(): 17078 Read() system calls: 40 Write() system calls: 15 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 108880 (max 118832) bytes Number of Outstanding Allocations: 222 (max 234) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 123) Successful lookaside attempts: 934 Lookaside failures due to size: 0 Lookaside failures due to OOM: 23 Pager Heap Usage: 36432 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3592 bytes Statement Heap/Lookaside Usage: 1768 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: 1768 Bytes received by read(): 9067 Bytes sent to write(): 18382 Read() system calls: 42 Write() system calls: 16 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 || Memory Used: 107112 (max 118832) bytes Number of Outstanding Allocations: 211 (max 234) Number of Pcache Overflow Bytes: 38216 (max 38216) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 52 (max 123) Successful lookaside attempts: 966 Lookaside failures due to size: 0 Lookaside failures due to OOM: 23 Pager Heap Usage: 36432 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3592 bytes Statement Heap/Lookaside Usage: 5136 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 12 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5136 Bytes received by read(): 9166 Bytes sent to write(): 19684 Read() system calls: 44 Write() system calls: 17 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 Memory Used: 107112 (max 205792) bytes Number of Outstanding Allocations: 211 (max 234) Number of Pcache Overflow Bytes: 38216 (max 46424) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 51 (max 123) Successful lookaside attempts: 1129 Lookaside failures due to size: 0 Lookaside failures due to OOM: 23 Pager Heap Usage: 36432 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3592 bytes Statement Heap/Lookaside Usage: 10368 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 1570 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 10368 Bytes received by read(): 9265 Bytes sent to write(): 20989 Read() system calls: 46 Write() system calls: 18 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 94896 (max 205792) bytes Number of Outstanding Allocations: 194 (max 234) Number of Pcache Overflow Bytes: 29752 (max 46424) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 41 (max 123) Successful lookaside attempts: 1135 Lookaside failures due to size: 0 Lookaside failures due to OOM: 23 Pager Heap Usage: 27184 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3224 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(): 9364 Bytes sent to write(): 22419 Read() system calls: 48 Write() system calls: 19 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 82680 (max 205792) bytes Number of Outstanding Allocations: 177 (max 234) Number of Pcache Overflow Bytes: 21288 (max 46424) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 39 (max 123) Successful lookaside attempts: 1141 Lookaside failures due to size: 0 Lookaside failures due to OOM: 23 Pager Heap Usage: 17936 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2856 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(): 9463 Bytes sent to write(): 23720 Read() system calls: 51 Write() system calls: 20 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Expectation ```sql ``` ## Flag ``` -stats ```