14 KiB
14 KiB
Summary
**No review yet**Minimized query
.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;
Actual output
Number of output columns: 0
Memory Used: 62608 (max 62608) 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: 37 (max 37)
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: 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(): 6688
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
Number of output columns: 0
Memory Used: 67720 (max 67720) 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: 92
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(): 6782
Bytes sent to write(): 1373
Read() system calls: 15
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: 86640 (max 92528) 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: 169
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(): 7135
Bytes sent to write(): 2702
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: 82624 (max 92528) 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: 197
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(): 7232
Bytes sent to write(): 4037
Read() system calls: 20
Write() system calls: 4
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: 82624 (max 92528) 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: 222
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(): 7329
Bytes sent to write(): 5372
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: 1
Column 0 name: 1
Column 0 declared type: (null)
Memory Used: 82624 (max 92528) 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: 249
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(): 7426
Bytes sent to write(): 6815
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: 87144 (max 191632) 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: 320
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(): 7523
Bytes sent to write(): 8233
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: 92096 (max 191632) 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: 437
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(): 7620
Bytes sent to write(): 9569
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: 87296 (max 191632) 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: 453
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(): 7717
Bytes sent to write(): 10905
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: 85688 (max 191632) 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: 472
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(): 7815
Bytes sent to write(): 12360
Read() system calls: 33
Write() system calls: 11
Bytes read from storage: 0
Bytes written to storage: 0
Cancelled write bytes: 0
Expectation
Flag