19 KiB
19 KiB
Summary
**No review yet**Minimized query
PRAGMA temp_store = 'MEMORY';
PRAGMA read_uncommitted;
PRAGMA user_version = -1.0;
.stats stmt
CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
CREATE VIRTUAL TABLE t2 USING rtree(id,x0,x1);
INSERT INTO t1 VALUES(1,'apple'),(2,'fig'),(3,'pear');
INSERT INTO t2 VALUES(1,1.0,2.0),(2,2.0,3.0),(3,1.5,3.5);
CREATE TRIGGER r1 AFTER UPDATE ON t1 BEGIN
DELETE FROM t2 WHERE id = OLD.a;
END;
ALTER TABLE t1 RENAME TO t3;
UPDATE t3 SET b='peach' WHERE a=2;
Actual output
0
Number of output columns: 0
Memory Used: 78896 (max 84576) bytes
Number of Outstanding Allocations: 162 (max 176)
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: 125
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 13592 bytes
Page cache hits: 6
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1008 bytes
Statement Heap/Lookaside Usage: 2448 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: 2448
Bytes received by read(): 7014
Bytes sent to write(): 2
Read() system calls: 14
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: 107344 (max 114664) bytes
Number of Outstanding Allocations: 264 (max 279)
Number of Pcache Overflow Bytes: 30008 (max 30008) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 34 (max 92)
Successful lookaside attempts: 463
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 26624 bytes
Page cache hits: 14
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2304 bytes
Statement Heap/Lookaside Usage: 15448 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 31
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2736
Bytes received by read(): 7108
Bytes sent to write(): 1334
Read() system calls: 16
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: 104632 (max 114664) bytes
Number of Outstanding Allocations: 253 (max 279)
Number of Pcache Overflow Bytes: 30008 (max 30008) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 46 (max 92)
Successful lookaside attempts: 496
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 26624 bytes
Page cache hits: 2
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2328 bytes
Statement Heap/Lookaside Usage: 17464 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 47
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4752
Bytes received by read(): 7205
Bytes sent to write(): 2673
Read() system calls: 18
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: 104632 (max 115312) bytes
Number of Outstanding Allocations: 253 (max 279)
Number of Pcache Overflow Bytes: 30008 (max 30008) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 45 (max 92)
Successful lookaside attempts: 550
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 26624 bytes
Page cache hits: 13
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2328 bytes
Statement Heap/Lookaside Usage: 17336 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 35
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4624
Bytes received by read(): 7302
Bytes sent to write(): 4011
Read() system calls: 20
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: 106808 (max 115312) bytes
Number of Outstanding Allocations: 271 (max 281)
Number of Pcache Overflow Bytes: 30008 (max 30008) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 34 (max 92)
Successful lookaside attempts: 624
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 26624 bytes
Page cache hits: 3
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2792 bytes
Statement Heap/Lookaside Usage: 14416 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: 1704
Bytes received by read(): 7399
Bytes sent to write(): 5350
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: 137168 (max 196992) bytes
Number of Outstanding Allocations: 306 (max 374)
Number of Pcache Overflow Bytes: 42576 (max 80280) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 102 (max 123)
Successful lookaside attempts: 950
Lookaside failures due to size: 3
Lookaside failures due to OOM: 184
Pager Heap Usage: 35840 bytes
Page cache hits: 11
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2752 bytes
Statement Heap/Lookaside Usage: 60328 bytes
Fullscan Steps: 15
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 323
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 47616
Bytes received by read(): 7496
Bytes sent to write(): 6688
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: 120920 (max 196992) bytes
Number of Outstanding Allocations: 269 (max 374)
Number of Pcache Overflow Bytes: 42576 (max 80280) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 51 (max 123)
Successful lookaside attempts: 1009
Lookaside failures due to size: 3
Lookaside failures due to OOM: 184
Pager Heap Usage: 35840 bytes
Page cache hits: 7
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2776 bytes
Statement Heap/Lookaside Usage: 19304 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 33
Reprepare operations: 0
Number of times run: 2
Memory used by prepared stmt: 6592
Bytes received by read(): 7593
Bytes sent to write(): 8034
Read() system calls: 26
Write() system calls: 7
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Expectation
0
Number of output columns: 0
Memory Used: 79424 (max 85056) bytes
Number of Outstanding Allocations: 172 (max 186)
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: 134
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 13608 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: 856 bytes
Statement Heap/Lookaside Usage: 2320 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: 2320
Bytes received by read(): 7534
Bytes sent to write(): 2
Read() system calls: 14
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: 107400 (max 114552) bytes
Number of Outstanding Allocations: 273 (max 288)
Number of Pcache Overflow Bytes: 30040 (max 30040) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 50 (max 101)
Successful lookaside attempts: 444
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 26664 bytes
Page cache hits: 14
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 2136 bytes
Statement Heap/Lookaside Usage: 14880 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 31
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2600
Bytes received by read(): 7628
Bytes sent to write(): 1372
Read() system calls: 16
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: 104808 (max 114552) bytes
Number of Outstanding Allocations: 262 (max 288)
Number of Pcache Overflow Bytes: 30040 (max 30040) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 62 (max 101)
Successful lookaside attempts: 480
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 26664 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: 2144 bytes
Statement Heap/Lookaside Usage: 17032 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 47
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4752
Bytes received by read(): 7725
Bytes sent to write(): 2751
Read() system calls: 18
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: 104808 (max 115400) bytes
Number of Outstanding Allocations: 262 (max 288)
Number of Pcache Overflow Bytes: 30040 (max 30040) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 61 (max 101)
Successful lookaside attempts: 537
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 26664 bytes
Page cache hits: 13
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 2144 bytes
Statement Heap/Lookaside Usage: 16904 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 35
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4624
Bytes received by read(): 7822
Bytes sent to write(): 4129
Read() system calls: 20
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: 106848 (max 115400) bytes
Number of Outstanding Allocations: 280 (max 290)
Number of Pcache Overflow Bytes: 30040 (max 30040) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 50 (max 101)
Successful lookaside attempts: 604
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 26664 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: 2576 bytes
Statement Heap/Lookaside Usage: 13888 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: 1608
Bytes received by read(): 7919
Bytes sent to write(): 5508
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: 136600 (max 195320) bytes
Number of Outstanding Allocations: 290 (max 367)
Number of Pcache Overflow Bytes: 42608 (max 80312) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 98 (max 123)
Successful lookaside attempts: 923
Lookaside failures due to size: 3
Lookaside failures due to OOM: 142
Pager Heap Usage: 35896 bytes
Page cache hits: 11
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 2560 bytes
Statement Heap/Lookaside Usage: 49104 bytes
Fullscan Steps: 15
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 323
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 36824
Bytes received by read(): 8016
Bytes sent to write(): 6886
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: 121064 (max 195320) bytes
Number of Outstanding Allocations: 277 (max 367)
Number of Pcache Overflow Bytes: 42608 (max 80312) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 67 (max 123)
Successful lookaside attempts: 982
Lookaside failures due to size: 3
Lookaside failures due to OOM: 142
Pager Heap Usage: 35896 bytes
Page cache hits: 7
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Temporary data spilled to disk: 0
Schema Heap Usage: 2568 bytes
Statement Heap/Lookaside Usage: 18872 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 33
Reprepare operations: 0
Number of times run: 2
Memory used by prepared stmt: 6592
Bytes received by read(): 8113
Bytes sent to write(): 8270
Read() system calls: 26
Write() system calls: 7
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Flag