comphead commented on PR #18875: URL: https://github.com/apache/datafusion/pull/18875#issuecomment-3633198799
TPCDS benches, sorry for being late ``` ┏━━━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┓ ┃ Query ┃ with ┃ without ┃ Change ┃ ┡━━━━━━━━━━━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━━━━┩ │ QQuery 1 │ 35.39 ms │ 34.56 ms │ no change │ │ QQuery 2 │ 108.17 ms │ 107.45 ms │ no change │ │ QQuery 3 │ 95.07 ms │ 92.13 ms │ no change │ │ QQuery 4 │ 918.80 ms │ 953.76 ms │ no change │ │ QQuery 5 │ 136.87 ms │ 135.88 ms │ no change │ │ QQuery 6 │ 519.09 ms │ 699.13 ms │ 1.35x slower │ │ QQuery 7 │ 270.91 ms │ 261.45 ms │ no change │ │ QQuery 8 │ 91.91 ms │ 90.78 ms │ no change │ │ QQuery 9 │ 87.32 ms │ 90.48 ms │ no change │ │ QQuery 10 │ 83.09 ms │ 82.85 ms │ no change │ │ QQuery 11 │ 587.29 ms │ 613.38 ms │ no change │ │ QQuery 12 │ 36.57 ms │ 36.34 ms │ no change │ │ QQuery 13 │ 303.08 ms │ 303.84 ms │ no change │ │ QQuery 14 │ 749.29 ms │ 730.68 ms │ no change │ │ QQuery 15 │ 20.97 ms │ 11.14 ms │ +1.88x faster │ │ QQuery 16 │ 30.28 ms │ 29.88 ms │ no change │ │ QQuery 17 │ 195.40 ms │ 172.99 ms │ +1.13x faster │ │ QQuery 18 │ 104.02 ms │ 92.51 ms │ +1.12x faster │ │ QQuery 19 │ 122.21 ms │ 123.04 ms │ no change │ │ QQuery 20 │ 10.36 ms │ 9.81 ms │ +1.06x faster │ │ QQuery 21 │ 14.47 ms │ 13.45 ms │ +1.08x faster │ │ QQuery 22 │ 407.98 ms │ 402.95 ms │ no change │ │ QQuery 23 │ 788.17 ms │ 769.05 ms │ no change │ │ QQuery 24 │ 331.00 ms │ 307.41 ms │ +1.08x faster │ │ QQuery 25 │ 288.60 ms │ 260.48 ms │ +1.11x faster │ │ QQuery 26 │ 74.37 ms │ 62.38 ms │ +1.19x faster │ │ QQuery 27 │ 266.95 ms │ 257.78 ms │ no change │ │ QQuery 28 │ 124.19 ms │ 124.60 ms │ no change │ │ QQuery 29 │ 236.50 ms │ 216.35 ms │ +1.09x faster │ │ QQuery 30 │ 32.71 ms │ 32.04 ms │ no change │ │ QQuery 31 │ 118.62 ms │ 116.68 ms │ no change │ │ QQuery 32 │ 46.17 ms │ 44.91 ms │ no change │ │ QQuery 33 │ 109.73 ms │ 108.69 ms │ no change │ │ QQuery 34 │ 85.35 ms │ 82.13 ms │ no change │ │ QQuery 35 │ 81.90 ms │ 80.08 ms │ no change │ │ QQuery 36 │ 164.28 ms │ 164.69 ms │ no change │ │ QQuery 37 │ 150.62 ms │ 143.94 ms │ no change │ │ QQuery 38 │ 60.51 ms │ 60.23 ms │ no change │ │ QQuery 39 │ 78.16 ms │ 77.55 ms │ no change │ │ QQuery 40 │ 85.87 ms │ 87.97 ms │ no change │ │ QQuery 41 │ 8.90 ms │ 8.47 ms │ no change │ │ QQuery 42 │ 87.33 ms │ 87.46 ms │ no change │ │ QQuery 43 │ 68.13 ms │ 68.30 ms │ no change │ │ QQuery 44 │ 7.87 ms │ 7.67 ms │ no change │ │ QQuery 45 │ 47.14 ms │ 37.34 ms │ +1.26x faster │ │ QQuery 46 │ 178.11 ms │ 173.12 ms │ no change │ │ QQuery 47 │ 525.12 ms │ 525.53 ms │ no change │ │ QQuery 48 │ 213.68 ms │ 211.63 ms │ no change │ │ QQuery 49 │ 194.12 ms │ 194.98 ms │ no change │ │ QQuery 50 │ 162.76 ms │ 154.74 ms │ no change │ │ QQuery 51 │ 130.71 ms │ 128.29 ms │ no change │ │ QQuery 52 │ 88.02 ms │ 89.30 ms │ no change │ │ QQuery 53 │ 84.55 ms │ 83.86 ms │ no change │ │ QQuery 54 │ 113.43 ms │ 113.00 ms │ no change │ │ QQuery 55 │ 87.71 ms │ 86.97 ms │ no change │ │ QQuery 56 │ 110.38 ms │ 110.40 ms │ no change │ │ QQuery 57 │ 140.65 ms │ 139.42 ms │ no change │ │ QQuery 58 │ 222.73 ms │ 214.26 ms │ no change │ │ QQuery 59 │ 132.77 ms │ 131.62 ms │ no change │ │ QQuery 60 │ 110.21 ms │ 112.34 ms │ no change │ │ QQuery 61 │ 142.82 ms │ 136.83 ms │ no change │ │ QQuery 62 │ 406.87 ms │ 491.54 ms │ 1.21x slower │ │ QQuery 63 │ 86.25 ms │ 83.74 ms │ no change │ │ QQuery 64 │ 535.71 ms │ 517.70 ms │ no change │ │ QQuery 65 │ 187.66 ms │ 189.66 ms │ no change │ │ QQuery 66 │ 170.35 ms │ 176.14 ms │ no change │ │ QQuery 67 │ 260.98 ms │ 261.36 ms │ no change │ │ QQuery 68 │ 213.97 ms │ 213.81 ms │ no change │ │ QQuery 69 │ 83.22 ms │ 82.90 ms │ no change │ │ QQuery 70 │ 266.18 ms │ 267.79 ms │ no change │ │ QQuery 71 │ 108.12 ms │ 105.49 ms │ no change │ │ QQuery 72 │ 493.60 ms │ 467.64 ms │ +1.06x faster │ │ QQuery 73 │ 82.54 ms │ 80.81 ms │ no change │ │ QQuery 74 │ 367.18 ms │ 363.52 ms │ no change │ │ QQuery 75 │ 213.68 ms │ 216.20 ms │ no change │ │ QQuery 76 │ 110.79 ms │ 105.19 ms │ +1.05x faster │ │ QQuery 77 │ 149.31 ms │ 149.22 ms │ no change │ │ QQuery 78 │ 386.11 ms │ 386.48 ms │ no change │ │ QQuery 79 │ 173.55 ms │ 174.38 ms │ no change │ │ QQuery 80 │ 251.29 ms │ 250.99 ms │ no change │ │ QQuery 81 │ 19.91 ms │ 20.35 ms │ no change │ │ QQuery 82 │ 166.62 ms │ 168.14 ms │ no change │ │ QQuery 83 │ 37.67 ms │ 29.41 ms │ +1.28x faster │ │ QQuery 84 │ 37.38 ms │ 35.53 ms │ no change │ │ QQuery 85 │ 120.55 ms │ 109.51 ms │ +1.10x faster │ │ QQuery 86 │ 31.01 ms │ 30.24 ms │ no change │ │ QQuery 87 │ 60.35 ms │ 60.85 ms │ no change │ │ QQuery 88 │ 77.07 ms │ 78.30 ms │ no change │ │ QQuery 89 │ 96.91 ms │ 98.38 ms │ no change │ │ QQuery 90 │ 16.44 ms │ 17.19 ms │ no change │ │ QQuery 91 │ 46.71 ms │ 45.57 ms │ no change │ │ QQuery 92 │ 45.43 ms │ 45.54 ms │ no change │ │ QQuery 93 │ 136.89 ms │ 137.16 ms │ no change │ │ QQuery 94 │ 46.28 ms │ 46.87 ms │ no change │ │ QQuery 95 │ 112.53 ms │ 95.73 ms │ +1.18x faster │ │ QQuery 96 │ 56.71 ms │ 57.81 ms │ no change │ │ QQuery 97 │ 88.91 ms │ 89.15 ms │ no change │ │ QQuery 98 │ 127.11 ms │ 127.86 ms │ no change │ │ QQuery 99 │ 4425.99 ms │ 5735.09 ms │ 1.30x slower │ └──────────────┴────────────┴────────────┴───────────────┘ ┏━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓ ┃ Benchmark Summary ┃ ┃ ┡━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━┩ │ Total Time (main) │ 21207.18ms │ │ Total Time (dev3) │ 22514.21ms │ │ Average Time (main) │ 214.21ms │ │ Average Time (dev3) │ 227.42ms │ │ Queries Faster │ 15 │ │ Queries Slower │ 3 │ │ Queries with No Change │ 81 │ │ Queries with Failure │ 0 │ └────────────────────────┴────────────┘ ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
