Files
ast-project/part1/results/2/bug_9f3c81b6-b666-485b-9e3d-353eea4d82a6_logic.md
2026-06-24 13:47:14 +02:00

29 KiB

Summary

**No review yet**

Minimized query

PRAGMA empty_result_callbacks = TRUE;
CREATE TABLE t1(a INT, b INT);
CREATE TABLE t2(c INT, d INT);
CREATE TABLE t3(e TEXT, f TEXT);
INSERT INTO t1 VALUES(1, 1);
INSERT INTO t2 VALUES(1, 2);
INSERT INTO t3 VALUES('abc', 'def');
SELECT * FROM t1, t2 LEFT JOIN t3 ON (t2.d=1) WHERE t2.c = +t1.a;
SELECT * FROM t1 LEFT JOIN t2 ON (t2.c=+t1.a) LEFT JOIN t3 ON (t2.d IS NULL);

SELECT * FROM t2;
SELECT MIN(b) OVER (PARTITION BY b ORDER BY b RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE NO OTHERS) FROM t1;

Actual output

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:               4
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        2528
Bytes received by read():            6827
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
Memory Used:                         78864 (max 80416) 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:       112
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:      2416 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:        2416
Bytes received by read():            7177
Bytes sent to write():               1285
Read() system calls:                 16
Write() system calls:                1
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Memory Used:                         83464 (max 89144) 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:       187
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:                   1256 bytes
Statement Heap/Lookaside Usage:      2400 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:        2400
Bytes received by read():            7274
Bytes sent to write():               2581
Read() system calls:                 18
Write() system calls:                2
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Memory Used:                         88080 (max 93760) bytes
Number of Outstanding Allocations:   176 (max 191)
Number of Pcache Overflow Bytes:     25648 (max 25648) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                32 (max 88)
Successful lookaside attempts:       262
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:                   1504 bytes
Statement Heap/Lookaside Usage:      2400 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:        2400
Bytes received by read():            7371
Bytes sent to write():               3877
Read() system calls:                 20
Write() system calls:                3
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Memory Used:                         85704 (max 93760) bytes
Number of Outstanding Allocations:   165 (max 191)
Number of Pcache Overflow Bytes:     25648 (max 25648) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                38 (max 88)
Successful lookaside attempts:       279
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:                   1528 bytes
Statement Heap/Lookaside Usage:      2912 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:        2912
Bytes received by read():            7468
Bytes sent to write():               5173
Read() system calls:                 22
Write() system calls:                4
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Memory Used:                         85728 (max 93760) bytes
Number of Outstanding Allocations:   166 (max 191)
Number of Pcache Overflow Bytes:     25648 (max 25648) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                38 (max 88)
Successful lookaside attempts:       296
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:                   1552 bytes
Statement Heap/Lookaside Usage:      2912 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:        2912
Bytes received by read():            7565
Bytes sent to write():               6469
Read() system calls:                 24
Write() system calls:                5
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Memory Used:                         85752 (max 93760) bytes
Number of Outstanding Allocations:   167 (max 191)
Number of Pcache Overflow Bytes:     25648 (max 25648) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                40 (max 88)
Successful lookaside attempts:       315
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:                   1576 bytes
Statement Heap/Lookaside Usage:      3168 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:        3168
Bytes received by read():            7662
Bytes sent to write():               7765
Read() system calls:                 26
Write() system calls:                6
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
1|1|1|2||
Memory Used:                         88128 (max 196928) bytes
Number of Outstanding Allocations:   168 (max 191)
Number of Pcache Overflow Bytes:     25648 (max 33856) bytes
Largest Allocation:                  87200 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                68 (max 100)
Successful lookaside attempts:       430
Lookaside failures due to size:      3
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:                   1576 bytes
Statement Heap/Lookaside Usage:      10072 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Bloom filter bypass taken:           0/1
Virtual Machine Steps:               46
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        10072
Bytes received by read():            7759
Bytes sent to write():               9061
Read() system calls:                 28
Write() system calls:                7
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
1|1|1|2||
Memory Used:                         88128 (max 196928) bytes
Number of Outstanding Allocations:   168 (max 191)
Number of Pcache Overflow Bytes:     25648 (max 33856) bytes
Largest Allocation:                  87200 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                70 (max 101)
Successful lookaside attempts:       547
Lookaside failures due to size:      6
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:                   1576 bytes
Statement Heap/Lookaside Usage:      10328 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Bloom filter bypass taken:           0/1
Virtual Machine Steps:               48
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        10328
Bytes received by read():            7856
Bytes sent to write():               10412
Read() system calls:                 30
Write() system calls:                8
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
1|2
Memory Used:                         85752 (max 196928) bytes
Number of Outstanding Allocations:   167 (max 191)
Number of Pcache Overflow Bytes:     25648 (max 33856) bytes
Largest Allocation:                  87200 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                44 (max 101)
Successful lookaside attempts:       576
Lookaside failures due to size:      6
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:                   1576 bytes
Statement Heap/Lookaside Usage:      4752 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:        4752
Bytes received by read():            7954
Bytes sent to write():               11764
Read() system calls:                 32
Write() system calls:                9
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
1
Memory Used:                         92744 (max 196928) bytes
Number of Outstanding Allocations:   169 (max 191)
Number of Pcache Overflow Bytes:     25648 (max 33856) bytes
Largest Allocation:                  87200 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                58 (max 103)
Successful lookaside attempts:       661
Lookaside failures due to size:      8
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:                   1576 bytes
Statement Heap/Lookaside Usage:      10496 bytes
Fullscan Steps:                      0
Sort Operations:                     1
Autoindex Inserts:                   0
Virtual Machine Steps:               93
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        10496
Bytes received by read():            8052
Bytes sent to write():               13067
Read() system calls:                 35
Write() system calls:                10
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0

