iosnoop-xeon.txt
text/plain
Filename: iosnoop-xeon.txt
Type: text/plain
Part: 3
bytes hash workers:0 work_mem:2MB type | bytes | count | pct ------+--------+--------+------- RA | 131072 | 70120 | 84.81 RA | 32768 | 4720 | 5.71 RA | 8192 | 3406 | 4.12 RA | 90112 | 2208 | 2.67 RM | 4096 | 133 | 100 W | 131072 | 154560 | 95.35 WM | 4096 | 95 | 66.43 WM | 8192 | 17 | 11.89 WM | 61440 | 7 | 4.9 WM | 36864 | 6 | 4.2 WM | 12288 | 4 | 2.8 WM | 16384 | 3 | 2.1 WM | 24576 | 3 | 2.1 WS | 4096 | 161 | 48.94 WS | 8192 | 72 | 21.88 WS | 12288 | 50 | 15.2 WS | 20480 | 12 | 3.65 WS | 131072 | 7 | 2.13 WS | 57344 | 6 | 1.82 WS | 24576 | 6 | 1.82 (20 rows) deltas hash workers:0 work_mem:2MB type | bytes | count | pct ------+-------------+--------+------- RA | 131072 | 66702 | 80.68 RA | 32768 | 4673 | 5.65 RA | 8192 | 3296 | 3.99 RM | 4096 | 8 | 6.02 RM | -1342005248 | 5 | 3.76 RM | -1207791616 | 3 | 2.26 RM | -670937088 | 3 | 2.26 RM | -268296192 | 3 | 2.26 RM | -1744646144 | 3 | 2.26 W | 131072 | 152779 | 94.26 WM | 2147483648 | 11 | 7.69 WM | 61440 | 7 | 4.9 WM | 110592 | 6 | 4.2 WM | 2147430400 | 5 | 3.5 WM | 100519936 | 4 | 2.8 WM | 2147434496 | 4 | 2.8 WM | 2147373056 | 4 | 2.8 WM | 114688 | 3 | 2.1 WM | 2147368960 | 3 | 2.1 WM | 33632256 | 3 | 2.1 WM | -2147368960 | 3 | 2.1 WS | 8192 | 72 | 21.88 WS | 4096 | 71 | 21.58 WS | 12288 | 49 | 14.89 WS | 20480 | 12 | 3.65 WS | 131072 | 7 | 2.13 WS | 57344 | 6 | 1.82 WS | 24576 | 6 | 1.82 (28 rows) bytes hash workers:0 work_mem:4MB type | bytes | count | pct ------+--------+--------+------- RA | 131072 | 79970 | 83.73 RA | 32768 | 5440 | 5.7 RA | 8192 | 4012 | 4.2 RA | 90112 | 2557 | 2.68 RM | 4096 | 133 | 100 W | 131072 | 144109 | 94.85 WM | 4096 | 84 | 63.64 WM | 8192 | 14 | 10.61 WM | 61440 | 6 | 4.55 WM | 12288 | 6 | 4.55 WM | 36864 | 5 | 3.79 WM | 20480 | 4 | 3.03 WM | 28672 | 4 | 3.03 WM | 24576 | 3 | 2.27 WS | 4096 | 146 | 49.32 WS | 8192 | 59 | 19.93 WS | 12288 | 49 | 16.55 WS | 24576 | 8 | 2.7 WS | 20480 | 5 | 1.69 (19 rows) deltas hash workers:0 work_mem:4MB type | bytes | count | pct ------+-------------+--------+------- RA | 131072 | 76262 | 79.84 RA | 32768 | 5363 | 5.61 RA | 8192 | 3860 | 4.04 RM | 4096 | 8 | 6.02 RM | -2013073408 | 3 | 2.26 RM | -1476218880 | 3 | 2.26 W | 131072 | 142585 | 93.85 WM | 2147483648 | 14 | 10.61 WM | 61440 | 9 | 6.82 WM | 8192 | 8 | 6.06 WM | 2147475456 | 5 | 3.79 WM | 100552704 | 4 | 3.03 WM | 2147434496 | 3 | 2.27 WM | 33632256 | 3 | 2.27 WS | 4096 | 59 | 19.93 WS | 8192 | 59 | 19.93 WS | 12288 | 49 | 16.55 WS | 24576 | 8 | 2.7 WS | 20480 | 5 | 1.69 (19 rows) bytes hash workers:0 work_mem:8MB type | bytes | count | pct ------+--------+--------+------- RA | 131072 | 72837 | 83.94 RA | 32768 | 5101 | 5.88 RA | 8192 | 3749 | 4.32 RA | 90112 | 2457 | 2.83 RM | 4096 | 132 | 100 W | 131072 | 146039 | 91.05 W | 8192 | 3332 | 2.08 WM | 4096 | 90 | 66.18 WM | 8192 | 15 | 11.03 WM | 61440 | 7 | 5.15 WM | 12288 | 5 | 3.68 WM | 28672 | 3 | 2.21 WM | 32768 | 3 | 2.21 WM | 24576 | 3 | 2.21 WM | 20480 | 3 | 2.21 WM | 36864 | 3 | 2.21 WS | 4096 | 152 | 49.67 WS | 8192 | 66 | 21.57 WS | 12288 | 46 | 15.03 WS | 24576 | 9 | 2.94 WS | 20480 | 8 | 2.61 WS | 61440 | 5 | 1.63 WS | 53248 | 5 | 1.63 (23 rows) deltas hash workers:0 work_mem:8MB type | bytes | count | pct ------+-------------+--------+------- RA | 131072 | 69339 | 79.91 RA | 32768 | 5057 | 5.83 RA | 8192 | 3613 | 4.16 RM | 4096 | 7 | 5.3 RM | -939364352 | 3 | 2.27 RM | -1878859776 | 3 | 2.27 RM | -1744646144 | 3 | 2.27 W | 131072 | 145007 | 90.4 WM | 2147483648 | 9 | 6.62 WM | 2147450880 | 9 | 6.62 WM | 61440 | 8 | 5.88 WM | 32768 | 8 | 5.88 WM | 33632256 | 3 | 2.21 WM | 28672 | 3 | 2.21 WM | 2147454976 | 3 | 2.21 WM | 65536 | 3 | 2.21 WS | 4096 | 68 | 22.22 WS | 8192 | 66 | 21.57 WS | 12288 | 45 | 14.71 WS | 24576 | 9 | 2.94 WS | 20480 | 8 | 2.61 WS | 61440 | 5 | 1.63 WS | 53248 | 5 | 1.63 (23 rows) bytes hash workers:0 work_mem:64MB type | bytes | count | pct ------+--------+--------+------- RA | 131072 | 74595 | 84.76 RA | 32768 | 5091 | 5.79 RA | 8192 | 3702 | 4.21 RA | 90112 | 2447 | 2.78 RM | 4096 | 131 | 100 W | 131072 | 129936 | 94.47 WM | 4096 | 87 | 64.93 WM | 8192 | 16 | 11.94 WM | 61440 | 6 | 4.48 WM | 16384 | 4 | 2.99 WM | 36864 | 4 | 2.99 WM | 12288 | 4 | 2.99 WM | 20480 | 3 | 2.24 WM | 24576 | 3 | 2.24 WS | 4096 | 134 | 50 WS | 8192 | 93 | 34.7 WS | 24576 | 9 | 3.36 WS | 20480 | 7 | 2.61 (18 rows) deltas hash workers:0 work_mem:64MB type | bytes | count | pct ------+-------------+--------+------- RA | 131072 | 70806 | 80.46 RA | 32768 | 5060 | 5.75 RA | 8192 | 3606 | 4.1 RM | 4096 | 8 | 6.11 RM | -1610432512 | 5 | 3.82 RM | -1342005248 | 4 | 3.05 RM | -1744646144 | 4 | 3.05 RM | 131072 | 4 | 3.05 RM | -1878859776 | 3 | 2.29 RM | -1476218880 | 3 | 2.29 W | 131072 | 129781 | 94.35 WM | 61440 | 9 | 6.72 WM | 2147483648 | 7 | 5.22 WM | 2147426304 | 6 | 4.48 WM | 2147430400 | 6 | 4.48 WM | 53248 | 6 | 4.48 WM | 57344 | 4 | 2.99 WM | 2147422208 | 3 | 2.24 WM | 33644544 | 3 | 2.24 WM | 33697792 | 3 | 2.24 WS | 8192 | 93 | 34.7 WS | 4096 | 64 | 23.88 WS | 24576 | 9 | 3.36 WS | 20480 | 7 | 2.61 (24 rows) bytes hash workers:0 work_mem:256MB type | bytes | count | pct ------+--------+--------+------- RA | 131072 | 62549 | 84.73 RA | 32768 | 4170 | 5.65 RA | 8192 | 3015 | 4.08 RA | 90112 | 1967 | 2.66 RM | 4096 | 124 | 100 W | 131072 | 119558 | 94.8 WM | 4096 | 97 | 67.83 WM | 8192 | 17 | 11.89 WM | 61440 | 7 | 4.9 WM | 12288 | 5 | 3.5 WM | 36864 | 4 | 2.8 WM | 32768 | 4 | 2.8 WM | 24576 | 3 | 2.1 WM | 20480 | 3 | 2.1 WS | 4096 | 145 | 49.32 WS | 8192 | 102 | 34.69 WS | 20480 | 11 | 3.74 WS | 24576 | 9 | 3.06 WS | 53248 | 5 | 1.7 (19 rows) deltas hash workers:0 work_mem:256MB type | bytes | count | pct ------+-------------+--------+------- RA | 131072 | 59358 | 80.4 RA | 32768 | 4139 | 5.61 RA | 8192 | 2919 | 3.95 RM | 4096 | 7 | 5.65 RM | -1342074880 | 3 | 2.42 W | 131072 | 119360 | 94.64 WM | 2147483648 | 9 | 6.29 WM | 61440 | 7 | 4.9 WM | 81920 | 7 | 4.9 WM | 2147401728 | 7 | 4.9 WM | 86016 | 5 | 3.5 WM | 2147467264 | 4 | 2.8 WM | 33644544 | 4 | 2.8 WM | 2147397632 | 3 | 2.1 WM | -61440 | 3 | 2.1 WM | 2147430400 | 3 | 2.1 WM | 77824 | 3 | 2.1 WS | 8192 | 101 | 34.35 WS | 4096 | 72 | 24.49 WS | 20480 | 11 | 3.74 WS | 24576 | 9 | 3.06 WS | 53248 | 5 | 1.7 (22 rows) bytes hash workers:3 work_mem:2MB type | bytes | count | pct ------+--------+--------+------- RA | 131072 | 76433 | 83.76 RA | 32768 | 5254 | 5.76 RA | 8192 | 3992 | 4.37 RA | 90112 | 2626 | 2.88 RM | 4096 | 168 | 100 W | 131072 | 192035 | 89.13 W | 8192 | 3511 | 1.63 WM | 4096 | 114 | 56.16 WM | 8192 | 32 | 15.76 WM | 12288 | 12 | 5.91 WM | 16384 | 8 | 3.94 WM | 24576 | 7 | 3.45 WM | 36864 | 6 | 2.96 WM | 20480 | 6 | 2.96 WM | 131072 | 4 | 1.97 WM | 40960 | 4 | 1.97 WS | 4096 | 128 | 44.91 WS | 8192 | 48 | 16.84 WS | 131072 | 29 | 10.18 WS | 12288 | 25 | 8.77 WS | 45056 | 8 | 2.81 WS | 49152 | 7 | 2.46 WS | 24576 | 6 | 2.11 WS | 32768 | 6 | 2.11 (24 rows) deltas hash workers:3 work_mem:2MB type | bytes | count | pct ------+-------------+--------+------- RA | 131072 | 63527 | 69.62 RA | 32768 | 4298 | 4.71 RA | 8192 | 3089 | 3.39 RM | 4096 | 8 | 4.76 RM | -1476218880 | 3 | 1.79 RM | -1744740352 | 3 | 1.79 W | 131072 | 190604 | 88.47 W | 65536 | 5133 | 2.38 WM | 8192 | 17 | 8.37 WM | 2147446784 | 8 | 3.94 WM | 2147430400 | 8 | 3.94 WM | 28672 | 7 | 3.45 WM | 24576 | 6 | 2.96 WM | 2147483648 | 6 | 2.96 WM | 16384 | 5 | 2.46 WM | 110592 | 4 | 1.97 WM | 36864 | 4 | 1.97 WM | 20480 | 4 | 1.97 WS | 4096 | 62 | 21.75 WS | 8192 | 48 | 16.84 WS | 131072 | 29 | 10.18 WS | 12288 | 25 | 8.77 WS | 45056 | 8 | 2.81 WS | 49152 | 7 | 2.46 WS | 32768 | 6 | 2.11 WS | 24576 | 6 | 2.11 (26 rows) bytes hash workers:3 work_mem:4MB type | bytes | count | pct ------+--------+--------+------- RA | 131072 | 67028 | 83.13 RA | 32768 | 4945 | 6.13 RA | 8192 | 3631 | 4.5 RA | 90112 | 2335 | 2.9 RM | 4096 | 173 | 100 W | 131072 | 203536 | 83.55 W | 40960 | 6636 | 2.72 W | 32768 | 6088 | 2.5 W | 49152 | 4174 | 1.71 W | 24576 | 3909 | 1.6 WM | 4096 | 126 | 58.06 WM | 8192 | 28 | 12.9 WM | 12288 | 19 | 8.76 WM | 16384 | 11 | 5.07 WM | 28672 | 6 | 2.76 WM | 24576 | 5 | 2.3 WM | 20480 | 4 | 1.84 WS | 4096 | 138 | 45.85 WS | 8192 | 49 | 16.28 WS | 12288 | 25 | 8.31 WS | 131072 | 25 | 8.31 WS | 20480 | 7 | 2.33 WS | 40960 | 6 | 1.99 WS | 32768 | 6 | 1.99 WS | 73728 | 6 | 1.99 WS | 45056 | 6 | 1.99 (26 rows) deltas hash workers:3 work_mem:4MB type | bytes | count | pct ------+-------------+--------+------- RA | 131072 | 59359 | 73.62 RA | 32768 | 4456 | 5.53 RA | 8192 | 3195 | 3.96 RM | 4096 | 10 | 5.78 RM | -1342005248 | 3 | 1.73 RM | -1744646144 | 3 | 1.73 W | 131072 | 202657 | 83.19 W | 65536 | 13573 | 5.57 WM | 8192 | 25 | 11.52 WM | 12288 | 12 | 5.53 WM | 2147483648 | 7 | 3.23 WM | 16384 | 7 | 3.23 WM | 2147438592 | 6 | 2.76 WM | 2147471360 | 5 | 2.3 WM | 2147430400 | 5 | 2.3 WM | 28672 | 5 | 2.3 WM | 24576 | 4 | 1.84 WM | 2147434496 | 4 | 1.84 WM | 61440 | 4 | 1.84 WM | 32768 | 4 | 1.84 WM | 2147426304 | 4 | 1.84 WM | 2147475456 | 4 | 1.84 WS | 4096 | 64 | 21.26 WS | 8192 | 49 | 16.28 WS | 12288 | 25 | 8.31 WS | 131072 | 25 | 8.31 WS | 20480 | 7 | 2.33 WS | 40960 | 6 | 1.99 WS | 45056 | 6 | 1.99 WS | 32768 | 5 | 1.66 WS | 73728 | 5 | 1.66 (31 rows) bytes hash workers:3 work_mem:8MB type | bytes | count | pct ------+--------+--------+------- RA | 131072 | 74065 | 82.12 RA | 32768 | 5757 | 6.38 RA | 8192 | 4401 | 4.88 RA | 90112 | 2767 | 3.07 RM | 4096 | 172 | 100 W | 131072 | 242220 | 86.82 WM | 4096 | 115 | 54.25 WM | 8192 | 28 | 13.21 WM | 16384 | 20 | 9.43 WM | 12288 | 14 | 6.6 WM | 36864 | 9 | 4.25 WM | 24576 | 6 | 2.83 WM | 28672 | 5 | 2.36 WM | 20480 | 5 | 2.36 WS | 4096 | 135 | 48.39 WS | 8192 | 46 | 16.49 WS | 12288 | 20 | 7.17 WS | 131072 | 10 | 3.58 WS | 49152 | 9 | 3.23 WS | 73728 | 7 | 2.51 WS | 24576 | 7 | 2.51 WS | 69632 | 6 | 2.15 WS | 40960 | 6 | 2.15 (23 rows) deltas hash workers:3 work_mem:8MB type | bytes | count | pct ------+-------------+--------+------- RA | 131072 | 64519 | 71.54 RA | 32768 | 5215 | 5.78 RA | 8192 | 3806 | 4.22 RM | 4096 | 13 | 7.56 RM | -536723456 | 3 | 1.74 RM | -1744646144 | 3 | 1.74 RM | -1878859776 | 3 | 1.74 RM | -2013073408 | 3 | 1.74 RM | -805150720 | 3 | 1.74 RM | -1610432512 | 3 | 1.74 W | 131072 | 242505 | 86.92 WM | 8192 | 27 | 12.74 WM | 16384 | 8 | 3.77 WM | 36864 | 8 | 3.77 WM | 2147438592 | 7 | 3.3 WM | 20480 | 7 | 3.3 WM | 2147446784 | 7 | 3.3 WM | 12288 | 6 | 2.83 WM | 40960 | 5 | 2.36 WM | 2147430400 | 5 | 2.36 WM | 61440 | 5 | 2.36 WM | 28672 | 5 | 2.36 WM | 2147426304 | 4 | 1.89 WM | 2147450880 | 4 | 1.89 WM | 2147483648 | 4 | 1.89 WS | 4096 | 65 | 23.3 WS | 8192 | 46 | 16.49 WS | 12288 | 20 | 7.17 WS | 131072 | 10 | 3.58 WS | 49152 | 8 | 2.87 WS | 73728 | 7 | 2.51 WS | 24576 | 7 | 2.51 WS | 40960 | 6 | 2.15 WS | 69632 | 6 | 2.15 (34 rows) bytes hash workers:3 work_mem:64MB type | bytes | count | pct ------+--------+--------+------- RA | 131072 | 68899 | 83.21 RA | 32768 | 4927 | 5.95 RA | 8192 | 3739 | 4.52 RA | 90112 | 2335 | 2.82 RM | 4096 | 166 | 100 W | 131072 | 181174 | 90.54 WM | 4096 | 121 | 54.5 WM | 8192 | 33 | 14.86 WM | 12288 | 18 | 8.11 WM | 16384 | 17 | 7.66 WM | 28672 | 8 | 3.6 WM | 20480 | 8 | 3.6 WM | 36864 | 6 | 2.7 WM | 24576 | 5 | 2.25 WS | 4096 | 139 | 48.77 WS | 8192 | 52 | 18.25 WS | 12288 | 24 | 8.42 WS | 32768 | 8 | 2.81 WS | 40960 | 8 | 2.81 WS | 57344 | 7 | 2.46 WS | 131072 | 7 | 2.46 WS | 20480 | 6 | 2.11 WS | 45056 | 6 | 2.11 (23 rows) deltas hash workers:3 work_mem:64MB type | bytes | count | pct ------+------------+--------+------- RA | 131072 | 59864 | 72.3 RA | 32768 | 4473 | 5.4 RA | 8192 | 3266 | 3.94 RM | 4096 | 11 | 6.63 W | 131072 | 181201 | 90.55 WM | 8192 | 28 | 12.61 WM | 12288 | 14 | 6.31 WM | 2147430400 | 11 | 4.95 WM | 24576 | 9 | 4.05 WM | 20480 | 9 | 4.05 WM | 69632 | 7 | 3.15 WM | 65536 | 6 | 2.7 WM | 16384 | 6 | 2.7 WM | 2147418112 | 5 | 2.25 WM | 2147414016 | 4 | 1.8 WM | 2147426304 | 4 | 1.8 WM | 32768 | 4 | 1.8 WM | 28672 | 4 | 1.8 WS | 4096 | 63 | 22.11 WS | 8192 | 52 | 18.25 WS | 12288 | 24 | 8.42 WS | 40960 | 8 | 2.81 WS | 32768 | 8 | 2.81 WS | 131072 | 7 | 2.46 WS | 57344 | 6 | 2.11 WS | 20480 | 6 | 2.11 WS | 45056 | 6 | 2.11 (27 rows) bytes hash workers:3 work_mem:256MB type | bytes | count | pct ------+--------+--------+------- R | 4096 | 4 | 100 RA | 131072 | 66692 | 84.68 RA | 32768 | 4486 | 5.7 RA | 8192 | 3365 | 4.27 RA | 90112 | 2201 | 2.79 RM | 4096 | 158 | 100 W | 131072 | 151013 | 93.61 WM | 4096 | 116 | 54.46 WM | 8192 | 38 | 17.84 WM | 12288 | 16 | 7.51 WM | 16384 | 13 | 6.1 WM | 32768 | 8 | 3.76 WM | 24576 | 8 | 3.76 WM | 28672 | 5 | 2.35 WS | 4096 | 137 | 49.1 WS | 8192 | 56 | 20.07 WS | 12288 | 20 | 7.17 WS | 36864 | 8 | 2.87 WS | 20480 | 7 | 2.51 WS | 45056 | 6 | 2.15 WS | 49152 | 6 | 2.15 WS | 131072 | 5 | 1.79 WS | 40960 | 5 | 1.79 (23 rows) deltas hash workers:3 work_mem:256MB type | bytes | count | pct ------+-------------+--------+------- RA | 131072 | 57226 | 72.66 RA | 32768 | 4054 | 5.15 RA | 8192 | 2961 | 3.76 RM | 4096 | 6 | 3.8 RM | -939466752 | 3 | 1.9 RM | -1878872064 | 3 | 1.9 W | 131072 | 150779 | 93.46 WM | 8192 | 24 | 11.27 WM | 12288 | 11 | 5.16 WM | 24576 | 7 | 3.29 WM | 28672 | 7 | 3.29 WM | 2147446784 | 6 | 2.82 WM | 2147450880 | 5 | 2.35 WM | 2147454976 | 5 | 2.35 WM | 98304 | 5 | 2.35 WM | 16384 | 5 | 2.35 WM | 61440 | 5 | 2.35 WM | 2147430400 | 5 | 2.35 WM | 2147426304 | 5 | 2.35 WM | 102400 | 4 | 1.88 WM | 94208 | 4 | 1.88 WM | 20480 | 4 | 1.88 WM | 2147389440 | 4 | 1.88 WM | 2147381248 | 4 | 1.88 WS | 4096 | 64 | 22.94 WS | 8192 | 56 | 20.07 WS | 12288 | 20 | 7.17 WS | 36864 | 8 | 2.87 WS | 20480 | 7 | 2.51 WS | 49152 | 6 | 2.15 WS | 45056 | 6 | 2.15 WS | 40960 | 5 | 1.79 WS | 131072 | 5 | 1.79 (33 rows) bytes sort workers:0 work_mem:2MB type | bytes | count | pct ------+--------+--------+------- RA | 131072 | 26436 | 76.28 RA | 32768 | 2942 | 8.49 RA | 8192 | 2220 | 6.41 RA | 90112 | 930 | 2.68 RA | 16384 | 733 | 2.12 RM | 4096 | 67 | 100 W | 131072 | 414201 | 85.99 W | 24576 | 13291 | 2.76 WM | 4096 | 60 | 70.59 WM | 8192 | 5 | 5.88 WM | 12288 | 5 | 5.88 WM | 61440 | 4 | 4.71 WM | 20480 | 4 | 4.71 WM | 16384 | 4 | 4.71 WS | 4096 | 147 | 49.83 WS | 8192 | 119 | 40.34 WS | 20480 | 7 | 2.37 WS | 40960 | 5 | 1.69 (18 rows) deltas sort workers:0 work_mem:2MB type | bytes | count | pct ------+------------+--------+------- RA | 131072 | 23152 | 66.81 RA | 32768 | 2638 | 7.61 RA | 8192 | 2035 | 5.87 RM | 4096 | 4 | 5.97 W | 131072 | 396680 | 82.35 WM | 122880 | 7 | 8.24 WM | 2147483648 | 5 | 5.88 WM | 2147360768 | 4 | 4.71 WM | 126976 | 3 | 3.53 WM | 61440 | 3 | 3.53 WS | 8192 | 115 | 38.98 WS | 4096 | 67 | 22.71 WS | 20480 | 7 | 2.37 (13 rows) bytes sort workers:0 work_mem:4MB type | bytes | count | pct ------+--------+--------+------- RA | 131072 | 22968 | 67.9 RA | 32768 | 2839 | 8.39 RA | 8192 | 2750 | 8.13 RA | 16384 | 2380 | 7.04 RA | 73728 | 2356 | 6.97 RM | 4096 | 67 | 100 W | 131072 | 343706 | 90.82 W | 65536 | 25735 | 6.8 WM | 4096 | 61 | 69.32 WM | 8192 | 6 | 6.82 WM | 16384 | 5 | 5.68 WM | 20480 | 5 | 5.68 WM | 61440 | 4 | 4.55 WM | 12288 | 4 | 4.55 WM | 24576 | 3 | 3.41 WS | 4096 | 139 | 50 WS | 8192 | 108 | 38.85 WS | 20480 | 8 | 2.88 WS | 45056 | 5 | 1.8 (19 rows) deltas sort workers:0 work_mem:4MB type | bytes | count | pct ------+------------+--------+------- RA | 131072 | 19821 | 58.6 RA | 32768 | 2718 | 8.04 RA | 8192 | 2626 | 7.76 RM | 4096 | 3 | 4.48 W | 131072 | 326510 | 86.28 W | 917504 | 6520 | 1.72 WM | 16384 | 9 | 10.23 WM | 2147467264 | 7 | 7.95 WM | 2147483648 | 4 | 4.55 WM | 2147528704 | 3 | 3.41 WM | 61440 | 3 | 3.41 WS | 8192 | 103 | 37.05 WS | 4096 | 65 | 23.38 WS | 20480 | 8 | 2.88 WS | 45056 | 5 | 1.8 (15 rows) bytes sort workers:0 work_mem:8MB type | bytes | count | pct ------+--------+--------+------- RA | 131072 | 26605 | 81.02 RA | 32768 | 1911 | 5.82 RA | 8192 | 1685 | 5.13 RA | 16384 | 918 | 2.8 RA | 73728 | 704 | 2.14 RA | 90112 | 586 | 1.78 RM | 4096 | 69 | 100 W | 131072 | 278718 | 90.72 WM | 4096 | 68 | 73.91 WM | 8192 | 7 | 7.61 WM | 61440 | 4 | 4.35 WM | 16384 | 4 | 4.35 WM | 20480 | 3 | 3.26 WS | 4096 | 125 | 50 WS | 8192 | 96 | 38.4 WS | 20480 | 8 | 3.2 WS | 32768 | 5 | 2 WS | 45056 | 4 | 1.6 WS | 49152 | 4 | 1.6 (19 rows) deltas sort workers:0 work_mem:8MB type | bytes | count | pct ------+------------+--------+------- RA | 131072 | 23123 | 70.42 RA | 32768 | 1707 | 5.2 RA | 8192 | 1613 | 4.91 RM | 4096 | 4 | 5.8 W | 131072 | 277206 | 90.23 WM | 40960 | 10 | 10.87 WM | 2147442688 | 7 | 7.61 WM | 61440 | 4 | 4.35 WM | 2147483648 | 3 | 3.26 WS | 8192 | 94 | 37.6 WS | 4096 | 58 | 23.2 WS | 20480 | 8 | 3.2 WS | 32768 | 5 | 2 WS | 49152 | 4 | 1.6 WS | 45056 | 4 | 1.6 (15 rows) bytes sort workers:0 work_mem:64MB type | bytes | count | pct ------+--------+-------+------- RA | 131072 | 35011 | 97.12 RM | 4096 | 69 | 100 W | 131072 | 97686 | 93.18 W | 98304 | 2026 | 1.93 WM | 4096 | 68 | 75.56 WM | 8192 | 6 | 6.67 WM | 32768 | 4 | 4.44 WM | 61440 | 3 | 3.33 WM | 20480 | 3 | 3.33 WS | 4096 | 115 | 49.78 WS | 8192 | 82 | 35.5 WS | 20480 | 9 | 3.9 WS | 40960 | 7 | 3.03 WS | 45056 | 6 | 2.6 (14 rows) deltas sort workers:0 work_mem:64MB type | bytes | count | pct ------+------------+-------+------- RA | 131072 | 30069 | 83.41 RM | 4096 | 4 | 5.8 RM | -670937088 | 3 | 4.35 W | 131072 | 95970 | 91.54 W | 16842752 | 1629 | 1.55 WM | 2147483648 | 5 | 5.56 WM | 69632 | 5 | 5.56 WM | 2147414016 | 4 | 4.44 WM | 65536 | 4 | 4.44 WS | 8192 | 82 | 35.5 WS | 4096 | 65 | 28.14 WS | 20480 | 8 | 3.46 WS | 40960 | 7 | 3.03 WS | 45056 | 6 | 2.6 (14 rows) bytes sort workers:0 work_mem:256MB type | bytes | count | pct ------+--------+-------+------- RA | 131072 | 29628 | 98.85 RM | 4096 | 68 | 100 W | 131072 | 64928 | 95.72 WM | 4096 | 75 | 74.26 WM | 8192 | 6 | 5.94 WM | 12288 | 5 | 4.95 WM | 20480 | 4 | 3.96 WM | 16384 | 4 | 3.96 WM | 61440 | 3 | 2.97 WS | 4096 | 92 | 49.46 WS | 8192 | 62 | 33.33 WS | 20480 | 8 | 4.3 WS | 40960 | 8 | 4.3 WS | 45056 | 4 | 2.15 WS | 24576 | 3 | 1.61 (15 rows) deltas sort workers:0 work_mem:256MB type | bytes | count | pct ------+------------+-------+------- RA | 131072 | 27853 | 92.93 RM | 4096 | 4 | 5.88 W | 131072 | 64850 | 95.61 WM | 94208 | 8 | 7.92 WM | 2147389440 | 6 | 5.94 WM | 2147483648 | 5 | 4.95 WM | 61440 | 4 | 3.96 WM | 90112 | 3 | 2.97 WS | 8192 | 62 | 33.33 WS | 4096 | 60 | 32.26 WS | 40960 | 8 | 4.3 WS | 20480 | 8 | 4.3 WS | 45056 | 4 | 2.15 WS | 24576 | 3 | 1.61 (14 rows) bytes sort workers:3 work_mem:2MB type | bytes | count | pct ------+--------+--------+------- RA | 131072 | 28421 | 74.59 RA | 32768 | 3160 | 8.29 RA | 8192 | 2628 | 6.9 RA | 16384 | 1099 | 2.88 RA | 90112 | 1079 | 2.83 RA | 73728 | 800 | 2.1 RM | 4096 | 71 | 100 W | 131072 | 350756 | 85.28 W | 24576 | 11161 | 2.71 WM | 4096 | 37 | 47.44 WM | 16384 | 12 | 15.38 WM | 8192 | 10 | 12.82 WM | 61440 | 3 | 3.85 WM | 32768 | 3 | 3.85 WM | 24576 | 3 | 3.85 WM | 12288 | 3 | 3.85 WS | 4096 | 107 | 50 WS | 8192 | 65 | 30.37 WS | 28672 | 7 | 3.27 WS | 32768 | 6 | 2.8 WS | 36864 | 5 | 2.34 WS | 40960 | 4 | 1.87 WS | 53248 | 4 | 1.87 WS | 45056 | 4 | 1.87 (24 rows) deltas sort workers:3 work_mem:2MB type | bytes | count | pct ------+------------+--------+------- RA | 131072 | 23610 | 61.96 RA | 32768 | 2110 | 5.54 RA | 8192 | 1752 | 4.6 RM | 4096 | 4 | 5.63 W | 131072 | 337328 | 82.01 WM | 122880 | 6 | 7.69 WM | 2147360768 | 5 | 6.41 WM | 2147483648 | 3 | 3.85 WM | 8192 | 3 | 3.85 WM | 2281574400 | 3 | 3.85 WM | 12288 | 3 | 3.85 WS | 8192 | 61 | 28.5 WS | 4096 | 48 | 22.43 WS | 28672 | 7 | 3.27 WS | 32768 | 6 | 2.8 WS | 36864 | 5 | 2.34 WS | 40960 | 4 | 1.87 WS | 45056 | 4 | 1.87 WS | 53248 | 4 | 1.87 (19 rows) bytes sort workers:3 work_mem:4MB type | bytes | count | pct ------+--------+--------+------- RA | 131072 | 18560 | 68.62 RA | 32768 | 2212 | 8.18 RA | 8192 | 2059 | 7.61 RA | 16384 | 1727 | 6.39 RA | 73728 | 1682 | 6.22 RM | 4096 | 71 | 100 W | 131072 | 281880 | 89.03 W | 65536 | 23480 | 7.42 WM | 4096 | 51 | 56.04 WM | 16384 | 11 | 12.09 WM | 8192 | 7 | 7.69 WM | 12288 | 7 | 7.69 WM | 61440 | 4 | 4.4 WM | 32768 | 4 | 4.4 WM | 24576 | 4 | 4.4 WS | 4096 | 104 | 50 WS | 8192 | 67 | 32.21 WS | 32768 | 5 | 2.4 WS | 45056 | 4 | 1.92 WS | 36864 | 4 | 1.92 WS | 53248 | 4 | 1.92 (21 rows) deltas sort workers:3 work_mem:4MB type | bytes | count | pct ------+------------+--------+------- RA | 131072 | 15323 | 56.66 RA | 32768 | 1469 | 5.43 RA | 8192 | 1390 | 5.14 RM | 4096 | 3 | 4.23 W | 131072 | 270163 | 85.33 WM | 20480 | 8 | 8.79 WM | 2147463168 | 7 | 7.69 WM | 2147483648 | 5 | 5.49 WM | 16384 | 5 | 5.49 WM | 8192 | 3 | 3.3 WS | 8192 | 65 | 31.25 WS | 4096 | 45 | 21.63 WS | 32768 | 4 | 1.92 WS | 36864 | 4 | 1.92 WS | 45056 | 4 | 1.92 WS | 53248 | 4 | 1.92 (16 rows) bytes sort workers:3 work_mem:8MB type | bytes | count | pct ------+--------+--------+------- RA | 131072 | 22154 | 80.68 RA | 32768 | 1583 | 5.76 RA | 8192 | 1387 | 5.05 RA | 16384 | 712 | 2.59 RA | 73728 | 540 | 1.97 RA | 90112 | 435 | 1.58 RM | 4096 | 69 | 100 W | 131072 | 223454 | 89.73 WM | 4096 | 40 | 50.63 WM | 16384 | 11 | 13.92 WM | 8192 | 7 | 8.86 WM | 12288 | 7 | 8.86 WM | 61440 | 4 | 5.06 WM | 20480 | 3 | 3.8 WM | 24576 | 3 | 3.8 WS | 4096 | 104 | 50 WS | 8192 | 65 | 31.25 WS | 40960 | 7 | 3.37 WS | 45056 | 5 | 2.4 WS | 36864 | 5 | 2.4 WS | 28672 | 4 | 1.92 (21 rows) deltas sort workers:3 work_mem:8MB type | bytes | count | pct ------+------------+--------+------- RA | 131072 | 18828 | 68.57 RA | 32768 | 1045 | 3.81 RA | 8192 | 1021 | 3.72 W | 131072 | 221624 | 89 WM | 12288 | 5 | 6.33 WM | 2147430400 | 5 | 6.33 WM | 53248 | 5 | 6.33 WM | 49152 | 4 | 5.06 WM | 2147483648 | 4 | 5.06 WM | 16384 | 3 | 3.8 WM | 2147434496 | 3 | 3.8 WS | 8192 | 62 | 29.81 WS | 4096 | 52 | 25 WS | 40960 | 7 | 3.37 WS | 45056 | 5 | 2.4 WS | 36864 | 5 | 2.4 WS | 28672 | 4 | 1.92 (17 rows) bytes sort workers:3 work_mem:64MB type | bytes | count | pct ------+--------+-------+------- RA | 131072 | 24379 | 93.77 RM | 4096 | 70 | 100 W | 131072 | 66918 | 94.81 WM | 4096 | 57 | 56.44 WM | 8192 | 13 | 12.87 WM | 16384 | 10 | 9.9 WM | 12288 | 9 | 8.91 WM | 32768 | 4 | 3.96 WM | 61440 | 3 | 2.97 WS | 4096 | 96 | 49.74 WS | 8192 | 38 | 19.69 WS | 28672 | 16 | 8.29 WS | 32768 | 10 | 5.18 WS | 24576 | 7 | 3.63 WS | 36864 | 6 | 3.11 WS | 40960 | 6 | 3.11 (16 rows) deltas sort workers:3 work_mem:64MB type | bytes | count | pct ------+------------+-------+------- RA | 131072 | 21533 | 82.82 RM | 4096 | 3 | 4.29 W | 131072 | 66878 | 94.75 WM | 8192 | 8 | 7.92 WM | 12288 | 6 | 5.94 WM | 2147401728 | 5 | 4.95 WM | 81920 | 5 | 4.95 WM | 16384 | 4 | 3.96 WM | 134213632 | 3 | 2.97 WM | 2147483648 | 3 | 2.97 WS | 8192 | 38 | 19.69 WS | 4096 | 35 | 18.13 WS | 28672 | 15 | 7.77 WS | 32768 | 8 | 4.15 WS | 24576 | 7 | 3.63 WS | 36864 | 5 | 2.59 WS | 40960 | 5 | 2.59 (17 rows) bytes sort workers:3 work_mem:256MB type | bytes | count | pct ------+--------+-------+------- RA | 131072 | 35527 | 98.18 RM | 4096 | 72 | 100 W | 131072 | 64655 | 95.61 WM | 4096 | 67 | 61.47 WM | 8192 | 19 | 17.43 WM | 12288 | 10 | 9.17 WM | 16384 | 5 | 4.59 WM | 61440 | 3 | 2.75 WS | 4096 | 68 | 49.28 WS | 8192 | 29 | 21.01 WS | 40960 | 7 | 5.07 WS | 49152 | 6 | 4.35 WS | 45056 | 6 | 4.35 WS | 28672 | 5 | 3.62 WS | 24576 | 4 | 2.9 WS | 53248 | 3 | 2.17 WS | 36864 | 3 | 2.17 (17 rows) deltas sort workers:3 work_mem:256MB type | bytes | count | pct ------+-------------+-------+------- RA | 131072 | 33547 | 92.71 RM | 4096 | 5 | 6.94 RM | -1207791616 | 3 | 4.17 W | 131072 | 64595 | 95.52 WM | 8192 | 8 | 7.34 WM | 16384 | 7 | 6.42 WM | 12288 | 5 | 4.59 WM | 110592 | 5 | 4.59 WM | 2147438592 | 4 | 3.67 WM | 2147373056 | 4 | 3.67 WM | 2147483648 | 3 | 2.75 WM | -8192 | 3 | 2.75 WS | 8192 | 29 | 21.01 WS | 4096 | 25 | 18.12 WS | 40960 | 6 | 4.35 WS | 49152 | 5 | 3.62 WS | 28672 | 5 | 3.62 WS | 45056 | 5 | 3.62 WS | 24576 | 4 | 2.9 (19 rows)