# Timing summary: median [95% CI of the median], ms

- dirty samples discarded: f2d7570/run1: 3
- dirty samples discarded: master/run1: 49
- dirty samples discarded: master/run2: 53
- dirty samples discarded: proto/run1: 77
- dirty samples discarded: proto/run2: 7
- dirty samples discarded: r18/run1: 3

| build | run | variant | n | client wall | planning | execution |
|---|---|---|---|---|---|---|
| f2d7570 | run1 | IN@dpq | 10 | 604.03 [601.41, 605.00] | 132.19 [129.51, 133.64] | 459.53 [458.66, 460.70] |
| f2d7570 | run1 | IN@par | 10 | 370.42 [369.20, 372.00] | 126.11 [124.62, 128.49] | 231.23 [230.13, 231.57] |
| f2d7570 | run1 | IN@par_idx | 10 | 523.55 [520.64, 525.83] | 84.77 [83.95, 85.37] | 438.95 [437.52, 440.92] |
| f2d7570 | run1 | IN@ser | 10 | 187.69 [185.21, 190.15] | 129.46 [128.72, 130.31] | 43.85 [43.45, 44.20] |
| f2d7570 | run1 | IN@ser_idx | 10 | 158.17 [155.09, 160.70] | 130.86 [129.38, 131.73] | 13.78 [13.65, 13.94] |
| f2d7570 | run1 | SPLIT@par | 10 | 361.96 [356.68, 365.27] | 319.03 [315.74, 322.00] | 36.85 [36.52, 37.15] |
| f2d7570 | run1 | SPLIT@ser | 10 | 335.49 [334.53, 339.94] | 324.00 [320.25, 326.00] | 6.97 [6.60, 7.19] |
| f2d7570 | run1 | VALUESc@nl | 10 | 26.92 [26.25, 27.50] | 10.95 [10.18, 11.42] | 13.85 [13.71, 14.26] |
| f2d7570 | run1 | VALUESc@par | 10 | 41.36 [40.40, 42.62] | 10.79 [10.43, 11.12] | 34.60 [34.20, 35.54] |
| f2d7570 | run1 | VALUESc@ser | 10 | 47.80 [47.25, 48.36] | 10.33 [10.03, 10.51] | 48.78 [48.47, 49.58] |
| f2d7570 | run1 | VALUESr@nl | 10 | 26.28 [25.38, 27.64] | 10.70 [10.56, 11.40] | 13.62 [13.43, 13.97] |
| f2d7570 | run1 | VALUESr@par | 10 | 41.80 [40.51, 42.70] | 9.84 [9.65, 10.10] | 35.56 [35.12, 35.92] |
| f2d7570 | run1 | VALUESr@ser | 10 | 47.81 [47.18, 50.09] | 10.27 [9.65, 10.62] | 48.63 [48.09, 49.19] |
| master | run1 | IN@dpq | 10 | 594.79 [588.34, 601.23] | 86.11 [85.26, 87.12] | 441.76 [440.28, 444.17] |
| master | run1 | IN@par | 10 | 367.57 [364.03, 373.94] | 129.74 [127.82, 131.36] | 224.37 [222.37, 230.93] |
| master | run1 | IN@par_idx | 9 | 510.27 [505.70, 513.59] | 86.69 [86.14, 87.84] | 424.06 [421.21, 427.58] |
| master | run1 | IN@ser | 10 | 193.63 [189.66, 195.30] | 133.22 [131.39, 134.51] | 44.38 [43.67, 44.97] |
| master | run1 | IN@ser_idx | 10 | 163.62 [162.06, 165.43] | 134.53 [133.20, 135.91] | 13.91 [13.76, 14.04] |
| master | run1 | SPLIT@par | 10 | 330.06 [329.06, 330.98] | 291.66 [289.93, 292.94] | 36.80 [36.32, 37.19] |
| master | run1 | SPLIT@ser | 10 | 304.55 [304.00, 307.03] | 297.76 [295.82, 298.90] | 6.91 [6.62, 7.23] |
| master | run1 | VALUESc@nl | 10 | 26.31 [25.73, 26.94] | 10.83 [10.68, 11.16] | 13.56 [13.47, 13.70] |
| master | run1 | VALUESc@par | 10 | 40.80 [40.32, 41.94] | 10.63 [10.48, 10.80] | 34.87 [34.32, 35.48] |
| master | run1 | VALUESc@ser | 10 | 47.21 [46.78, 48.25] | 10.07 [9.70, 10.67] | 46.62 [46.43, 46.87] |
| master | run1 | VALUESr@nl | 10 | 25.47 [24.95, 25.95] | 10.27 [10.04, 10.79] | 13.32 [13.08, 13.56] |
| master | run1 | VALUESr@par | 10 | 41.55 [40.62, 42.31] | 10.53 [10.35, 10.75] | 34.70 [33.94, 34.96] |
| master | run1 | VALUESr@ser | 10 | 47.25 [46.94, 48.21] | 9.82 [9.55, 10.12] | 46.75 [46.13, 47.27] |
| master | run2 | IN@dpq | 10 | 593.96 [580.26, 596.58] | 84.81 [83.95, 85.73] | 440.99 [429.92, 445.33] |
| master | run2 | IN@par | 10 | 363.48 [358.27, 368.01] | 128.68 [124.45, 130.65] | 222.08 [218.94, 224.70] |
| master | run2 | IN@par_idx | 10 | 506.18 [501.80, 509.82] | 85.33 [84.74, 86.26] | 419.10 [415.29, 422.60] |
| master | run2 | IN@ser | 10 | 191.52 [188.19, 194.61] | 133.33 [128.18, 135.81] | 44.55 [43.58, 45.14] |
| master | run2 | IN@ser_idx | 10 | 163.12 [162.01, 164.10] | 134.26 [131.27, 134.64] | 13.99 [13.90, 14.18] |
| proto | run1 | IN@dpq | 10 | 597.99 [596.53, 602.60] | 86.97 [85.67, 87.55] | 444.98 [442.38, 447.88] |
| proto | run1 | IN@dpq_proto | 10 | 69.77 [68.21, 71.01] | 19.41 [19.02, 19.81] | 43.49 [42.70, 44.04] |
| proto | run1 | IN@par | 10 | 368.99 [366.56, 372.90] | 129.41 [128.24, 130.27] | 224.44 [221.88, 232.89] |
| proto | run1 | IN@parF | 10 | 507.62 [501.42, 510.35] | 86.44 [85.50, 88.52] | 424.60 [420.20, 427.98] |
| proto | run1 | IN@parF_w0 | 10 | 376.30 [371.25, 379.68] | 85.48 [84.53, 86.02] | 289.91 [285.57, 292.47] |
| proto | run1 | IN@par_idx | 10 | 510.12 [505.31, 514.32] | 87.39 [86.65, 88.40] | 423.80 [421.72, 425.64] |
| proto | run1 | IN@par_proto | 10 | 30.55 [29.96, 31.60] | 22.80 [22.13, 23.20] | 5.97 [5.73, 6.10] |
| proto | run1 | IN@ser | 10 | 190.78 [189.01, 192.56] | 133.34 [129.76, 134.07] | 44.19 [43.45, 44.47] |
| proto | run1 | IN@ser_idx | 10 | 161.90 [158.01, 163.97] | 133.17 [130.43, 133.94] | 13.69 [13.58, 13.78] |
| proto | run1 | IN@ser_proto | 10 | 29.81 [29.30, 30.61] | 22.02 [21.67, 22.85] | 5.86 [5.71, 5.98] |
| proto | run1Q | IN@ser | 10 | 186.83 [184.30, 189.50] | 129.50 [128.14, 131.29] | 42.88 [42.51, 43.21] |
| proto | run1Q | IN@ser_proto | 10 | 28.95 [28.16, 29.92] | 21.51 [21.23, 22.20] | 5.88 [5.80, 6.08] |
| proto | run1Q | SPLIT@ser | 10 | 304.12 [302.36, 305.73] | 295.73 [294.43, 298.09] | 6.90 [6.60, 7.28] |
| proto | run1Q | VALUESc@nl | 10 | 25.71 [25.18, 26.31] | 10.51 [10.21, 10.97] | 13.59 [13.40, 13.75] |
| proto | run1Q | VALUESr@nl | 10 | 25.44 [25.14, 26.34] | 10.59 [10.21, 10.85] | 13.47 [13.10, 13.80] |
| proto | run2 | IN@dpq_proto | 10 | 64.98 [64.17, 66.95] | 18.44 [18.13, 18.65] | 41.20 [40.62, 42.53] |
| proto | run2 | IN@parF | 10 | 492.21 [490.53, 494.30] | 83.56 [82.62, 84.22] | 409.47 [406.06, 412.81] |
| proto | run2 | IN@parF_w0 | 10 | 362.28 [359.36, 364.13] | 83.24 [81.77, 85.08] | 280.32 [278.97, 281.84] |
| proto | run2 | IN@par_proto | 10 | 28.63 [27.86, 30.02] | 22.01 [21.55, 22.71] | 5.78 [5.70, 6.00] |
| proto | run2 | IN@ser_proto | 10 | 28.44 [27.84, 29.65] | 21.28 [21.15, 22.13] | 5.65 [5.58, 5.84] |
| r18 | run1 | IN@dpq | 10 | 598.76 [595.57, 599.94] | 82.19 [81.07, 83.73] | 455.13 [452.82, 456.76] |
| r18 | run1 | IN@par | 10 | 366.48 [365.63, 367.49] | 123.45 [122.33, 125.33] | 228.53 [227.48, 231.00] |
| r18 | run1 | IN@par_idx | 10 | 517.55 [516.56, 518.91] | 82.26 [81.92, 83.05] | 436.26 [434.98, 437.12] |
| r18 | run1 | IN@ser | 10 | 183.84 [181.53, 186.52] | 126.53 [124.31, 128.00] | 43.57 [43.30, 43.96] |
| r18 | run1 | IN@ser_idx | 10 | 152.52 [151.61, 156.54] | 126.56 [125.11, 128.16] | 13.63 [13.54, 13.81] |
| r18 | run1 | SPLIT@par | 10 | 52.81 [51.98, 53.81] | 11.08 [11.00, 11.64] | 37.82 [37.34, 38.81] |
| r18 | run1 | SPLIT@ser | 10 | 24.37 [23.79, 25.15] | 10.76 [10.53, 11.21] | 6.87 [6.69, 7.26] |
| r18 | run1 | VALUESc@nl | 10 | 27.18 [26.70, 27.70] | 10.73 [10.51, 11.77] | 14.31 [14.14, 15.29] |
| r18 | run1 | VALUESc@par | 10 | 42.49 [41.48, 43.68] | 10.82 [10.75, 11.23] | 36.62 [35.76, 37.21] |
| r18 | run1 | VALUESc@ser | 10 | 47.57 [47.02, 49.23] | 10.18 [10.10, 10.48] | 49.34 [48.94, 49.96] |
| r18 | run1 | VALUESr@nl | 10 | 26.74 [26.45, 27.06] | 10.61 [10.38, 11.01] | 13.89 [13.75, 14.27] |
| r18 | run1 | VALUESr@par | 10 | 41.79 [41.04, 43.21] | 9.67 [9.60, 9.97] | 36.56 [35.67, 37.75] |
| r18 | run1 | VALUESr@ser | 10 | 48.28 [47.59, 50.09] | 10.21 [9.65, 11.03] | 48.97 [48.77, 50.95] |

