46 KiB
46 KiB
Summary
**No review yet**Minimized query
.stats stmt
PRAGMA vdbe_addoptrace = YES;
.eqp off
PRAGMA application_id;
PRAGMA ignore_check_constraints = FALSE;
PRAGMA table_list("users");
.eqp auto
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t2;
CREATE TABLE t1(x);
INSERT INTO t1 VALUES(1);
CREATE TABLE t2(y,z);
INSERT INTO t2 VALUES(2,3);
CREATE INDEX t2y ON t2(y);
WITH _m AS MATERIALIZED (SELECT * FROM t1) SELECT * FROM _m,(SELECT * FROM t2 WHERE y=2 ORDER BY y,z);
INSERT INTO t1 VALUES (NULL);
WITH RECURSIVE vals(x) AS (SELECT z FROM t2 WHERE z IS NOT NULL UNION ALL SELECT z FROM t2 WHERE z IS NOT NULL LIMIT 10) SELECT * FROM vals;
CREATE TRIGGER IF NOT EXISTS trg_t1_3163 AFTER DELETE ON t1 FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'abort'); END;
SELECT * FROM t2 AS a LEFT OUTER JOIN t1 AS b ON a.rowid = b.rowid;
Actual output
Number of output columns: 0
Memory Used: 62592 (max 62592) 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: 35 (max 36)
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: 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(): 7095
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
0
Number of output columns: 1
Column 0 name: application_id
Column 0 declared type: (null)
Memory Used: 66952 (max 66992) bytes
Number of Outstanding Allocations: 123 (max 124)
Number of Pcache Overflow Bytes: 8464 (max 8464) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 36 (max 37)
Successful lookaside attempts: 43
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 9248 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: 6
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2656
Bytes received by read(): 7189
Bytes sent to write(): 1324
Read() system calls: 15
Write() system calls: 1
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Number of output columns: 0
Memory Used: 66952 (max 66992) bytes
Number of Outstanding Allocations: 123 (max 124)
Number of Pcache Overflow Bytes: 8464 (max 8464) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 35 (max 37)
Successful lookaside attempts: 48
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 9248 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: 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(): 7286
Bytes sent to write(): 2749
Read() system calls: 17
Write() system calls: 2
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Number of output columns: 6
Column 0 name: schema
Column 0 declared type: (null)
Column 1 name: name
Column 1 declared type: (null)
Column 2 name: type
Column 2 declared type: (null)
Column 3 name: ncol
Column 3 declared type: (null)
Column 4 name: wr
Column 4 declared type: (null)
Column 5 name: strict
Column 5 declared type: (null)
Memory Used: 67704 (max 67704) 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 76)
Successful lookaside attempts: 103
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 9248 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 736 bytes
Statement Heap/Lookaside Usage: 3856 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: 3856
Bytes received by read(): 7383
Bytes sent to write(): 4076
Read() system calls: 19
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: 67704 (max 67704) 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: 36 (max 76)
Successful lookaside attempts: 110
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(): 7480
Bytes sent to write(): 5975
Read() system calls: 21
Write() system calls: 5
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Number of output columns: 0
Memory Used: 67704 (max 67704) 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: 36 (max 76)
Successful lookaside attempts: 117
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(): 7577
Bytes sent to write(): 7305
Read() system calls: 23
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: 78792 (max 80344) bytes
Number of Outstanding Allocations: 161 (max 175)
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: 192
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: 968 bytes
Statement Heap/Lookaside Usage: 2368 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: 2368
Bytes received by read(): 7930
Bytes sent to write(): 8635
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: 76448 (max 82128) bytes
Number of Outstanding Allocations: 150 (max 175)
Number of Pcache Overflow Bytes: 16928 (max 16928) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 37 (max 88)
Successful lookaside attempts: 207
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: 992 bytes
Statement Heap/Lookaside Usage: 2784 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 9
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2784
Bytes received by read(): 8027
Bytes sent to write(): 9969
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: 83448 (max 89128) bytes
Number of Outstanding Allocations: 169 (max 184)
Number of Pcache Overflow Bytes: 21288 (max 21288) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 32 (max 88)
Successful lookaside attempts: 282
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: 1240 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(): 8124
Bytes sent to write(): 11302
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: 81088 (max 89128) bytes
Number of Outstanding Allocations: 158 (max 184)
Number of Pcache Overflow Bytes: 21288 (max 21288) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 37 (max 88)
Successful lookaside attempts: 298
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: 1264 bytes
Statement Heap/Lookaside Usage: 2784 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: 2784
Bytes received by read(): 8222
Bytes sent to write(): 12638
Read() system calls: 32
Write() system calls: 10
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Number of output columns: 0
Memory Used: 88400 (max 98144) bytes
Number of Outstanding Allocations: 176 (max 187)
Number of Pcache Overflow Bytes: 25648 (max 25648) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 32 (max 91)
Successful lookaside attempts: 377
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: 1448 bytes
Statement Heap/Lookaside Usage: 2704 bytes
Fullscan Steps: 0
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 35
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2704
Bytes received by read(): 8321
Bytes sent to write(): 13975
Read() system calls: 34
Write() system calls: 11
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
1|2|3
Number of output columns: 3
Column 0 name: x
Column 0 declared type: (null)
Column 1 name: y
Column 1 declared type: (null)
Column 2 name: z
Column 2 declared type: (null)
Memory Used: 85664 (max 184392) bytes
Number of Outstanding Allocations: 162 (max 187)
Number of Pcache Overflow Bytes: 25648 (max 33856) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 51 (max 102)
Successful lookaside attempts: 489
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 22280 bytes
Page cache hits: 4
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1472 bytes
Statement Heap/Lookaside Usage: 6592 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 27
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 6592
Bytes received by read(): 8420
Bytes sent to write(): 15312
Read() system calls: 36
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: 85664 (max 184392) bytes
Number of Outstanding Allocations: 162 (max 187)
Number of Pcache Overflow Bytes: 25648 (max 33856) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 37 (max 102)
Successful lookaside attempts: 504
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 22280 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1472 bytes
Statement Heap/Lookaside Usage: 2784 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 9
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2784
Bytes received by read(): 8519
Bytes sent to write(): 16906
Read() system calls: 38
Write() system calls: 13
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
3
3
Number of output columns: 1
Column 0 name: x
Column 0 declared type: (null)
Memory Used: 85664 (max 184392) bytes
Number of Outstanding Allocations: 162 (max 187)
Number of Pcache Overflow Bytes: 25648 (max 33856) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 46 (max 119)
Successful lookaside attempts: 621
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: 1472 bytes
Statement Heap/Lookaside Usage: 7152 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 22
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 7152
Bytes received by read(): 8618
Bytes sent to write(): 18244
Read() system calls: 40
Write() system calls: 14
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Number of output columns: 0
Memory Used: 88224 (max 184392) bytes
Number of Outstanding Allocations: 184 (max 193)
Number of Pcache Overflow Bytes: 25648 (max 33856) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 32 (max 119)
Successful lookaside attempts: 695
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: 2272 bytes
Statement Heap/Lookaside Usage: 1752 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 15
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 1752
Bytes received by read(): 8717
Bytes sent to write(): 19670
Read() system calls: 42
Write() system calls: 15
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
2|3|1
Number of output columns: 3
Column 0 name: y
Column 0 declared type: (null)
Column 1 name: z
Column 1 declared type: (null)
Column 2 name: x
Column 2 declared type: (null)
Memory Used: 86472 (max 184392) bytes
Number of Outstanding Allocations: 173 (max 193)
Number of Pcache Overflow Bytes: 25648 (max 33856) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 48 (max 119)
Successful lookaside attempts: 759
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: 2272 bytes
Statement Heap/Lookaside Usage: 5264 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: 5264
Bytes received by read(): 8816
Bytes sent to write(): 21009
Read() system calls: 45
Write() system calls: 16
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Expectation
Number of output columns: 0
Memory Used: 63416 (max 63416) bytes
Number of Outstanding Allocations: 132 (max 132)
Number of Pcache Overflow Bytes: 4104 (max 4104) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4104 bytes
Lookaside Slots Used: 51 (max 52)
Successful lookaside attempts: 53
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 4904 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 0 bytes
Statement Heap/Lookaside Usage: 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(): 7871
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
0
Number of output columns: 1
Column 0 name: application_id
Column 0 declared type: (null)
Memory Used: 67784 (max 67816) bytes
Number of Outstanding Allocations: 133 (max 134)
Number of Pcache Overflow Bytes: 8472 (max 8472) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 52 (max 53)
Successful lookaside attempts: 59
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 9256 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 0 bytes
Statement Heap/Lookaside Usage: 2656 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 7
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2656
Bytes received by read(): 7965
Bytes sent to write(): 1363
Read() system calls: 16
Write() system calls: 1
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Number of output columns: 0
Memory Used: 67784 (max 67816) bytes
Number of Outstanding Allocations: 133 (max 134)
Number of Pcache Overflow Bytes: 8472 (max 8472) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 51 (max 53)
Successful lookaside attempts: 64
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 9256 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 0 bytes
Statement Heap/Lookaside Usage: 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(): 8062
Bytes sent to write(): 2827
Read() system calls: 18
Write() system calls: 2
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Number of output columns: 6
Column 0 name: schema
Column 0 declared type: (null)
Column 1 name: name
Column 1 declared type: (null)
Column 2 name: type
Column 2 declared type: (null)
Column 3 name: ncol
Column 3 declared type: (null)
Column 4 name: wr
Column 4 declared type: (null)
Column 5 name: strict
Column 5 declared type: (null)
Memory Used: 68416 (max 68416) bytes
Number of Outstanding Allocations: 151 (max 151)
Number of Pcache Overflow Bytes: 8472 (max 8472) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 53 (max 87)
Successful lookaside attempts: 114
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 9256 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: 632 bytes
Statement Heap/Lookaside Usage: 3856 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: 3856
Bytes received by read(): 8159
Bytes sent to write(): 4193
Read() system calls: 20
Write() system calls: 3
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Number of output columns: 0
Memory Used: 68416 (max 68416) bytes
Number of Outstanding Allocations: 151 (max 151)
Number of Pcache Overflow Bytes: 8472 (max 8472) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 52 (max 87)
Successful lookaside attempts: 121
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 9256 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 632 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(): 8256
Bytes sent to write(): 6131
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: 0
Memory Used: 68416 (max 68416) bytes
Number of Outstanding Allocations: 151 (max 151)
Number of Pcache Overflow Bytes: 8472 (max 8472) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 52 (max 87)
Successful lookaside attempts: 128
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 9256 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 632 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(): 8353
Bytes sent to write(): 7500
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: 79352 (max 80888) bytes
Number of Outstanding Allocations: 171 (max 185)
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: 196
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: 832 bytes
Statement Heap/Lookaside Usage: 2272 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: 2272
Bytes received by read(): 8450
Bytes sent to write(): 8869
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: 77088 (max 82720) bytes
Number of Outstanding Allocations: 160 (max 185)
Number of Pcache Overflow Bytes: 16936 (max 16936) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 53 (max 97)
Successful lookaside attempts: 211
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: 840 bytes
Statement Heap/Lookaside Usage: 2784 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 9
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2784
Bytes received by read(): 8547
Bytes sent to write(): 10242
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: 83944 (max 89576) bytes
Number of Outstanding Allocations: 179 (max 194)
Number of Pcache Overflow Bytes: 21304 (max 21304) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 48 (max 97)
Successful lookaside attempts: 279
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 17960 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: 1056 bytes
Statement Heap/Lookaside Usage: 2272 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: 2272
Bytes received by read(): 8645
Bytes sent to write(): 11615
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: 81680 (max 89576) bytes
Number of Outstanding Allocations: 168 (max 194)
Number of Pcache Overflow Bytes: 21304 (max 21304) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 53 (max 97)
Successful lookaside attempts: 295
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: 1064 bytes
Statement Heap/Lookaside Usage: 2784 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: 2784
Bytes received by read(): 8743
Bytes sent to write(): 12990
Read() system calls: 32
Write() system calls: 10
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Number of output columns: 0
Memory Used: 88840 (max 98528) bytes
Number of Outstanding Allocations: 185 (max 196)
Number of Pcache Overflow Bytes: 25672 (max 25672) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 48 (max 100)
Successful lookaside attempts: 367
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 22312 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: 1256 bytes
Statement Heap/Lookaside Usage: 2544 bytes
Fullscan Steps: 0
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 35
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2544
Bytes received by read(): 8842
Bytes sent to write(): 14366
Read() system calls: 34
Write() system calls: 11
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
1|2|3
Number of output columns: 3
Column 0 name: x
Column 0 declared type: (null)
Column 1 name: y
Column 1 declared type: (null)
Column 2 name: z
Column 2 declared type: (null)
Memory Used: 86248 (max 185112) bytes
Number of Outstanding Allocations: 172 (max 196)
Number of Pcache Overflow Bytes: 25672 (max 33872) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 64 (max 116)
Successful lookaside attempts: 478
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 22312 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: 1264 bytes
Statement Heap/Lookaside Usage: 10496 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 29
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 10496
Bytes received by read(): 8941
Bytes sent to write(): 15743
Read() system calls: 36
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: 86248 (max 185112) bytes
Number of Outstanding Allocations: 172 (max 196)
Number of Pcache Overflow Bytes: 25672 (max 33872) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 53 (max 116)
Successful lookaside attempts: 493
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 22312 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: 1264 bytes
Statement Heap/Lookaside Usage: 2784 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 9
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2784
Bytes received by read(): 9040
Bytes sent to write(): 17378
Read() system calls: 38
Write() system calls: 13
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
3
3
Number of output columns: 1
Column 0 name: x
Column 0 declared type: (null)
Memory Used: 86248 (max 185112) bytes
Number of Outstanding Allocations: 172 (max 196)
Number of Pcache Overflow Bytes: 25672 (max 33872) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 58 (max 123)
Successful lookaside attempts: 598
Lookaside failures due to size: 0
Lookaside failures due to OOM: 9
Pager Heap Usage: 22312 bytes
Page cache hits: 3
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1264 bytes
Statement Heap/Lookaside Usage: 4496 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 22
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4496
Bytes received by read(): 9139
Bytes sent to write(): 18755
Read() system calls: 40
Write() system calls: 14
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Number of output columns: 0
Memory Used: 88672 (max 185112) bytes
Number of Outstanding Allocations: 195 (max 204)
Number of Pcache Overflow Bytes: 25672 (max 33872) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 48 (max 123)
Successful lookaside attempts: 665
Lookaside failures due to size: 0
Lookaside failures due to OOM: 9
Pager Heap Usage: 22312 bytes
Page cache hits: 3
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 2016 bytes
Statement Heap/Lookaside Usage: 1672 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 15
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 1672
Bytes received by read(): 9238
Bytes sent to write(): 20220
Read() system calls: 42
Write() system calls: 15
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
2|3|1
Number of output columns: 3
Column 0 name: y
Column 0 declared type: (null)
Column 1 name: z
Column 1 declared type: (null)
Column 2 name: x
Column 2 declared type: (null)
Memory Used: 87000 (max 185112) bytes
Number of Outstanding Allocations: 184 (max 204)
Number of Pcache Overflow Bytes: 25672 (max 33872) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 61 (max 123)
Successful lookaside attempts: 726
Lookaside failures due to size: 0
Lookaside failures due to OOM: 9
Pager Heap Usage: 22312 bytes
Page cache hits: 3
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 2016 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(): 9337
Bytes sent to write(): 21598
Read() system calls: 45
Write() system calls: 16
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Flag