github-actions[bot] commented on PR #9676: URL: https://github.com/apache/arrow-datafusion/pull/9676#issuecomment-2039625844
# Benchmark results <details> <summary>Benchmarks comparing 2dad90425bacb98a3c2a4214faad53850c93104e (main) and bdd59057757dc85d3a5352db43538a69c9b12c62 (PR)</summary> ``` Comparing 2dad904 and bdd5905 -------------------- Benchmark tpch_mem_sf1.json -------------------- ┏━━━━━━━━━━━━━━┳━━━━━━━━━━┳━━━━━━━━━━┳━━━━━━━━━━━━━━━┓ ┃ Query ┃ 2dad904 ┃ bdd5905 ┃ Change ┃ ┡━━━━━━━━━━━━━━╇━━━━━━━━━━╇━━━━━━━━━━╇━━━━━━━━━━━━━━━┩ │ QQuery 1 │ 289.48ms │ 291.06ms │ no change │ │ QQuery 2 │ 41.13ms │ 42.37ms │ no change │ │ QQuery 3 │ 59.08ms │ 61.88ms │ no change │ │ QQuery 4 │ 77.32ms │ 82.71ms │ 1.07x slower │ │ QQuery 5 │ 128.18ms │ 109.04ms │ +1.18x faster │ │ QQuery 6 │ 21.50ms │ 16.55ms │ +1.30x faster │ │ QQuery 7 │ 232.67ms │ 250.17ms │ 1.08x slower │ │ QQuery 8 │ 44.14ms │ 46.56ms │ 1.05x slower │ │ QQuery 9 │ 123.62ms │ 126.51ms │ no change │ │ QQuery 10 │ 116.73ms │ 114.69ms │ no change │ │ QQuery 11 │ 46.64ms │ 76.38ms │ 1.64x slower │ │ QQuery 12 │ 60.57ms │ 61.19ms │ no change │ │ QQuery 13 │ 104.27ms │ 117.77ms │ 1.13x slower │ │ QQuery 14 │ 19.37ms │ 19.86ms │ no change │ │ QQuery 15 │ 31.96ms │ 32.22ms │ no change │ │ QQuery 16 │ 49.26ms │ 47.73ms │ no change │ │ QQuery 17 │ 143.90ms │ 148.92ms │ no change │ │ QQuery 18 │ 575.82ms │ 599.09ms │ no change │ │ QQuery 19 │ 65.20ms │ 66.44ms │ no change │ │ QQuery 20 │ 118.11ms │ 131.08ms │ 1.11x slower │ │ QQuery 21 │ 351.78ms │ 339.24ms │ no change │ │ QQuery 22 │ 39.74ms │ 30.63ms │ +1.30x faster │ └──────────────┴──────────┴──────────┴───────────────┘ ┏━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━┓ ┃ Benchmark Summary ┃ ┃ ┡━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━┩ │ Total Time (2dad904) │ 2740.46ms │ │ Total Time (bdd5905) │ 2812.10ms │ │ Average Time (2dad904) │ 124.57ms │ │ Average Time (bdd5905) │ 127.82ms │ │ Queries Faster │ 3 │ │ Queries Slower │ 6 │ │ Queries with No Change │ 13 │ └────────────────────────┴───────────┘ -------------------- Benchmark tpch_sf1.json -------------------- ┏━━━━━━━━━━━━━━┳━━━━━━━━━━┳━━━━━━━━━━┳━━━━━━━━━━━━━━━┓ ┃ Query ┃ 2dad904 ┃ bdd5905 ┃ Change ┃ ┡━━━━━━━━━━━━━━╇━━━━━━━━━━╇━━━━━━━━━━╇━━━━━━━━━━━━━━━┩ │ QQuery 1 │ 435.28ms │ 433.46ms │ no change │ │ QQuery 2 │ 57.60ms │ 60.11ms │ no change │ │ QQuery 3 │ 145.37ms │ 145.74ms │ no change │ │ QQuery 4 │ 91.09ms │ 90.39ms │ no change │ │ QQuery 5 │ 204.11ms │ 205.20ms │ no change │ │ QQuery 6 │ 108.91ms │ 108.76ms │ no change │ │ QQuery 7 │ 279.90ms │ 300.12ms │ 1.07x slower │ │ QQuery 8 │ 195.70ms │ 202.59ms │ no change │ │ QQuery 9 │ 302.57ms │ 295.42ms │ no change │ │ QQuery 10 │ 234.85ms │ 242.60ms │ no change │ │ QQuery 11 │ 63.57ms │ 41.70ms │ +1.52x faster │ │ QQuery 12 │ 128.23ms │ 126.32ms │ no change │ │ QQuery 13 │ 182.22ms │ 187.13ms │ no change │ │ QQuery 14 │ 128.07ms │ 129.07ms │ no change │ │ QQuery 15 │ 194.21ms │ 197.92ms │ no change │ │ QQuery 16 │ 50.48ms │ 53.30ms │ 1.06x slower │ │ QQuery 17 │ 308.33ms │ 319.43ms │ no change │ │ QQuery 18 │ 459.37ms │ 473.85ms │ no change │ │ QQuery 19 │ 235.09ms │ 232.97ms │ no change │ │ QQuery 20 │ 199.36ms │ 201.44ms │ no change │ │ QQuery 21 │ 335.03ms │ 335.01ms │ no change │ │ QQuery 22 │ 55.36ms │ 44.52ms │ +1.24x faster │ └──────────────┴──────────┴──────────┴───────────────┘ ┏━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━┓ ┃ Benchmark Summary ┃ ┃ ┡━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━┩ │ Total Time (2dad904) │ 4394.71ms │ │ Total Time (bdd5905) │ 4427.03ms │ │ Average Time (2dad904) │ 199.76ms │ │ Average Time (bdd5905) │ 201.23ms │ │ Queries Faster │ 2 │ │ Queries Slower │ 2 │ │ Queries with No Change │ 18 │ └────────────────────────┴───────────┘ -------------------- Benchmark tpch_sf10.json -------------------- ┏━━━━━━━━━━━━━━┳━━━━━━━━━━━┳━━━━━━━━━━━┳━━━━━━━━━━━━━━━┓ ┃ Query ┃ 2dad904 ┃ bdd5905 ┃ Change ┃ ┡━━━━━━━━━━━━━━╇━━━━━━━━━━━╇━━━━━━━━━━━╇━━━━━━━━━━━━━━━┩ │ QQuery 1 │ 4261.78ms │ 4284.23ms │ no change │ │ QQuery 2 │ 494.79ms │ 537.10ms │ 1.09x slower │ │ QQuery 3 │ 1750.07ms │ 1735.21ms │ no change │ │ QQuery 4 │ 838.70ms │ 832.06ms │ no change │ │ QQuery 5 │ 2240.24ms │ 2283.63ms │ no change │ │ QQuery 6 │ 1049.19ms │ 1046.87ms │ no change │ │ QQuery 7 │ 3777.45ms │ 3895.30ms │ no change │ │ QQuery 8 │ 2523.06ms │ 2522.64ms │ no change │ │ QQuery 9 │ 4261.89ms │ 4301.60ms │ no change │ │ QQuery 10 │ 2591.54ms │ 2610.27ms │ no change │ │ QQuery 11 │ 572.57ms │ 349.80ms │ +1.64x faster │ │ QQuery 12 │ 1221.10ms │ 1213.01ms │ no change │ │ QQuery 13 │ 2383.38ms │ 2394.47ms │ no change │ │ QQuery 14 │ 1286.08ms │ 1294.95ms │ no change │ │ QQuery 15 │ 1986.21ms │ 1981.72ms │ no change │ │ QQuery 16 │ 520.46ms │ 529.13ms │ no change │ │ QQuery 17 │ 5259.84ms │ 5349.47ms │ no change │ │ QQuery 18 │ 6952.12ms │ 7205.29ms │ no change │ │ QQuery 19 │ 2252.07ms │ 2239.19ms │ no change │ │ QQuery 20 │ 2642.42ms │ 2671.71ms │ no change │ │ QQuery 21 │ 4695.84ms │ 4525.04ms │ no change │ │ QQuery 22 │ 573.27ms │ 471.46ms │ +1.22x faster │ └──────────────┴───────────┴───────────┴───────────────┘ ┏━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓ ┃ Benchmark Summary ┃ ┃ ┡━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━┩ │ Total Time (2dad904) │ 54134.08ms │ │ Total Time (bdd5905) │ 54274.15ms │ │ Average Time (2dad904) │ 2460.64ms │ │ Average Time (bdd5905) │ 2467.01ms │ │ Queries Faster │ 2 │ │ Queries Slower │ 1 │ │ Queries with No Change │ 19 │ └────────────────────────┴────────────┘ ``` </details> -- 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]
