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

   
   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 bd2c3b87ac9d92bd9b7ee2651c33c3f9e1014857, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5438    5181    5105    5105
   q2   384     181     158     158
   q3   1467    1264    1147    1147
   q4   1089    886     816     816
   q5   3126    3116    3124    3116
   q6   226     138     137     137
   q7   996     565     518     518
   q8   2149    2180    2190    2180
   q9   6707    6667    6674    6667
   q10  3178    3159    3106    3106
   q11  354     232     229     229
   q12  390     234     243     234
   q13  4399    3712    3668    3668
   q14  251     220     208     208
   q15  614     563     547     547
   q16  449     398     393     393
   q17  1048    564     481     481
   q18  7075    6742    6820    6742
   q19  1633    1522    1433    1433
   q20  564     493     351     351
   q21  2893    2511    2505    2505
   q22  386     329     327     327
   Total cold run time: 44816 ms
   Total hot run time: 40068 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5170    5067    5011    5011
   q2   333     248     252     248
   q3   3391    3321    3303    3303
   q4   2119    1968    1955    1955
   q5   5977    5920    5906    5906
   q6   227     128     129     128
   q7   2375    1912    1895    1895
   q8   3573    3647    3672    3647
   q9   9056    9030    8988    8988
   q10  3857    3920    3902    3902
   q11  593     494     481     481
   q12  791     633     636     633
   q13  3878    3232    3238    3232
   q14  306     278     271     271
   q15  622     552     546     546
   q16  562     499     522     499
   q17  2037    1867    1811    1811
   q18  8745    8463    8392    8392
   q19  1739    1695    1734    1695
   q20  2265    2000    1990    1990
   q21  5773    5428    5365    5365
   q22  546     484     490     484
   Total cold run time: 63935 ms
   Total hot run time: 60382 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: [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]

Reply via email to