## Summary **No review yet** ## Minimized query ```sql CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT); INSERT INTO t1 VALUES (1, 'Wernher', 10, 100); INSERT INTO t1 VALUES (2, 'von', 20, 200); INSERT INTO t1 VALUES (3, 'Braun', 30, 300); CREATE INDEX t1bc ON t1(b, c); PRAGMA writable_schema = ON; .imposter t1bc t2 SELECT * FROM t2; SELECT b, c FROM t1 ORDER BY b, c; .quit SAVEPOINT sp8767; PRAGMA count_changes = OFF; CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z"); DROP TABLE t0; BEGIN DEFERRED; SAVEPOINT sp3957; .exit strftime('' || ('%s'), NULL) .schema PRAGMA synchronous IS NOT 'OFF'; ATTACH DATABASE ':memory:' AS aux78; BEGIN IMMEDIATE TRANSACTION; PRAGMA recursive_triggers; .exit CAST(zeroblob('"') AS DATE) CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (glob('?', 'hello'),'a',abs(x'84a9ab1d')), (json_extract(datetime(atanh(CAST(';' AS INT)), '+1 day'), '$[0]'),'b',-coalesce(NULL, julianday(time(round(2147483647))))), (2,'c',-9e999); SELECT b,a,c, RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T; INSERT OR FAIL INTO T VALUES (-1, 3, 0); PRAGMA quick_check(20); SELECT MAX(c) FILTER (WHERE NOT NOT (NOT NOT (NOT NOT (NOT NOT (c IS NOT NULL) OVER (PARTITION BY c)))) ORDER BY c RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING) FROM T; ANALYZE T; END TRANSACTION; ALTER TABLE T ADD COLUMN extra_4706 NCHAR(55) NOT NULL DEFAULT 0; SELECT COUNT(*) FROM T; CREATE TEMP VIEW IF NOT EXISTS v_T_2390 AS SELECT a FROM T; ALTER TABLE T DROP COLUMN b; DELETE FROM T WHERE a IS NULL; INSERT INTO T VALUES ('x', 1, NULL) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c; ALTER TABLE T RENAME TO T_r4177; ALTER TABLE T RENAME TO T_r7895; PRAGMA schema_version = 5; DETACH DATABASE aux78; ATTACH DATABASE ':memory:' AS aux78; BEGIN IMMEDIATE TRANSACTION; PRAGMA recursive_triggers; .exit CAST(zeroblob('"') AS DATETIME) CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (glob('?', 'hello'),'a',abs(x'84a9ab1d')), (json_extract(datetime(atanh(CAST(1 AS INT)), '+1 day'), '$[0]'),'b',-7.75), (2,'c',-9e999); SELECT b,a,c, RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T; INSERT AND FAIL INTO T VALUES (-1, 3, 0); PRAGMA quick_check(20); SELECT MAX(c) FILTER (WHERE c IS NOT NULL) OVER (PARTITION BY c ORDER BY c RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING) FROM T; ANALYZE T; END TRANSACTION; ALTER TABLE T ADD COLUMN extra_4706 NCHAR(55) NOT NULL DEFAULT 0; SELECT COUNT(*) FROM T; CREATE TEMP VIEW IF NOT EXISTS v_T_2390 AS SELECT a FROM T; ALTER TABLE T DROP COLUMN b; DELETE FROM T WHERE a IS NULL; INSERT INTO T VALUES ('x', 1, NULL) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c; ALTER TABLE T RENAME TO T_r4177; ALTER TABLE T RENAME TO T_r7895; PRAGMA schema_version = 5; DETACH DATABASE aux78; ATTACH DATABASE ':memory:' AS aux78; BEGIN IMMEDIATE TRANSACTION; PRAGMA recursive_triggers; .exit CAST(zeroblob('"') AS DATETIME) CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (glob('?', 'hello'),'a',abs(x'84a9ab1d')), (json_extract(datetime(atanh(CAST(1 AS INT)), '+1 day'), '$[0]'),'b',-7.75), (2,'c',-9e999); SELECT b,a,c, RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T; INSERT AND FAIL INTO T VALUES (-1, 3, 0); PRAGMA quick_check(20); SELECT MAX(c) FILTER (WHERE c IS NOT NULL) OVER (PARTITION BY c ORDER BY c RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING) FROM T; ANALYZE T; END TRANSACTION; ALTER TABLE T ADD COLUMN extra_4706 NCHAR(55) NOT NULL DEFAULT 0; SELECT COUNT(*) FROM T; CREATE TEMP VIEW IF NOT EXISTS v_T_2390 AS SELECT a FROM T; ALTER TABLE T DROP COLUMN b; DELETE FROM T WHERE a IS NULL; INSERT INTO T VALUES ('x', 1, NULL) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c; ALTER TABLE T RENAME TO T_r4177; ALTER TABLE T RENAME TO T_r7895; PRAGMA schema_version = 5; DETACH DATABASE aux78; ATTACH DATABASE ':memory:' AS aux78; BEGIN IMMEDIATE TRANSACTION; PRAGMA recursive_triggers; .exit CAST(zeroblob('"') AS DATETIME) CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (glob('?', 'hello'),'a',abs(x'84a9ab1d')), (json_extract(datetime(atanh(CAST(1 AS INT)), '+1 day'), '$[0]'),'b',-7.75), (2,'c',-9e999); SELECT b,a,c, RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T; INSERT AND FAIL INTO T VALUES (-1, 3, 0); PRAGMA quick_check(20); SELECT MAX(c) FILTER (WHERE c IS NOT NULL) OVER (PARTITION BY c ORDER BY c RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING) FROM T; ANALYZE T; END TRANSACTION; ALTER TABLE T ADD COLUMN extra_4706 NCHAR(55) NOT NULL DEFAULT 0; SELECT COUNT(*) FROM T; CREATE TEMP VIEW IF NOT EXISTS v_T_2390 AS SELECT a FROM T; ALTER TABLE T DROP COLUMN b; DELETE FROM T WHERE a IS NULL; INSERT INTO T VALUES ('x', 1, NULL) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c; ALTER TABLE T RENAME TO T_r4177; ALTER TABLE T RENAME TO T_r7895; PRAGMA schema_version = 5; DETACH DATABASE aux78; ATTACH DATABASE ':memory:' AS aux78; BEGIN IMMEDIATE TRANSACTION; PRAGMA recursive_triggers; .exit CAST(zeroblob('"') AS DATETIME) CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (glob('?', 'hello'),'a',abs(x'84a9ab1d')), (json_extract(datetime(atanh(CAST(1 AS INT)), '+1 day'), '$[0]'),'b',-7.75), (2,'c',-9e999); SELECT b,a,c, RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T; INSERT AND FAIL INTO T VALUES (-1, 3, 0); PRAGMA quick_check(20); SELECT MAX(c) FILTER (WHERE c IS NOT NULL) OVER (PARTITION BY c ORDER BY c RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING) FROM T; ANALYZE T; END TRANSACTION; ALTER TABLE T ADD COLUMN extra_4706 NCHAR(55) NOT NULL DEFAULT 0; SELECT COUNT(*) FROM T; CREATE TEMP VIEW IF NOT EXISTS v_T_2390 AS SELECT a FROM T; ALTER TABLE T DROP COLUMN b; DELETE FROM T WHERE a IS NULL; INSERT INTO T VALUES ('x', 1, NULL) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c; ALTER TABLE T RENAME TO T_r4177; ALTER TABLE T RENAME TO T_r7895; PRAGMA schema_version = 5; DETACH DATABASE aux78; ATTACH DATABASE ':memory:' AS aux78; BEGIN IMMEDIATE TRANSACTION; PRAGMA recursive_triggers; .exit CAST(zeroblob('"') AS DATETIME) CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (glob('?', 'hello'),'a',abs(x'84a9ab1d')), (json_extract(datetime(atanh(CAST(1 AS INT)), '+1 day'), '$[0]'),'b',-7.75), (2,'c',-9e999); SELECT b,a,c, RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T; INSERT AND FAIL INTO T VALUES (-1, 3, 0); PRAGMA quick_check(20); SELECT MAX(c) FILTER (WHERE c IS NOT NULL) OVER (PARTITION BY c ORDER BY c RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING) FROM T; ANALYZE T; END TRANSACTION; ALTER TABLE T ADD COLUMN extra_4706 NCHAR(55) NOT NULL DEFAULT 0; SELECT COUNT(*) FROM T; CREATE TEMP VIEW IF NOT EXISTS v_T_2390 AS SELECT a FROM T; ALTER TABLE T DROP COLUMN b; DELETE FROM T WHERE a IS NULL; INSERT INTO T VALUES ('x', 1, NULL) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c; ALTER TABLE T RENAME TO T_r4177; ALTER TABLE T RENAME TO T_r7895; PRAGMA schema_version = 5; DETACH DATABASE aux78; ATTACH DATABASE ':memory:' AS aux78; BEGIN IMMEDIATE TRANSACTION; PRAGMA recursive_triggers; .exit CAST(zeroblob('"') AS DATETIME) CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (glob('?', 'hello'),'a',abs(x'84a9ab1d')), (json_extract(datetime(atanh(CAST(1 AS INT)), '+1 day'), '$[0]'),'b',-7.75), (2,'c',-9e999); SELECT b,a,c, RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T; INSERT AND FAIL INTO T VALUES (-1, 3, 0); PRAGMA quick_check(20); SELECT MAX(c) FILTER (WHERE c IS NOT NULL) OVER (PARTITION BY c ORDER BY c RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING) FROM T; ANALYZE T; END TRANSACTION; ALTER TABLE T ADD COLUMN extra_4706 NCHAR(55) NOT NULL DEFAULT 0; SELECT COUNT(*) FROM T; CREATE TEMP VIEW IF NOT EXISTS v_T_2390 AS SELECT a FROM T; ALTER TABLE T DROP COLUMN b; DELETE FROM T WHERE a IS NULL; INSERT INTO T VALUES ('x', 1, NULL) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c; ALTER TABLE T RENAME TO T_r4177; ALTER TABLE T RENAME TO T_r7895; PRAGMA schema_version = 5; DETACH DATABASE aux78; SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM T; SELECT NTH_VALUE(b, 2) OVER (PARTITION BY b ORDER BY b RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE NO OTHERS) FROM T; SELECT AVG(b) FROM T; DROP VIEW IF EXISTS T; VACUUM main; INSERT INTO T DEFAULT VALUES; ALTER TABLE T DROP COLUMN b; SELECT COUNT(*) FILTER (WHERE b IS NOT NULL), SUM(rowid) FILTER (WHERE b > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(b) FILTER (WHERE b > 0 AND b < 100), COUNT(*) FILTER (WHERE typeof(b) = "text") FROM T; CREATE UNIQUE INDEX IF NOT EXISTS idx_T_4427 ON T(lower(b)); ALTER TABLE T DROP COLUMN a; CREATE INDEX IF NOT EXISTS idx_T_4716 ON T(c COLLATE NOCASE); VACUUM main; INSERT INTO T VALUES (NULL, NULL, NULL); UPDATE T SET a = CURRENT_TIMESTAMP WHERE a IS NOT NULL RETURNING *; SELECT * FROM T FULL JOIN T; UPDATE T SET a = '' WHERE a BETWEEN 0 AND 100; INSERT OR ROLLBACK INTO T VALUES (0, 'x', 0); ALTER TABLE T ADD COLUMN extra_3521 CHARACTER(20) DEFAULT (random()); CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',0.0); CREATE TABLE T ( a INTEGER, b REAL ); INSERT INTO T VALUES (1,1.5), (2,-7.25), (3,0.0); SELECT a,b FROM T WHERE a >= 2 ORDER BY b; SELECT * FROM T WHERE c < 2.0 ORDER BY c; SELECT * FROM T WHERE a = (SELECT COUNT(*) FROM T); INSERT INTO T VALUES (NULL, 'x', NULL) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c; ALTER TABLE T RENAME COLUMN a TO a_r6404; INSERT INTO T DEFAULT VALUES; ROLLBACK TRANSACTION TO SAVEPOINT sp3957; RELEASE SAVEPOINT sp3957; END; DELETE FROM T WHERE b > (SELECT AVG(b) FROM T) RETURNING *; ALTER TABLE T DROP COLUMN c; ALTER TABLE T RENAME COLUMN a TO a_r6310; SELECT * FROM (SELECT a, COUNT(*) FROM T GROUP BY a) AS sub; SELECT * FROM T; PRAGMA encoding = 'UTF-16be'; SELECT * FROM T NATURAL JOIN T; DROP TABLE IF EXISTS T; SELECT * FROM T WHERE b <= ANY (SELECT b FROM T); ALTER TABLE T RENAME COLUMN c TO c_r1983; SELECT AVG(c) FROM T; INSERT INTO T SELECT * FROM T; SELECT GROUP_CONCAT(c, '|') FROM T; ALTER TABLE T ADD COLUMN extra_8345 BOOLEAN DEFAULT (random()); PRAGMA empty_result_callbacks = YES; SELECT * FROM T; ANALYZE; DROP VIEW IF EXISTS T; DROP TABLE IF EXISTS T; CREATE VIEW IF NOT EXISTS v_T_5407 AS SELECT a FROM T; SELECT COUNT(*) FROM T; REINDEX T; SELECT * FROM T; REINDEX T; ROLLBACK TO sp8767; RELEASE sp8767; SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.b = T.b); CREATE TEMP VIEW IF NOT EXISTS v_t1_7429 AS SELECT b FROM t1; ``` ## Actual output ```sql Memory Used: 79040 (max 80592) bytes Number of Outstanding Allocations: 164 (max 178) Number of Pcache Overflow Bytes: 16928 (max 16928) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 88) Successful lookaside attempts: 107 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: 1088 bytes Statement Heap/Lookaside Usage: 2496 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: 2496 Bytes received by read(): 10665 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 Memory Used: 76568 (max 82248) bytes Number of Outstanding Allocations: 153 (max 178) Number of Pcache Overflow Bytes: 16928 (max 16928) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 41 (max 88) Successful lookaside attempts: 129 Lookaside failures due to size: 0 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: 1112 bytes Statement Heap/Lookaside Usage: 3296 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 16 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3296 Bytes received by read(): 10760 Bytes sent to write(): 1294 Read() system calls: 16 Write() system calls: 1 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 76568 (max 82248) bytes Number of Outstanding Allocations: 153 (max 178) Number of Pcache Overflow Bytes: 16928 (max 16928) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 41 (max 88) Successful lookaside attempts: 151 Lookaside failures due to size: 0 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: 1112 bytes Statement Heap/Lookaside Usage: 3296 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 16 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3296 Bytes received by read(): 10858 Bytes sent to write(): 2591 Read() system calls: 18 Write() system calls: 2 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 76568 (max 82248) bytes Number of Outstanding Allocations: 153 (max 178) Number of Pcache Overflow Bytes: 16928 (max 16928) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 41 (max 88) Successful lookaside attempts: 173 Lookaside failures due to size: 0 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: 1112 bytes Statement Heap/Lookaside Usage: 3296 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 16 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3296 Bytes received by read(): 10956 Bytes sent to write(): 3888 Read() system calls: 20 Write() system calls: 3 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 83992 (max 93784) bytes Number of Outstanding Allocations: 173 (max 185) Number of Pcache Overflow Bytes: 21288 (max 21288) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 92) Successful lookaside attempts: 253 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 17936 bytes Page cache hits: 5 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1312 bytes Statement Heap/Lookaside Usage: 2784 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 56 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2784 Bytes received by read(): 11054 Bytes sent to write(): 5185 Read() system calls: 22 Write() system calls: 4 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 81136 (max 93784) bytes Number of Outstanding Allocations: 156 (max 185) Number of Pcache Overflow Bytes: 21288 (max 21288) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 35 (max 92) Successful lookaside attempts: 258 Lookaside failures due to size: 0 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: 1312 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(): 11152 Bytes sent to write(): 6482 Read() system calls: 24 Write() system calls: 5 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 CREATE TABLE "t2"("b","c","_ROWID_",PRIMARY KEY("b","c","_ROWID_"))WITHOUT ROWID; WARNING: writing to an imposter table will corrupt the "t1bc" index! Braun|30|3 Wernher|10|1 von|20|2 Memory Used: 81696 (max 93784) bytes Number of Outstanding Allocations: 166 (max 185) Number of Pcache Overflow Bytes: 21288 (max 21288) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 45 (max 97) Successful lookaside attempts: 381 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 17936 bytes Page cache hits: 5 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1856 bytes Statement Heap/Lookaside Usage: 4752 bytes Fullscan Steps: 2 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 21 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4752 Bytes received by read(): 11250 Bytes sent to write(): 7929 Read() system calls: 26 Write() system calls: 7 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Braun|30 Wernher|10 von|20 Memory Used: 81720 (max 93784) bytes Number of Outstanding Allocations: 167 (max 185) Number of Pcache Overflow Bytes: 21288 (max 21288) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 45 (max 97) Successful lookaside attempts: 420 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: 1880 bytes Statement Heap/Lookaside Usage: 4752 bytes Fullscan Steps: 2 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 19 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4752 Bytes received by read(): 11348 Bytes sent to write(): 9259 Read() system calls: 28 Write() system calls: 8 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Expectation ```sql Memory Used: 79504 (max 81040) bytes Number of Outstanding Allocations: 174 (max 188) Number of Pcache Overflow Bytes: 16936 (max 16936) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 97) Successful lookaside attempts: 116 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: 904 bytes Statement Heap/Lookaside Usage: 2352 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: 2352 Bytes received by read(): 11185 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 Memory Used: 77160 (max 82792) bytes Number of Outstanding Allocations: 163 (max 188) Number of Pcache Overflow Bytes: 16936 (max 16936) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 57 (max 97) Successful lookaside attempts: 138 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 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: 912 bytes Statement Heap/Lookaside Usage: 3296 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 16 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3296 Bytes received by read(): 11280 Bytes sent to write(): 1332 Read() system calls: 16 Write() system calls: 1 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 77160 (max 82792) bytes Number of Outstanding Allocations: 163 (max 188) Number of Pcache Overflow Bytes: 16936 (max 16936) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 57 (max 97) Successful lookaside attempts: 160 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 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: 912 bytes Statement Heap/Lookaside Usage: 3296 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 16 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3296 Bytes received by read(): 11378 Bytes sent to write(): 2667 Read() system calls: 18 Write() system calls: 2 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 77160 (max 82792) bytes Number of Outstanding Allocations: 163 (max 188) Number of Pcache Overflow Bytes: 16936 (max 16936) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 57 (max 97) Successful lookaside attempts: 182 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 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: 912 bytes Statement Heap/Lookaside Usage: 3296 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 16 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3296 Bytes received by read(): 11476 Bytes sent to write(): 4002 Read() system calls: 20 Write() system calls: 3 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 84376 (max 94104) bytes Number of Outstanding Allocations: 181 (max 193) Number of Pcache Overflow Bytes: 21304 (max 21304) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 101) Successful lookaside attempts: 255 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 17960 bytes Page cache hits: 5 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1120 bytes Statement Heap/Lookaside Usage: 2576 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 56 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2576 Bytes received by read(): 11574 Bytes sent to write(): 5337 Read() system calls: 22 Write() system calls: 4 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 81736 (max 94104) bytes Number of Outstanding Allocations: 166 (max 193) Number of Pcache Overflow Bytes: 21304 (max 21304) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 51 (max 101) Successful lookaside attempts: 260 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 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: 1120 bytes Statement Heap/Lookaside Usage: 2528 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 5 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2528 Bytes received by read(): 11672 Bytes sent to write(): 6674 Read() system calls: 24 Write() system calls: 5 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 CREATE TABLE "t2"("b","c","_ROWID_",PRIMARY KEY("b","c","_ROWID_"))WITHOUT ROWID; Braun|30|3 Wernher|10|1 von|20|2 Memory Used: 82216 (max 94104) bytes Number of Outstanding Allocations: 176 (max 193) Number of Pcache Overflow Bytes: 21304 (max 21304) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 58 (max 102) Successful lookaside attempts: 373 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 17960 bytes Page cache hits: 5 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1600 bytes Statement Heap/Lookaside Usage: 4368 bytes Fullscan Steps: 2 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 21 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4368 Bytes received by read(): 11770 Bytes sent to write(): 8092 Read() system calls: 26 Write() system calls: 7 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Braun|30 Wernher|10 von|20 Memory Used: 82224 (max 94104) bytes Number of Outstanding Allocations: 177 (max 193) Number of Pcache Overflow Bytes: 21304 (max 21304) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 59 (max 102) Successful lookaside attempts: 410 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 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: 1608 bytes Statement Heap/Lookaside Usage: 4496 bytes Fullscan Steps: 2 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 19 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4496 Bytes received by read(): 11868 Bytes sent to write(): 9462 Read() system calls: 28 Write() system calls: 8 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Flag ``` -stats ```