954 lines
39 KiB
Markdown
954 lines
39 KiB
Markdown
## Summary
|
|
<!--Explain briefly what goes wrong and explain why you believe this is a bug and not the intended behavior of SQLite (if it is not a crash).-->**No review yet**
|
|
|
|
## Minimized query
|
|
|
|
```sql
|
|
.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
|
|
|
|
```sql
|
|
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
|
|
|
|
```sql
|
|
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
|
|
|
|
```
|
|
|
|
```
|
|
|