# Comparisons: (to - from) / from, median [95% CI], same binary and run

| build | run | from -> to | what | wall % | planning % | execution % |
|---|---|---|---|---|---|---|
| f2d7570 | run1 | IN@ser_idx -> IN@par_idx | parallel penalty, same full-array index plan | +231.0 [+226.3, +237.6] | -35.2 [-36.1, -34.5] | +3086.1 [+3043.6, +3117.9] |
| f2d7570 | run1 | IN@par_idx -> VALUESc@nl | IN (follow-up shape) vs VALUES nested loop | -94.9 [-95.0, -94.7] | -87.1 [-88.0, -86.5] | -96.8 [-96.9, -96.7] |
| f2d7570 | run1 | VALUESr@nl -> VALUESc@nl | rows vs count(*) form of the rewrite | +2.4 [-3.0, +6.4] | +2.4 [-6.6, +6.8] | +1.7 [-0.7, +5.0] |
| master | run1 | IN@ser_idx -> IN@par_idx | parallel penalty, same full-array index plan | +211.9 [+208.0, +215.3] | -35.6 [-36.4, -34.4] | +2947.8 [+2917.9, +2992.2] |
| master | run1 | IN@par_idx -> VALUESc@nl | IN (follow-up shape) vs VALUES nested loop | -94.8 [-95.0, -94.7] | -87.5 [-87.7, -87.1] | -96.8 [-96.8, -96.8] |
| master | run1 | VALUESr@nl -> VALUESc@nl | rows vs count(*) form of the rewrite | +3.3 [+0.2, +7.4] | +5.5 [+0.1, +9.2] | +1.9 [-0.1, +3.6] |
| master | run2 | IN@ser_idx -> IN@par_idx | parallel penalty, same full-array index plan | +210.3 [+207.0, +213.8] | -36.4 [-36.9, -34.9] | +2894.8 [+2850.0, +2928.2] |
| proto | run1 | IN@ser_idx -> IN@par_idx | parallel penalty, same full-array index plan | +215.1 [+209.9, +221.8] | -34.4 [-35.0, -32.9] | +2994.9 [+2971.7, +3024.6] |
| proto | run1 | IN@ser -> IN@ser_proto | restriction, serial (seq-scan case) | -84.4 [-84.7, -84.0] | -83.5 [-83.8, -82.7] | -86.7 [-87.1, -86.4] |
| proto | run1 | IN@ser_idx -> IN@ser_proto | restriction vs forced index, serial | -81.6 [-82.0, -81.0] | -83.5 [-83.8, -82.7] | -57.2 [-58.3, -56.1] |
| proto | run1 | IN@par -> IN@par_proto | restriction, parallel allowed | -91.7 [-91.9, -91.4] | -82.4 [-82.9, -82.0] | -97.3 [-97.5, -97.3] |
| proto | run1 | IN@par_idx -> IN@par_proto | restriction vs the follow-up's plan shape | -94.0 [-94.2, -93.8] | -73.9 [-74.8, -73.4] | -98.6 [-98.6, -98.6] |
| proto | run1 | IN@dpq -> IN@dpq_proto | restriction, identical single-worker Gather plan | -88.3 [-88.6, -88.1] | -77.7 [-78.1, -77.1] | -90.2 [-90.4, -90.1] |
| proto | run1 | IN@parF_w0 -> IN@parF | workers launched vs Gather with 0 workers | +34.9 [+32.3, +36.8] | +1.1 [-0.3, +3.8] | +46.5 [+44.6, +49.0] |
| proto | run1Q | IN@ser -> IN@ser_proto | restriction, serial (seq-scan case) | -84.5 [-85.0, -84.0] | -83.4 [-83.7, -82.8] | -86.3 [-86.5, -85.8] |
| proto | run1Q | VALUESc@nl -> IN@ser_proto | VALUES nested loop vs restricted IN | +12.6 [+8.6, +17.5] | +104.7 [+96.1, +113.9] | -56.7 [-57.6, -55.0] |
| proto | run1Q | SPLIT@ser -> IN@ser_proto | UNION ALL upper bound vs in-place restriction | -90.5 [-90.8, -90.1] | -92.7 [-92.8, -92.5] | -14.8 [-19.4, -10.7] |
| proto | run1Q | VALUESr@nl -> VALUESc@nl | rows vs count(*) form of the rewrite | +1.1 [-3.0, +3.3] | -0.8 [-4.7, +4.8] | +0.9 [-2.1, +3.3] |
| proto | run2 | IN@parF_w0 -> IN@parF | workers launched vs Gather with 0 workers | +35.9 [+35.0, +37.1] | +0.4 [-2.5, +2.3] | +46.1 [+44.6, +47.4] |
| r18 | run1 | IN@ser_idx -> IN@par_idx | parallel penalty, same full-array index plan | +239.3 [+230.6, +241.9] | -35.0 [-35.8, -34.0] | +3101.2 [+3057.6, +3122.4] |
| r18 | run1 | IN@par_idx -> VALUESc@nl | IN (follow-up shape) vs VALUES nested loop | -94.7 [-94.8, -94.6] | -87.0 [-87.3, -85.7] | -96.7 [-96.8, -96.5] |
| r18 | run1 | VALUESr@nl -> VALUESc@nl | rows vs count(*) form of the rewrite | +1.6 [-0.4, +3.7] | +1.2 [-2.8, +11.9] | +3.0 [-0.3, +10.0] |