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

   
   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 ccd8824ba3dd2e4e6967dde6a686a0c815370c24, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5502    5054    5107    5054
   q2   389     168     157     157
   q3   1432    1162    1169    1162
   q4   1089    803     822     803
   q5   3111    3089    3103    3089
   q6   227     136     129     129
   q7   980     542     540     540
   q8   2137    2158    2273    2158
   q9   6656    6670    6627    6627
   q10  3161    3163    3177    3163
   q11  347     223     226     223
   q12  379     240     232     232
   q13  4385    3648    3664    3648
   q14  244     225     204     204
   q15  612     557     535     535
   q16  468     415     413     413
   q17  1031    541     476     476
   q18  7067    6676    6830    6676
   q19  1632    1500    1599    1500
   q20  571     332     332     332
   q21  2843    2388    2448    2388
   q22  398     334     331     331
   Total cold run time: 44661 ms
   Total hot run time: 39840 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5144    5119    5106    5106
   q2   336     252     235     235
   q3   3368    3308    3293    3293
   q4   2136    2021    2022    2021
   q5   5923    5911    5906    5906
   q6   225     125     121     121
   q7   2346    1883    1913    1883
   q8   3545    3639    3679    3639
   q9   9046    8975    8975    8975
   q10  3860    3882    3929    3882
   q11  581     467     487     467
   q12  818     669     657     657
   q13  3912    3204    3221    3204
   q14  300     280     271     271
   q15  610     546     542     542
   q16  556     535     498     498
   q17  2033    1810    1803    1803
   q18  8798    8289    8357    8289
   q19  1726    1692    1725    1692
   q20  2295    2000    2001    2000
   q21  5801    5406    5334    5334
   q22  557     498     480     480
   Total cold run time: 63916 ms
   Total hot run time: 60298 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