20 KiB
20 KiB
Summary
**No review yet**Minimized query
PRAGMA secure_delete = TRUE;
.stats stmt
SAVEPOINT sp4970;
.scanstats on
DROP TABLE IF EXISTS t0;
CREATE TABLE t0(c0 REAL UNIQUE);
INSERT INTO t0(c0) VALUES (0.0);
SELECT 3175546974276630385 < c0 FROM t0;
SELECT 1 FROM t0 WHERE NOT NOT /**/ (3175546974276630385 < c0) ;
ALTER TABLE t0 ADD COLUMN extra_80 DOUBLE COLLATE NOCASE;
ANALYZE t0;
REINDEX t0;
SELECT STRING_AGG(c0, '|') FROM t0;
RELEASE sp4970;
ALTER TABLE t0 ADD COLUMN extra_3988 TEXT NOT NULL DEFAULT 0;
ALTER TABLE t0 ADD COLUMN extra_7474 DOUB DEFAULT 0;
SELECT LEAD(c0, 0, 'default') OVER (ORDER BY c0 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM t0;
ALTER TABLE t0 RENAME COLUMN c0 TO c0_r7017;
Actual output
1
Number of output columns: 0
Memory Used: 62592 (max 62632) bytes
Number of Outstanding Allocations: 122 (max 123)
Number of Pcache Overflow Bytes: 4104 (max 4104) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4104 bytes
Lookaside Slots Used: 37 (max 38)
Successful lookaside attempts: 45
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: 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(): 6984
Bytes sent to write(): 2
Read() system calls: 13
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: 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 75)
Successful lookaside attempts: 100
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(): 7078
Bytes sent to write(): 1375
Read() system calls: 15
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: 86624 (max 92512) bytes
Number of Outstanding Allocations: 172 (max 181)
Number of Pcache Overflow Bytes: 21288 (max 21288) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 33 (max 91)
Successful lookaside attempts: 177
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: 1168 bytes
Statement Heap/Lookaside Usage: 4040 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 41
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4040
Bytes received by read(): 7431
Bytes sent to write(): 2705
Read() system calls: 18
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: 82608 (max 92512) bytes
Number of Outstanding Allocations: 156 (max 181)
Number of Pcache Overflow Bytes: 21288 (max 21288) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 47 (max 91)
Successful lookaside attempts: 205
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: 1192 bytes
Statement Heap/Lookaside Usage: 3808 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: 3808
Bytes received by read(): 7528
Bytes sent to write(): 4040
Read() system calls: 20
Write() system calls: 5
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
0
Number of output columns: 1
Column 0 name: 3175546974276630385 < c0
Column 0 declared type: (null)
Memory Used: 82608 (max 92512) bytes
Number of Outstanding Allocations: 156 (max 181)
Number of Pcache Overflow Bytes: 21288 (max 21288) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 42 (max 91)
Successful lookaside attempts: 230
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 17936 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1192 bytes
Statement Heap/Lookaside Usage: 3296 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 14
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3296
Bytes received by read(): 7625
Bytes sent to write(): 5375
Read() system calls: 22
Write() system calls: 6
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Number of output columns: 1
Column 0 name: 1
Column 0 declared type: (null)
Memory Used: 82608 (max 92512) bytes
Number of Outstanding Allocations: 156 (max 181)
Number of Pcache Overflow Bytes: 21288 (max 21288) bytes
Largest Allocation: 48000 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 42 (max 91)
Successful lookaside attempts: 257
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 17936 bytes
Page cache hits: 1
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1192 bytes
Statement Heap/Lookaside Usage: 3296 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 11
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3296
Bytes received by read(): 7722
Bytes sent to write(): 6818
Read() system calls: 24
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: 87128 (max 191616) bytes
Number of Outstanding Allocations: 181 (max 220)
Number of Pcache Overflow Bytes: 21288 (max 29496) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 33 (max 91)
Successful lookaside attempts: 328
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 17936 bytes
Page cache hits: 3
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1184 bytes
Statement Heap/Lookaside Usage: 4528 bytes
Fullscan Steps: 1
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 51
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4528
Bytes received by read(): 7819
Bytes sent to write(): 8236
Read() system calls: 26
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: 92080 (max 191616) bytes
Number of Outstanding Allocations: 188 (max 220)
Number of Pcache Overflow Bytes: 25648 (max 29496) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 34 (max 92)
Successful lookaside attempts: 445
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: 1496 bytes
Statement Heap/Lookaside Usage: 5944 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 50
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 5944
Bytes received by read(): 7916
Bytes sent to write(): 9572
Read() system calls: 28
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: 87280 (max 191616) bytes
Number of Outstanding Allocations: 164 (max 220)
Number of Pcache Overflow Bytes: 25648 (max 29496) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 42 (max 92)
Successful lookaside attempts: 461
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: 1496 bytes
Statement Heap/Lookaside Usage: 3168 bytes
Fullscan Steps: 0
Sort Operations: 1
Autoindex Inserts: 0
Virtual Machine Steps: 24
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 3168
Bytes received by read(): 8013
Bytes sent to write(): 10908
Read() system calls: 30
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: 85672 (max 191616) bytes
Number of Outstanding Allocations: 161 (max 220)
Number of Pcache Overflow Bytes: 25648 (max 29496) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 38 (max 92)
Successful lookaside attempts: 480
Lookaside failures due to size: 0
Lookaside failures due to OOM: 0
Pager Heap Usage: 22280 bytes
Page cache hits: 0
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1496 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(): 8112
Bytes sent to write(): 12364
Read() system calls: 32
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: 90456 (max 194776) bytes
Number of Outstanding Allocations: 189 (max 228)
Number of Pcache Overflow Bytes: 25648 (max 33856) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 34 (max 92)
Successful lookaside attempts: 583
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: 1720 bytes
Statement Heap/Lookaside Usage: 4560 bytes
Fullscan Steps: 2
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 56
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4560
Bytes received by read(): 8211
Bytes sent to write(): 13701
Read() system calls: 34
Write() system calls: 13
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Number of output columns: 0
Memory Used: 90536 (max 194856) bytes
Number of Outstanding Allocations: 191 (max 234)
Number of Pcache Overflow Bytes: 25648 (max 33856) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 34 (max 92)
Successful lookaside attempts: 686
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: 1832 bytes
Statement Heap/Lookaside Usage: 4528 bytes
Fullscan Steps: 2
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 56
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 4528
Bytes received by read(): 8310
Bytes sent to write(): 15039
Read() system calls: 36
Write() system calls: 14
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
0.0
Number of output columns: 1
Column 0 name: LEAD(c0, 0, 'default') OVER (ORDER BY c0 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
Column 0 declared type: (null)
Memory Used: 90096 (max 194856) bytes
Number of Outstanding Allocations: 168 (max 234)
Number of Pcache Overflow Bytes: 25648 (max 33856) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 48 (max 92)
Successful lookaside attempts: 755
Lookaside failures due to size: 2
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: 1856 bytes
Statement Heap/Lookaside Usage: 6800 bytes
Fullscan Steps: 0
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 61
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 6800
Bytes received by read(): 8409
Bytes sent to write(): 16377
Read() system calls: 38
Write() system calls: 15
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Number of output columns: 0
Memory Used: 204224 (max 678776) bytes
Number of Outstanding Allocations: 244 (max 348)
Number of Pcache Overflow Bytes: 33856 (max 66688) bytes
Largest Allocation: 87200 bytes
Largest Pcache Allocation: 4360 bytes
Lookaside Slots Used: 101 (max 123)
Successful lookaside attempts: 1093
Lookaside failures due to size: 5
Lookaside failures due to OOM: 299
Pager Heap Usage: 31496 bytes
Page cache hits: 14
Page cache misses: 0
Page cache writes: 0
Page cache spills: 0
Schema Heap Usage: 1856 bytes
Statement Heap/Lookaside Usage: 51664 bytes
Fullscan Steps: 8
Sort Operations: 0
Autoindex Inserts: 0
Virtual Machine Steps: 192
Reprepare operations: 0
Number of times run: 1
Memory used by prepared stmt: 51664
Bytes received by read(): 8508
Bytes sent to write(): 17891
Read() system calls: 41
Write() system calls: 16
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Expectation
Flag