doris-robot commented on PR #29409:
URL: https://github.com/apache/doris/pull/29409#issuecomment-1874897664

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with 
scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
   ```
   Tpch sf100 test result on commit 2dfbd8844328d0b91bf26c53dbb93fb9809c3a0e, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5510    5116    5180    5116
   q2   396     179     155     155
   q3   1486    1178    1282    1178
   q4   1090    881     791     791
   q5   3122    3122    3163    3122
   q6   226     149     136     136
   q7   996     557     517     517
   q8   2158    2274    2231    2231
   q9   6736    6678    6695    6678
   q10  3194    3186    3117    3117
   q11  354     219     219     219
   q12  389     236     242     236
   q13  4384    3641    3653    3641
   q14  250     218     213     213
   q15  606     551     553     551
   q16  452     424     394     394
   q17  1045    577     539     539
   q18  7124    6791    6787    6787
   q19  1653    1490    1463    1463
   q20  596     376     350     350
   q21  2917    2513    2567    2513
   q22  399     321     330     321
   Total cold run time: 45083 ms
   Total hot run time: 40268 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5151    5098    5037    5037
   q2   340     244     239     239
   q3   3375    3352    3301    3301
   q4   2162    2033    2016    2016
   q5   5956    5963    5957    5957
   q6   230     127     133     127
   q7   2438    1999    1954    1954
   q8   3576    3660    3692    3660
   q9   9129    9058    9015    9015
   q10  3869    3940    3912    3912
   q11  587     482     492     482
   q12  830     660     660     660
   q13  3901    3226    3202    3202
   q14  307     282     271     271
   q15  616     559     552     552
   q16  559     511     523     511
   q17  2016    1808    1818    1808
   q18  8832    8421    8342    8342
   q19  1739    1743    1692    1692
   q20  2291    2000    2016    2000
   q21  5866    5376    5403    5376
   q22  564     474     497     474
   Total cold run time: 64334 ms
   Total hot run time: 60588 ms
   ```
   


-- 
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: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to