25 KiB
25 KiB
Summary
**No review yet**Minimized query
SAVEPOINT sp356;
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;
ROLLBACK TO sp356;
RELEASE sp356;
Actual output
0
Number of output columns: 0
Memory Used: 80520 (max 86200) bytes
Number of Outstanding Allocations: 165 (max 178)
Number of Pcache Overflow Bytes: 16928 (max 16928) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 33 (max 89)
Successful lookaside attempts: 130
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: 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(): 7065
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: 109032 (max 116296) bytes
Number of Outstanding Allocations: 267 (max 281)
Number of Pcache Overflow Bytes: 30008 (max 30008) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 36 (max 93)
Successful lookaside attempts: 468
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: 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(): 7159
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: 106256 (max 116296) bytes
Number of Outstanding Allocations: 256 (max 281)
Number of Pcache Overflow Bytes: 30008 (max 30008) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 48 (max 93)
Successful lookaside attempts: 501
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 26624 bytes
Page cache hits: 1
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(): 7256
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: 106256 (max 116936) bytes
Number of Outstanding Allocations: 256 (max 281)
Number of Pcache Overflow Bytes: 30008 (max 30008) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 52 (max 93)
Successful lookaside attempts: 554
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 26624 bytes
Page cache hits: 12
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2328 bytes
Statement Heap/Lookaside Usage: 19864 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(): 7353
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: 108432 (max 116936) bytes
Number of Outstanding Allocations: 274 (max 283)
Number of Pcache Overflow Bytes: 30008 (max 30008) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 41 (max 96)
Successful lookaside attempts: 628
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: 2792 bytes
Statement Heap/Lookaside Usage: 16944 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(): 7450
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: 154368 (max 212224) bytes
Number of Outstanding Allocations: 382 (max 446)
Number of Pcache Overflow Bytes: 42576 (max 80280) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 99 (max 123)
Successful lookaside attempts: 950
Lookaside failures due to size: 3
Lookaside failures due to OOM: 188
Pager Heap Usage: 35840 bytes
Page cache hits: 10
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2784 bytes
Statement Heap/Lookaside Usage: 69368 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: 43944
Bytes received by read(): 7547
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: 137936 (max 212224) bytes
Number of Outstanding Allocations: 340 (max 446)
Number of Pcache Overflow Bytes: 42576 (max 80280) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 58 (max 123)
Successful lookaside attempts: 1008
Lookaside failures due to size: 3
Lookaside failures due to OOM: 188
Pager Heap Usage: 35840 bytes
Page cache hits: 6
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 2808 bytes
Statement Heap/Lookaside Usage: 34544 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(): 7644
Bytes sent to write(): 8033
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: 135064 (max 212224) bytes
Number of Outstanding Allocations: 273 (max 446)
Number of Pcache Overflow Bytes: 42576 (max 80280) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 44 (max 123)
Successful lookaside attempts: 1012
Lookaside failures due to size: 3
Lookaside failures due to OOM: 188
Pager Heap Usage: 35840 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: 30608 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: 2656
Bytes received by read(): 7741
Bytes sent to write(): 9375
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: 86904 (max 212224) bytes
Number of Outstanding Allocations: 133 (max 446)
Number of Pcache Overflow Bytes: 25136 (max 80280) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 37 (max 123)
Successful lookaside attempts: 1016
Lookaside failures due to size: 3
Lookaside failures due to OOM: 188
Pager Heap Usage: 18464 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: 2
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2656
Bytes received by read(): 7838
Bytes sent to write(): 10713
Read() system calls: 31
Write() system calls: 9
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Expectation
0
Number of output columns: 0
Memory Used: 81016 (max 86648) bytes
Number of Outstanding Allocations: 175 (max 188)
Number of Pcache Overflow Bytes: 16936 (max 16936) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 49 (max 98)
Successful lookaside attempts: 139
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: 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(): 7585
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: 109048 (max 116144) bytes
Number of Outstanding Allocations: 276 (max 290)
Number of Pcache Overflow Bytes: 30040 (max 30040) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 52 (max 102)
Successful lookaside attempts: 449
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: 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(): 7679
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: 106400 (max 116144) bytes
Number of Outstanding Allocations: 265 (max 290)
Number of Pcache Overflow Bytes: 30040 (max 30040) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 64 (max 102)
Successful lookaside attempts: 485
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 26664 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: 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(): 7776
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: 106400 (max 116992) bytes
Number of Outstanding Allocations: 265 (max 290)
Number of Pcache Overflow Bytes: 30040 (max 30040) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 68 (max 102)
Successful lookaside attempts: 541
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 26664 bytes
Page cache hits: 12
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: 19432 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(): 7873
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: 108440 (max 116992) bytes
Number of Outstanding Allocations: 283 (max 292)
Number of Pcache Overflow Bytes: 30040 (max 30040) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 57 (max 105)
Successful lookaside attempts: 608
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: 2576 bytes
Statement Heap/Lookaside Usage: 16416 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(): 7970
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: 153248 (max 210824) bytes
Number of Outstanding Allocations: 364 (max 437)
Number of Pcache Overflow Bytes: 42608 (max 80312) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 95 (max 123)
Successful lookaside attempts: 927
Lookaside failures due to size: 3
Lookaside failures due to OOM: 136
Pager Heap Usage: 35896 bytes
Page cache hits: 10
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: 56608 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: 32048
Bytes received by read(): 8067
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: 137560 (max 210824) bytes
Number of Outstanding Allocations: 346 (max 437)
Number of Pcache Overflow Bytes: 42608 (max 80312) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 74 (max 123)
Successful lookaside attempts: 985
Lookaside failures due to size: 3
Lookaside failures due to OOM: 136
Pager Heap Usage: 35896 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: 2568 bytes
Statement Heap/Lookaside Usage: 33680 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(): 8164
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
Number of output columns: 0
Memory Used: 134992 (max 210824) bytes
Number of Outstanding Allocations: 279 (max 437)
Number of Pcache Overflow Bytes: 42608 (max 80312) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 60 (max 123)
Successful lookaside attempts: 989
Lookaside failures due to size: 3
Lookaside failures due to OOM: 136
Pager Heap Usage: 35896 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: 29744 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: 2656
Bytes received by read(): 8261
Bytes sent to write(): 9650
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: 87712 (max 210824) bytes
Number of Outstanding Allocations: 143 (max 437)
Number of Pcache Overflow Bytes: 25136 (max 80312) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4368 bytes
Lookaside Slots Used: 53 (max 123)
Successful lookaside attempts: 993
Lookaside failures due to size: 3
Lookaside failures due to OOM: 136
Pager Heap Usage: 18488 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: 3
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 2656
Bytes received by read(): 8358
Bytes sent to write(): 11026
Read() system calls: 31
Write() system calls: 9
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Flag