Expectation

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:               5
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        2528
Bytes received by read():            7603
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
Memory Used:                         79392 (max 80928) 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:       121
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:      2288 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:        2288
Bytes received by read():            7697
Bytes sent to write():               1324
Read() system calls:                 16
Write() system calls:                1
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Memory Used:                         83976 (max 89608) 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:       189
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:                   1072 bytes
Statement Heap/Lookaside Usage:      2288 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:        2288
Bytes received by read():            7794
Bytes sent to write():               2658
Read() system calls:                 18
Write() system calls:                2
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Memory Used:                         88568 (max 94200) bytes
Number of Outstanding Allocations:   186 (max 201)
Number of Pcache Overflow Bytes:     25672 (max 25672) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                48 (max 97)
Successful lookaside attempts:       257
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:                   1288 bytes
Statement Heap/Lookaside Usage:      2296 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:        2296
Bytes received by read():            7891
Bytes sent to write():               3993
Read() system calls:                 20
Write() system calls:                3
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Memory Used:                         86280 (max 94200) bytes
Number of Outstanding Allocations:   175 (max 201)
Number of Pcache Overflow Bytes:     25672 (max 25672) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                54 (max 97)
Successful lookaside attempts:       274
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:                   1296 bytes
Statement Heap/Lookaside Usage:      2912 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:        2912
Bytes received by read():            7988
Bytes sent to write():               5328
Read() system calls:                 22
Write() system calls:                4
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Memory Used:                         86288 (max 94200) bytes
Number of Outstanding Allocations:   176 (max 201)
Number of Pcache Overflow Bytes:     25672 (max 25672) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                54 (max 97)
Successful lookaside attempts:       291
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:                   1304 bytes
Statement Heap/Lookaside Usage:      2912 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:        2912
Bytes received by read():            8085
Bytes sent to write():               6663
Read() system calls:                 24
Write() system calls:                5
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
Memory Used:                         86296 (max 94200) bytes
Number of Outstanding Allocations:   177 (max 201)
Number of Pcache Overflow Bytes:     25672 (max 25672) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                56 (max 97)
Successful lookaside attempts:       310
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:                   1312 bytes
Statement Heap/Lookaside Usage:      3168 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:        3168
Bytes received by read():            8182
Bytes sent to write():               7998
Read() system calls:                 26
Write() system calls:                6
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
1|1|1|2||
Memory Used:                         88664 (max 197600) bytes
Number of Outstanding Allocations:   178 (max 201)
Number of Pcache Overflow Bytes:     25672 (max 33872) bytes
Largest Allocation:                  87360 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                75 (max 108)
Successful lookaside attempts:       415
Lookaside failures due to size:      4
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:                   1312 bytes
Statement Heap/Lookaside Usage:      11056 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Bloom filter bypass taken:           0/1
Virtual Machine Steps:               47
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        11056
Bytes received by read():            8279
Bytes sent to write():               9333
Read() system calls:                 28
Write() system calls:                7
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
1|1|1|2||
Memory Used:                         88664 (max 197600) bytes
Number of Outstanding Allocations:   178 (max 201)
Number of Pcache Overflow Bytes:     25672 (max 33872) bytes
Largest Allocation:                  87360 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                77 (max 108)
Successful lookaside attempts:       522
Lookaside failures due to size:      8
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:                   1312 bytes
Statement Heap/Lookaside Usage:      12384 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Bloom filter bypass taken:           0/1
Virtual Machine Steps:               49
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        12384
Bytes received by read():            8376
Bytes sent to write():               10723
Read() system calls:                 30
Write() system calls:                8
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
1|2
Memory Used:                         86296 (max 197600) bytes
Number of Outstanding Allocations:   177 (max 201)
Number of Pcache Overflow Bytes:     25672 (max 33872) bytes
Largest Allocation:                  87360 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                58 (max 108)
Successful lookaside attempts:       549
Lookaside failures due to size:      8
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:                   1312 bytes
Statement Heap/Lookaside Usage:      4496 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:        4496
Bytes received by read():            8474
Bytes sent to write():               12114
Read() system calls:                 32
Write() system calls:                9
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0
1
Memory Used:                         93272 (max 197600) bytes
Number of Outstanding Allocations:   179 (max 201)
Number of Pcache Overflow Bytes:     25672 (max 33872) bytes
Largest Allocation:                  87360 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                71 (max 111)
Successful lookaside attempts:       632
Lookaside failures due to size:      10
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:                   1312 bytes
Statement Heap/Lookaside Usage:      13312 bytes
Fullscan Steps:                      0
Sort Operations:                     1
Autoindex Inserts:                   0
Virtual Machine Steps:               93
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        13312
Bytes received by read():            8572
Bytes sent to write():               13456
Read() system calls:                 35
Write() system calls:                10
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0

Flag

-stats