## Summary **No review yet** ## Minimized query ```sql PRAGMA read_uncommitted = YES; .timer on ATTACH DATABASE ':memory:' AS aux58; PRAGMA wal_checkpoint('PASSIVE'); PRAGMA fullsync = ON; PRAGMA locking_mode; PRAGMA synchronous = '1'; .stats on CREATE TABLE map_integer (id INT, name); inSErt INTO map_integer VALUES(NULL,'a'); CREATE TABLE map_text (id TEXT, name); INSERT INTO map_text VALUES('4','e'); CREATE TABLE main.data (id TEXT, name); INSERT INTO data VALUES(cosh(2147483648),'abc'); INSERT INTO data VALUES('4','xyz'); CREATE VIEW idmap as SELECT * FROM map_integer UNION SELECT * FROM map_text; CREATE TABLE mzed AS SELECT * FROM idmap; PRAGMA automatic_index=ON; SELECT * FROM data JoiN idmap USING(id); REINDEX map_text; PRAGMA cache_spill = ON; INSERT OR ABORT INTO map_integer VALUES ('', NULL); CREATE UNIQUE INDEX IF NOT EXISTS idx_map_integer_3605 ON map_integer(id) WHERE id > 0; WITH cte AS (SELECT * FROM map_integer WHERE name IS NOT NULL) SELECT * FROM cte; DETACH DATABASE aux58; SELECT * FROM map_text AS a RIGHT JOIN data AS b ON a.rowid = b.rowid; INSERT INTO map_integer VALUES (NULL, NULL); CREATE VIEW IF NOT EXISTS v_map_text_2756 AS SELECT id FROM map_text; ALTER TABLE data RENAME TO data_r7130; INSERT INTO map_text DEFAULT VALUES; ``` ## Actual output ```sql Run Time: real 0.001 user 0.000000 sys 0.000236 0|-1|-1 Run Time: real 0.000 user 0.000000 sys 0.000015 Run Time: real 0.000 user 0.000000 sys 0.000004 normal Run Time: real 0.000 user 0.000000 sys 0.000006 Run Time: real 0.000 user 0.000000 sys 0.000004 Memory Used: 91096 (max 92648) bytes Number of Outstanding Allocations: 179 (max 193) Number of Pcache Overflow Bytes: 25392 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 90) Successful lookaside attempts: 243 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22840 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1376 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(): 7784 Bytes sent to write(): 255 Read() system calls: 14 Write() system calls: 5 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000 user 0.000000 sys 0.000225 Memory Used: 88688 (max 94368) bytes Number of Outstanding Allocations: 168 (max 193) Number of Pcache Overflow Bytes: 25392 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 41 (max 90) Successful lookaside attempts: 261 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22840 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1400 bytes Statement Heap/Lookaside Usage: 3040 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: 3040 Bytes received by read(): 7880 Bytes sent to write(): 1598 Read() system calls: 16 Write() system calls: 6 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000 user 0.000000 sys 0.000041 Memory Used: 95704 (max 101384) bytes Number of Outstanding Allocations: 187 (max 202) Number of Pcache Overflow Bytes: 29752 (max 29752) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 90) Successful lookaside attempts: 336 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 27184 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1648 bytes Statement Heap/Lookaside Usage: 2400 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: 2400 Bytes received by read(): 7977 Bytes sent to write(): 2942 Read() system calls: 18 Write() system calls: 7 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000 user 0.000000 sys 0.000100 Memory Used: 93328 (max 101384) bytes Number of Outstanding Allocations: 176 (max 202) Number of Pcache Overflow Bytes: 29752 (max 29752) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 42 (max 90) Successful lookaside attempts: 355 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 27184 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1672 bytes Statement Heap/Lookaside Usage: 3168 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: 3168 Bytes received by read(): 8074 Bytes sent to write(): 4287 Read() system calls: 20 Write() system calls: 8 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000 user 0.000000 sys 0.000026 Memory Used: 100344 (max 106024) bytes Number of Outstanding Allocations: 195 (max 210) Number of Pcache Overflow Bytes: 34112 (max 34112) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 90) Successful lookaside attempts: 430 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31528 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1920 bytes Statement Heap/Lookaside Usage: 2400 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: 2400 Bytes received by read(): 8171 Bytes sent to write(): 5632 Read() system calls: 22 Write() system calls: 9 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000 user 0.000000 sys 0.000074 Memory Used: 97968 (max 106024) bytes Number of Outstanding Allocations: 184 (max 210) Number of Pcache Overflow Bytes: 34112 (max 34112) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 43 (max 90) Successful lookaside attempts: 456 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31528 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1944 bytes Statement Heap/Lookaside Usage: 3296 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: 3296 Bytes received by read(): 8268 Bytes sent to write(): 6978 Read() system calls: 24 Write() system calls: 10 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000 user 0.000000 sys 0.000045 Memory Used: 97968 (max 106024) bytes Number of Outstanding Allocations: 184 (max 210) Number of Pcache Overflow Bytes: 34112 (max 34112) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 42 (max 90) Successful lookaside attempts: 475 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31528 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1944 bytes Statement Heap/Lookaside Usage: 3168 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: 3168 Bytes received by read(): 8366 Bytes sent to write(): 8324 Read() system calls: 26 Write() system calls: 11 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000 user 0.000000 sys 0.000020 Memory Used: 101512 (max 108200) bytes Number of Outstanding Allocations: 209 (max 235) Number of Pcache Overflow Bytes: 34112 (max 34112) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 90) Successful lookaside attempts: 550 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31528 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2984 bytes Statement Heap/Lookaside Usage: 2496 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: 2496 Bytes received by read(): 8464 Bytes sent to write(): 9670 Read() system calls: 28 Write() system calls: 12 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000 user 0.000000 sys 0.000090 Memory Used: 108752 (max 212832) bytes Number of Outstanding Allocations: 230 (max 271) Number of Pcache Overflow Bytes: 38472 (max 46680) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 102) Successful lookaside attempts: 638 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 35872 bytes Page cache hits: 7 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3320 bytes Statement Heap/Lookaside Usage: 4960 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 82 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4960 Bytes received by read(): 8562 Bytes sent to write(): 11017 Read() system calls: 30 Write() system calls: 13 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.001 user 0.000000 sys 0.000201 Memory Used: 103720 (max 212832) bytes Number of Outstanding Allocations: 207 (max 271) Number of Pcache Overflow Bytes: 38472 (max 46680) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 102) Successful lookaside attempts: 643 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 35872 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3320 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(): 8661 Bytes sent to write(): 12366 Read() system calls: 32 Write() system calls: 14 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000 user 0.000000 sys 0.000020 Memory Used: 107336 (max 314624) bytes Number of Outstanding Allocations: 209 (max 271) Number of Pcache Overflow Bytes: 38472 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 61 (max 104) Successful lookaside attempts: 756 Lookaside failures due to size: 3 Lookaside failures due to OOM: 0 Pager Heap Usage: 35872 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3320 bytes Statement Heap/Lookaside Usage: 11104 bytes Fullscan Steps: 1 Sort Operations: 0 Autoindex Inserts: 1 Bloom filter bypass taken: 2/2 Virtual Machine Steps: 68 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 11104 Bytes received by read(): 8760 Bytes sent to write(): 13714 Read() system calls: 34 Write() system calls: 15 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000 user 0.000000 sys 0.000154 Memory Used: 103720 (max 314624) bytes Number of Outstanding Allocations: 207 (max 271) Number of Pcache Overflow Bytes: 38472 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 104) Successful lookaside attempts: 761 Lookaside failures due to size: 3 Lookaside failures due to OOM: 0 Pager Heap Usage: 35872 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3320 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(): 8859 Bytes sent to write(): 15106 Read() system calls: 36 Write() system calls: 16 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000 user 0.000000 sys 0.000018 Memory Used: 103720 (max 314624) bytes Number of Outstanding Allocations: 207 (max 271) Number of Pcache Overflow Bytes: 38472 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 104) Successful lookaside attempts: 766 Lookaside failures due to size: 3 Lookaside failures due to OOM: 0 Pager Heap Usage: 35872 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3320 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(): 8958 Bytes sent to write(): 16454 Read() system calls: 38 Write() system calls: 17 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000 user 0.000000 sys 0.000017 Memory Used: 103720 (max 314624) bytes Number of Outstanding Allocations: 207 (max 271) Number of Pcache Overflow Bytes: 38472 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 41 (max 104) Successful lookaside attempts: 784 Lookaside failures due to size: 3 Lookaside failures due to OOM: 0 Pager Heap Usage: 35872 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3320 bytes Statement Heap/Lookaside Usage: 3040 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: 3040 Bytes received by read(): 9057 Bytes sent to write(): 17802 Read() system calls: 40 Write() system calls: 18 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000 user 0.000000 sys 0.000027 Memory Used: 112408 (max 314624) bytes Number of Outstanding Allocations: 231 (max 271) Number of Pcache Overflow Bytes: 42832 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 104) Successful lookaside attempts: 865 Lookaside failures due to size: 3 Lookaside failures due to OOM: 0 Pager Heap Usage: 40216 bytes Page cache hits: 5 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3752 bytes Statement Heap/Lookaside Usage: 3832 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 42 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3832 Bytes received by read(): 9156 Bytes sent to write(): 19151 Read() system calls: 42 Write() system calls: 19 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000 user 0.000000 sys 0.000107 |a Memory Used: 108520 (max 314624) bytes Number of Outstanding Allocations: 213 (max 271) Number of Pcache Overflow Bytes: 42832 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 46 (max 104) Successful lookaside attempts: 930 Lookaside failures due to size: 3 Lookaside failures due to OOM: 0 Pager Heap Usage: 40216 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3752 bytes Statement Heap/Lookaside Usage: 4752 bytes Fullscan Steps: 1 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 15 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4752 Bytes received by read(): 9255 Bytes sent to write(): 20500 Read() system calls: 44 Write() system calls: 20 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000 user 0.000000 sys 0.000047 Memory Used: 96304 (max 314624) bytes Number of Outstanding Allocations: 196 (max 271) Number of Pcache Overflow Bytes: 34368 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 104) Successful lookaside attempts: 936 Lookaside failures due to size: 3 Lookaside failures due to OOM: 0 Pager Heap Usage: 30968 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3384 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(): 9354 Bytes sent to write(): 21852 Read() system calls: 46 Write() system calls: 21 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000 user 0.000000 sys 0.000022 4|e|Inf|abc ||4|xyz Memory Used: 96304 (max 314624) bytes Number of Outstanding Allocations: 196 (max 271) Number of Pcache Overflow Bytes: 34368 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 56 (max 104) Successful lookaside attempts: 1021 Lookaside failures due to size: 4 Lookaside failures due to OOM: 0 Pager Heap Usage: 30968 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3384 bytes Statement Heap/Lookaside Usage: 7232 bytes Fullscan Steps: 1 Sort Operations: 0 Autoindex Inserts: 0 Bloom filter bypass taken: 1/2 Virtual Machine Steps: 43 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 7232 Bytes received by read(): 9453 Bytes sent to write(): 23199 Read() system calls: 48 Write() system calls: 22 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000 user 0.000000 sys 0.000062 Memory Used: 96304 (max 314624) bytes Number of Outstanding Allocations: 196 (max 271) Number of Pcache Overflow Bytes: 34368 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 46 (max 104) Successful lookaside attempts: 1052 Lookaside failures due to size: 4 Lookaside failures due to OOM: 0 Pager Heap Usage: 30968 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3384 bytes Statement Heap/Lookaside Usage: 4880 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: 4880 Bytes received by read(): 9552 Bytes sent to write(): 24609 Read() system calls: 50 Write() system calls: 23 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000 user 0.000000 sys 0.000030 Memory Used: 99400 (max 314624) bytes Number of Outstanding Allocations: 217 (max 271) Number of Pcache Overflow Bytes: 34368 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 32 (max 104) Successful lookaside attempts: 1127 Lookaside failures due to size: 4 Lookaside failures due to OOM: 0 Pager Heap Usage: 30968 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 4008 bytes Statement Heap/Lookaside Usage: 2464 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: 2464 Bytes received by read(): 9651 Bytes sent to write(): 25958 Read() system calls: 52 Write() system calls: 24 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000 user 0.000000 sys 0.000080 Memory Used: 211760 (max 585176) bytes Number of Outstanding Allocations: 244 (max 331) Number of Pcache Overflow Bytes: 42576 (max 67200) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 102 (max 123) Successful lookaside attempts: 1465 Lookaside failures due to size: 7 Lookaside failures due to OOM: 167 Pager Heap Usage: 40184 bytes Page cache hits: 10 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3912 bytes Statement Heap/Lookaside Usage: 47720 bytes Fullscan Steps: 18 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 325 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 47720 Bytes received by read(): 9750 Bytes sent to write(): 27307 Read() system calls: 54 Write() system calls: 25 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.001 user 0.000000 sys 0.000783 Memory Used: 195536 (max 585176) bytes Number of Outstanding Allocations: 208 (max 331) Number of Pcache Overflow Bytes: 42576 (max 67200) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 38 (max 123) Successful lookaside attempts: 1478 Lookaside failures due to size: 7 Lookaside failures due to OOM: 167 Pager Heap Usage: 40184 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 3936 bytes Statement Heap/Lookaside Usage: 2912 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: 2912 Bytes received by read(): 9849 Bytes sent to write(): 28665 Read() system calls: 57 Write() system calls: 26 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000 user 0.000000 sys 0.000027 ``` ## Expectation ```sql Run Time: real 0.000077 user 0.000089 sys 0.000000 0|-1|-1 Run Time: real 0.000006 user 0.000007 sys 0.000000 Run Time: real 0.000002 user 0.000002 sys 0.000000 normal Run Time: real 0.000002 user 0.000003 sys 0.000000 Run Time: real 0.000002 user 0.000002 sys 0.000000 Memory Used: 91600 (max 93136) bytes Number of Outstanding Allocations: 189 (max 203) Number of Pcache Overflow Bytes: 25408 (max 25408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 50 (max 99) Successful lookaside attempts: 242 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22864 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: 1176 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(): 8304 Bytes sent to write(): 270 Read() system calls: 14 Write() system calls: 5 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000113 user 0.000113 sys 0.000000 Memory Used: 89272 (max 94904) bytes Number of Outstanding Allocations: 178 (max 203) Number of Pcache Overflow Bytes: 25408 (max 25408) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 57 (max 99) Successful lookaside attempts: 260 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22864 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: 1184 bytes Statement Heap/Lookaside Usage: 3040 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: 3040 Bytes received by read(): 8400 Bytes sent to write(): 1655 Read() system calls: 16 Write() system calls: 6 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000028 user 0.000029 sys 0.000000 Memory Used: 96184 (max 101816) bytes Number of Outstanding Allocations: 197 (max 212) Number of Pcache Overflow Bytes: 29776 (max 29776) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 50 (max 99) Successful lookaside attempts: 328 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 27216 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: 1408 bytes Statement Heap/Lookaside Usage: 2320 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: 2320 Bytes received by read(): 8497 Bytes sent to write(): 3041 Read() system calls: 18 Write() system calls: 7 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000048 user 0.000048 sys 0.000000 Memory Used: 93872 (max 101816) bytes Number of Outstanding Allocations: 186 (max 212) Number of Pcache Overflow Bytes: 29776 (max 29776) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 58 (max 99) Successful lookaside attempts: 347 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 27216 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: 1416 bytes Statement Heap/Lookaside Usage: 3168 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: 3168 Bytes received by read(): 8594 Bytes sent to write(): 4428 Read() system calls: 20 Write() system calls: 8 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000016 user 0.000016 sys 0.000000 Memory Used: 100760 (max 106392) bytes Number of Outstanding Allocations: 205 (max 220) Number of Pcache Overflow Bytes: 34144 (max 34144) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 50 (max 99) Successful lookaside attempts: 415 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31568 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: 1632 bytes Statement Heap/Lookaside Usage: 2304 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: 2304 Bytes received by read(): 8691 Bytes sent to write(): 5815 Read() system calls: 22 Write() system calls: 9 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000038 user 0.000038 sys 0.000000 Memory Used: 98464 (max 106392) bytes Number of Outstanding Allocations: 194 (max 220) Number of Pcache Overflow Bytes: 34144 (max 34144) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 59 (max 99) Successful lookaside attempts: 441 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31568 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: 1640 bytes Statement Heap/Lookaside Usage: 3296 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: 3296 Bytes received by read(): 8788 Bytes sent to write(): 7203 Read() system calls: 24 Write() system calls: 10 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000028 user 0.000029 sys 0.000000 Memory Used: 98464 (max 106392) bytes Number of Outstanding Allocations: 194 (max 220) Number of Pcache Overflow Bytes: 34144 (max 34144) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 58 (max 99) Successful lookaside attempts: 460 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31568 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: 1640 bytes Statement Heap/Lookaside Usage: 3168 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: 3168 Bytes received by read(): 8886 Bytes sent to write(): 8591 Read() system calls: 26 Write() system calls: 11 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000014 user 0.000014 sys 0.000000 Memory Used: 101960 (max 108408) bytes Number of Outstanding Allocations: 220 (max 245) Number of Pcache Overflow Bytes: 34144 (max 34144) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 50 (max 99) Successful lookaside attempts: 528 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 31568 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: 2752 bytes Statement Heap/Lookaside Usage: 2384 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: 2384 Bytes received by read(): 8984 Bytes sent to write(): 9979 Read() system calls: 28 Write() system calls: 12 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000069 user 0.000069 sys 0.000000 Memory Used: 108984 (max 213184) bytes Number of Outstanding Allocations: 237 (max 279) Number of Pcache Overflow Bytes: 38512 (max 46712) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 50 (max 111) Successful lookaside attempts: 609 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 35920 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: 3040 bytes Statement Heap/Lookaside Usage: 4688 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 82 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4688 Bytes received by read(): 9082 Bytes sent to write(): 11368 Read() system calls: 30 Write() system calls: 13 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000138 user 0.000139 sys 0.000000 Memory Used: 104232 (max 213184) bytes Number of Outstanding Allocations: 218 (max 279) Number of Pcache Overflow Bytes: 38512 (max 46712) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 53 (max 111) Successful lookaside attempts: 614 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 35920 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: 3040 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(): 9181 Bytes sent to write(): 12759 Read() system calls: 32 Write() system calls: 14 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000014 user 0.000014 sys 0.000000 4|xyz|e Memory Used: 106600 (max 314168) bytes Number of Outstanding Allocations: 219 (max 279) Number of Pcache Overflow Bytes: 38512 (max 54912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 72 (max 113) Successful lookaside attempts: 727 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 35920 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: 3040 bytes Statement Heap/Lookaside Usage: 13504 bytes Fullscan Steps: 1 Sort Operations: 0 Autoindex Inserts: 0 Bloom filter bypass taken: 0/2 Virtual Machine Steps: 73 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 13504 Bytes received by read(): 9280 Bytes sent to write(): 14149 Read() system calls: 34 Write() system calls: 15 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000114 user 0.000113 sys 0.000000 Memory Used: 104232 (max 314168) bytes Number of Outstanding Allocations: 218 (max 279) Number of Pcache Overflow Bytes: 38512 (max 54912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 53 (max 113) Successful lookaside attempts: 732 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 35920 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: 3040 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(): 9379 Bytes sent to write(): 15591 Read() system calls: 36 Write() system calls: 16 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000013 user 0.000013 sys 0.000000 Memory Used: 104232 (max 314168) bytes Number of Outstanding Allocations: 218 (max 279) Number of Pcache Overflow Bytes: 38512 (max 54912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 53 (max 113) Successful lookaside attempts: 737 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 35920 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: 3040 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(): 9478 Bytes sent to write(): 16981 Read() system calls: 38 Write() system calls: 17 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000012 user 0.000013 sys 0.000000 Memory Used: 104232 (max 314168) bytes Number of Outstanding Allocations: 218 (max 279) Number of Pcache Overflow Bytes: 38512 (max 54912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 57 (max 113) Successful lookaside attempts: 755 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 35920 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: 3040 bytes Statement Heap/Lookaside Usage: 3040 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: 3040 Bytes received by read(): 9577 Bytes sent to write(): 18371 Read() system calls: 40 Write() system calls: 18 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000018 user 0.000019 sys 0.000000 Memory Used: 112768 (max 314168) bytes Number of Outstanding Allocations: 240 (max 279) Number of Pcache Overflow Bytes: 42880 (max 54912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 50 (max 113) Successful lookaside attempts: 829 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 40272 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: 3472 bytes Statement Heap/Lookaside Usage: 3680 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 42 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3680 Bytes received by read(): 9676 Bytes sent to write(): 19762 Read() system calls: 42 Write() system calls: 19 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000061 user 0.000062 sys 0.000000 |a Memory Used: 109032 (max 314168) bytes Number of Outstanding Allocations: 224 (max 279) Number of Pcache Overflow Bytes: 42880 (max 54912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 59 (max 113) Successful lookaside attempts: 892 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 40272 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: 3472 bytes Statement Heap/Lookaside Usage: 4368 bytes Fullscan Steps: 1 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 15 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4368 Bytes received by read(): 9775 Bytes sent to write(): 21153 Read() system calls: 44 Write() system calls: 20 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000032 user 0.000031 sys 0.000000 Memory Used: 96880 (max 314168) bytes Number of Outstanding Allocations: 207 (max 279) Number of Pcache Overflow Bytes: 34408 (max 54912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 53 (max 113) Successful lookaside attempts: 898 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 31016 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: 3160 bytes Statement Heap/Lookaside Usage: 2784 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 8 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2784 Bytes received by read(): 9874 Bytes sent to write(): 22547 Read() system calls: 46 Write() system calls: 21 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000016 user 0.000016 sys 0.000000 4|e|Inf|abc ||4|xyz Memory Used: 96880 (max 314168) bytes Number of Outstanding Allocations: 207 (max 279) Number of Pcache Overflow Bytes: 34408 (max 54912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 68 (max 113) Successful lookaside attempts: 979 Lookaside failures due to size: 3 Lookaside failures due to OOM: 0 Pager Heap Usage: 31016 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: 3160 bytes Statement Heap/Lookaside Usage: 6720 bytes Fullscan Steps: 1 Sort Operations: 0 Autoindex Inserts: 0 Bloom filter bypass taken: 1/2 Virtual Machine Steps: 43 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 6720 Bytes received by read(): 9973 Bytes sent to write(): 23936 Read() system calls: 48 Write() system calls: 22 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000059 user 0.000060 sys 0.000000 Memory Used: 96880 (max 314168) bytes Number of Outstanding Allocations: 207 (max 279) Number of Pcache Overflow Bytes: 34408 (max 54912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 62 (max 113) Successful lookaside attempts: 1010 Lookaside failures due to size: 3 Lookaside failures due to OOM: 0 Pager Heap Usage: 31016 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: 3160 bytes Statement Heap/Lookaside Usage: 4880 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: 4880 Bytes received by read(): 10072 Bytes sent to write(): 25387 Read() system calls: 50 Write() system calls: 23 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000020 user 0.000021 sys 0.000000 Memory Used: 99792 (max 314168) bytes Number of Outstanding Allocations: 228 (max 279) Number of Pcache Overflow Bytes: 34408 (max 54912) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 48 (max 113) Successful lookaside attempts: 1078 Lookaside failures due to size: 3 Lookaside failures due to OOM: 0 Pager Heap Usage: 31016 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: 3696 bytes Statement Heap/Lookaside Usage: 2376 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: 2376 Bytes received by read(): 10172 Bytes sent to write(): 26779 Read() system calls: 52 Write() system calls: 24 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000049 user 0.000050 sys 0.000000 Memory Used: 211656 (max 583832) bytes Number of Outstanding Allocations: 231 (max 307) Number of Pcache Overflow Bytes: 42608 (max 67208) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 97 (max 123) Successful lookaside attempts: 1417 Lookaside failures due to size: 6 Lookaside failures due to OOM: 111 Pager Heap Usage: 40248 bytes Page cache hits: 10 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 3600 bytes Statement Heap/Lookaside Usage: 35760 bytes Fullscan Steps: 18 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 325 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 35760 Bytes received by read(): 10316 Bytes sent to write(): 28171 Read() system calls: 55 Write() system calls: 25 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000534 user 0.000535 sys 0.000000 Memory Used: 196112 (max 583832) bytes Number of Outstanding Allocations: 218 (max 307) Number of Pcache Overflow Bytes: 42608 (max 67208) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 54 (max 123) Successful lookaside attempts: 1430 Lookaside failures due to size: 6 Lookaside failures due to OOM: 111 Pager Heap Usage: 40248 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: 3608 bytes Statement Heap/Lookaside Usage: 2912 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: 2912 Bytes received by read(): 10416 Bytes sent to write(): 29571 Read() system calls: 58 Write() system calls: 26 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Run Time: real 0.000018 user 0.000018 sys 0.000000 ``` ## Flag ``` ```