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

   
   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 2dcbd7fff8e38ff2df192d7ed044db7ab574ad01, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5494    5126    5149    5126
   q2   403     161     146     146
   q3   1438    1237    1092    1092
   q4   1106    854     782     782
   q5   3156    3109    3129    3109
   q6   227     132     130     130
   q7   986     555     514     514
   q8   2143    2273    2229    2229
   q9   6697    6689    6602    6602
   q10  3143    3142    3160    3142
   q11  344     216     216     216
   q12  375     237     246     237
   q13  4411    3652    3648    3648
   q14  260     213     210     210
   q15  599     551     542     542
   q16  454     387     406     387
   q17  1041    526     529     526
   q18  7079    6732    6911    6732
   q19  1646    1491    1457    1457
   q20  602     330     332     330
   q21  2885    2495    2493    2493
   q22  394     315     334     315
   Total cold run time: 44883 ms
   Total hot run time: 39965 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5132    5104    5085    5085
   q2   335     257     262     257
   q3   3367    3311    3309    3309
   q4   2156    2027    2028    2027
   q5   5955    5929    5907    5907
   q6   227     125     125     125
   q7   2381    1888    1934    1888
   q8   3541    3644    3673    3644
   q9   9035    9048    8942    8942
   q10  3859    3905    3878    3878
   q11  578     488     476     476
   q12  807     634     626     626
   q13  3884    3229    3172    3172
   q14  306     281     271     271
   q15  612     540     545     540
   q16  552     497     490     490
   q17  2064    1824    1807    1807
   q18  8734    8300    8349    8300
   q19  1742    1697    1693    1693
   q20  2252    1981    1992    1981
   q21  5766    5344    5316    5316
   q22  553     477     491     477
   Total cold run time: 63838 ms
   Total hot run time: 60211 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