1119 lines
46 KiB
Markdown
1119 lines
46 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
|
|
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
|
|
|
|
```sql
|
|
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
|
|
|
|
```sql
|
|
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
|
|
|
|
```
|
|
|
|
```
|
|
|