39 KiB
39 KiB
Summary
**No review yet**Minimized query
.stats stmt
CREATE TABLE T1 (
A VARCHAR(15) PRIMARY KEY,
B VARCHAR(30) NOT NULL UNIQUE
);
CREATE TABLE T2 (
A VARCHAR(10) PRIMARY KEY,
X VARCHAR(15) NOT NULL,
C BIGINT,
FOREIGN KEY (X) REFERENCES T1(A)
);
INSERT INTO T1 VALUES ('p', 'x');
INSERT INTO T1 VALUES ('q', 'y');
INSERT INTO T2 VALUES ('a', 'p', 9223372036854775807);
INSERT INTO T2 VALUES ('b', 'q', -9223372036854775808);
SELECT X, SUM(C) AS D, COUNT(*) AS E FROM T2 GROUP BY X;
VACUUM;
DELETE FROM T1 WHERE B IS NULL;
CREATE INDEX IF NOT EXISTS idx_T1_9218 ON T1(A) WHERE A IS NOT NULL;
VACUUM main;
ALTER TABLE T2 ADD COLUMN extra_1516 BOOLEAN NOT NULL DEFAULT 0;
VACUUM main;
SELECT * FROM T1 WHERE B IN (SELECT B FROM T1 LIMIT 0);
Actual output
Number of output columns: 0
Memory Used: 90368 (max 92128) bytes
Number of Outstanding Allocations: 178 (max 188)
Number of Pcache Overflow Bytes: 25648 (max 25648) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 32 (max 92)
Successful lookaside attempts: 111
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 22280 bytes
Page cache hits: 6
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1408 bytes
Statement Heap/Lookaside Usage: 4768 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 52
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4768
Bytes received by read(): 7278
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
Number of output columns: 0
Memory Used: 99184 (max 105144) bytes
Number of Outstanding Allocations: 186 (max 199)
Number of Pcache Overflow Bytes: 34368 (max 34368) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 32 (max 92)
Successful lookaside attempts: 188
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 30968 bytes
Page cache hits: 5
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2016 bytes
Statement Heap/Lookaside Usage: 4232 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 39
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4232
Bytes received by read(): 7372
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
Number of output columns: 0
Memory Used: 94976 (max 108912) bytes
Number of Outstanding Allocations: 170 (max 199)
Number of Pcache Overflow Bytes: 34368 (max 34368) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 56 (max 92)
Successful lookaside attempts: 227
Lookaside failures due to size: 0
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: 2040 bytes
Statement Heap/Lookaside Usage: 6032 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 26
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 6032
Bytes received by read(): 7469
Bytes sent to write(): 2668
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: 0
Memory Used: 94976 (max 108912) bytes
Number of Outstanding Allocations: 170 (max 199)
Number of Pcache Overflow Bytes: 34368 (max 34368) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 56 (max 92)
Successful lookaside attempts: 266
Lookaside failures due to size: 0
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: 2040 bytes
Statement Heap/Lookaside Usage: 6032 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 26
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 6032
Bytes received by read(): 7566
Bytes sent to write(): 4004
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: 95000 (max 108912) bytes
Number of Outstanding Allocations: 171 (max 199)
Number of Pcache Overflow Bytes: 34368 (max 34368) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 50 (max 92)
Successful lookaside attempts: 298
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 30968 bytes
Page cache hits: 3
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2064 bytes
Statement Heap/Lookaside Usage: 5392 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 20
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 5392
Bytes received by read(): 7663
Bytes sent to write(): 5340
Read() system calls: 22
Write() system calls: 4
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Number of output columns: 0
Memory Used: 95000 (max 108912) bytes
Number of Outstanding Allocations: 171 (max 199)
Number of Pcache Overflow Bytes: 34368 (max 34368) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 50 (max 92)
Successful lookaside attempts: 331
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 30968 bytes
Page cache hits: 3
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2064 bytes
Statement Heap/Lookaside Usage: 5392 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 20
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 5392
Bytes received by read(): 7760
Bytes sent to write(): 6676
Read() system calls: 24
Write() system calls: 5
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
p|9223372036854775807|1
q|-9223372036854775808|1
Number of output columns: 3
Column 0 name: X
Column 0 declared type: VARCHAR(15)
Column 1 name: D
Column 1 declared type: (null)
Column 2 name: E
Column 2 declared type: (null)
Memory Used: 97376 (max 108912) bytes
Number of Outstanding Allocations: 172 (max 199)
Number of Pcache Overflow Bytes: 34368 (max 34368) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 60 (max 92)
Successful lookaside attempts: 402
Lookaside failures due to size: 1
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: 2064 bytes
Statement Heap/Lookaside Usage: 9048 bytes
Fullscan Steps: 1
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 77
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 9048
Bytes received by read(): 7857
Bytes sent to write(): 8012
Read() system calls: 26
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: 88768 (max 332160) bytes
Number of Outstanding Allocations: 128 (max 246)
Number of Pcache Overflow Bytes: 30264 (max 42576) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 35 (max 115)
Successful lookaside attempts: 896
Lookaside failures due to size: 1
Lookaside failures due to OOM: 0
Pager Heap Usage: 30968 bytes
Page cache hits: 15
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(): 7954
Bytes sent to write(): 9651
Read() system calls: 28
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: 90824 (max 332160) bytes
Number of Outstanding Allocations: 167 (max 246)
Number of Pcache Overflow Bytes: 30264 (max 42576) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 45 (max 115)
Successful lookaside attempts: 973
Lookaside failures due to size: 1
Lookaside failures due to OOM: 0
Pager Heap Usage: 30968 bytes
Page cache hits: 3
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1992 bytes
Statement Heap/Lookaside Usage: 3552 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: 3552
Bytes received by read(): 8051
Bytes sent to write(): 10985
Read() system calls: 30
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: 103416 (max 332160) bytes
Number of Outstanding Allocations: 191 (max 246)
Number of Pcache Overflow Bytes: 38728 (max 42576) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 32 (max 115)
Successful lookaside attempts: 1054
Lookaside failures due to size: 1
Lookaside failures due to OOM: 0
Pager Heap Usage: 35312 bytes
Page cache hits: 5
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2376 bytes
Statement Heap/Lookaside Usage: 3680 bytes
Fullscan Steps: 0
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 48
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3680
Bytes received by read(): 8149
Bytes sent to write(): 12322
Read() system calls: 32
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: 93128 (max 340152) bytes
Number of Outstanding Allocations: 129 (max 251)
Number of Pcache Overflow Bytes: 34624 (max 46936) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 35 (max 115)
Successful lookaside attempts: 1631
Lookaside failures due to size: 2
Lookaside failures due to OOM: 0
Pager Heap Usage: 35312 bytes
Page cache hits: 17
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(): 8247
Bytes sent to write(): 13662
Read() system calls: 34
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: 104496 (max 340152) bytes
Number of Outstanding Allocations: 202 (max 251)
Number of Pcache Overflow Bytes: 38728 (max 46936) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 32 (max 115)
Successful lookaside attempts: 1703
Lookaside failures due to size: 2
Lookaside failures due to OOM: 0
Pager Heap Usage: 35312 bytes
Page cache hits: 6
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2600 bytes
Statement Heap/Lookaside Usage: 4592 bytes
Fullscan Steps: 5
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 65
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4592
Bytes received by read(): 8346
Bytes sent to write(): 14999
Read() system calls: 36
Write() system calls: 11
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Number of output columns: 0
Memory Used: 93128 (max 340640) bytes
Number of Outstanding Allocations: 129 (max 256)
Number of Pcache Overflow Bytes: 34624 (max 46936) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 35 (max 115)
Successful lookaside attempts: 2281
Lookaside failures due to size: 3
Lookaside failures due to OOM: 0
Pager Heap Usage: 35312 bytes
Page cache hits: 17
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(): 8445
Bytes sent to write(): 16340
Read() system calls: 38
Write() system calls: 12
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Number of output columns: 2
Column 0 name: A
Column 0 declared type: VARCHAR(15)
Column 1 name: B
Column 1 declared type: VARCHAR(30)
Memory Used: 95840 (max 340640) bytes
Number of Outstanding Allocations: 176 (max 256)
Number of Pcache Overflow Bytes: 34624 (max 46936) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 54 (max 115)
Successful lookaside attempts: 2400
Lookaside failures due to size: 3
Lookaside failures due to OOM: 0
Pager Heap Usage: 35312 bytes
Page cache hits: 3
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2640 bytes
Statement Heap/Lookaside Usage: 6720 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: 6720
Bytes received by read(): 8544
Bytes sent to write(): 17677
Read() system calls: 41
Write() system calls: 13
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Expectation
Number of output columns: 0
Memory Used: 90832 (max 92536) bytes
Number of Outstanding Allocations: 188 (max 198)
Number of Pcache Overflow Bytes: 25672 (max 25672) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 48 (max 101)
Successful lookaside attempts: 120
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 22312 bytes
Page cache hits: 6
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 1288 bytes
Statement Heap/Lookaside Usage: 4560 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 52
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4560
Bytes received by read(): 7798
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
Number of output columns: 0
Memory Used: 99680 (max 105496) bytes
Number of Outstanding Allocations: 196 (max 209)
Number of Pcache Overflow Bytes: 34408 (max 34408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 48 (max 101)
Successful lookaside attempts: 190
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 31016 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: 1888 bytes
Statement Heap/Lookaside Usage: 4072 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 39
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4072
Bytes received by read(): 7892
Bytes sent to write(): 1372
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: 95616 (max 109440) bytes
Number of Outstanding Allocations: 180 (max 209)
Number of Pcache Overflow Bytes: 34408 (max 34408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 72 (max 101)
Successful lookaside attempts: 229
Lookaside failures due to size: 0
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: 1896 bytes
Statement Heap/Lookaside Usage: 6032 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 26
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 6032
Bytes received by read(): 7989
Bytes sent to write(): 2748
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: 0
Memory Used: 95616 (max 109440) bytes
Number of Outstanding Allocations: 180 (max 209)
Number of Pcache Overflow Bytes: 34408 (max 34408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 72 (max 101)
Successful lookaside attempts: 268
Lookaside failures due to size: 0
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: 1896 bytes
Statement Heap/Lookaside Usage: 6032 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 26
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 6032
Bytes received by read(): 8086
Bytes sent to write(): 4124
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: 95624 (max 109440) bytes
Number of Outstanding Allocations: 181 (max 209)
Number of Pcache Overflow Bytes: 34408 (max 34408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 66 (max 101)
Successful lookaside attempts: 300
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 31016 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: 1904 bytes
Statement Heap/Lookaside Usage: 5392 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 20
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 5392
Bytes received by read(): 8183
Bytes sent to write(): 5500
Read() system calls: 22
Write() system calls: 4
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Number of output columns: 0
Memory Used: 95624 (max 109440) bytes
Number of Outstanding Allocations: 181 (max 209)
Number of Pcache Overflow Bytes: 34408 (max 34408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 66 (max 101)
Successful lookaside attempts: 333
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 31016 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: 1904 bytes
Statement Heap/Lookaside Usage: 5392 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 20
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 5392
Bytes received by read(): 8280
Bytes sent to write(): 6876
Read() system calls: 24
Write() system calls: 5
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
p|9223372036854775807|1
q|-9223372036854775808|1
Number of output columns: 3
Column 0 name: X
Column 0 declared type: VARCHAR(15)
Column 1 name: D
Column 1 declared type: (null)
Column 2 name: E
Column 2 declared type: (null)
Memory Used: 97992 (max 109440) bytes
Number of Outstanding Allocations: 182 (max 209)
Number of Pcache Overflow Bytes: 34408 (max 34408) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 74 (max 101)
Successful lookaside attempts: 404
Lookaside failures due to size: 1
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: 1904 bytes
Statement Heap/Lookaside Usage: 8784 bytes
Fullscan Steps: 1
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 80
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 8784
Bytes received by read(): 8377
Bytes sent to write(): 8252
Read() system calls: 26
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: 93720 (max 332520) bytes
Number of Outstanding Allocations: 139 (max 256)
Number of Pcache Overflow Bytes: 34408 (max 42608) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 51 (max 120)
Successful lookaside attempts: 862
Lookaside failures due to size: 1
Lookaside failures due to OOM: 0
Pager Heap Usage: 31016 bytes
Page cache hits: 15
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(): 8518
Bytes sent to write(): 9931
Read() system calls: 29
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: 95600 (max 332520) bytes
Number of Outstanding Allocations: 178 (max 256)
Number of Pcache Overflow Bytes: 34408 (max 42608) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 59 (max 120)
Successful lookaside attempts: 932
Lookaside failures due to size: 1
Lookaside failures due to OOM: 0
Pager Heap Usage: 31016 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: 1880 bytes
Statement Heap/Lookaside Usage: 3296 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: 3296
Bytes received by read(): 8615
Bytes sent to write(): 11304
Read() system calls: 31
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: 103904 (max 332520) bytes
Number of Outstanding Allocations: 199 (max 256)
Number of Pcache Overflow Bytes: 38776 (max 42608) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 48 (max 120)
Successful lookaside attempts: 1006
Lookaside failures due to size: 1
Lookaside failures due to OOM: 0
Pager Heap Usage: 35368 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: 2240 bytes
Statement Heap/Lookaside Usage: 3520 bytes
Fullscan Steps: 0
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 48
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3520
Bytes received by read(): 8713
Bytes sent to write(): 12680
Read() system calls: 33
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: 98088 (max 340624) bytes
Number of Outstanding Allocations: 140 (max 261)
Number of Pcache Overflow Bytes: 38776 (max 46976) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 51 (max 120)
Successful lookaside attempts: 1540
Lookaside failures due to size: 2
Lookaside failures due to OOM: 0
Pager Heap Usage: 35368 bytes
Page cache hits: 17
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(): 8811
Bytes sent to write(): 14059
Read() system calls: 35
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: 104680 (max 340624) bytes
Number of Outstanding Allocations: 203 (max 261)
Number of Pcache Overflow Bytes: 38776 (max 46976) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 48 (max 120)
Successful lookaside attempts: 1607
Lookaside failures due to size: 2
Lookaside failures due to OOM: 0
Pager Heap Usage: 35368 bytes
Page cache hits: 6
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 2440 bytes
Statement Heap/Lookaside Usage: 4152 bytes
Fullscan Steps: 5
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 65
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4152
Bytes received by read(): 8910
Bytes sent to write(): 15435
Read() system calls: 37
Write() system calls: 11
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Number of output columns: 0
Memory Used: 98088 (max 341032) bytes
Number of Outstanding Allocations: 140 (max 266)
Number of Pcache Overflow Bytes: 38776 (max 46976) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 51 (max 120)
Successful lookaside attempts: 2142
Lookaside failures due to size: 3
Lookaside failures due to OOM: 0
Pager Heap Usage: 35368 bytes
Page cache hits: 17
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(): 9009
Bytes sent to write(): 16815
Read() system calls: 39
Write() system calls: 12
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Number of output columns: 2
Column 0 name: A
Column 0 declared type: VARCHAR(15)
Column 1 name: B
Column 1 declared type: VARCHAR(30)
Memory Used: 100536 (max 341032) bytes
Number of Outstanding Allocations: 187 (max 266)
Number of Pcache Overflow Bytes: 38776 (max 46976) bytes
Largest Allocation: 87360 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 70 (max 120)
Successful lookaside attempts: 2256
Lookaside failures due to size: 4
Lookaside failures due to OOM: 0
Pager Heap Usage: 35368 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: 2448 bytes
Statement Heap/Lookaside Usage: 7792 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: 7792
Bytes received by read(): 9108
Bytes sent to write(): 18191
Read() system calls: 42
Write() system calls: 13
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Flag