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

   
   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 af7af0a3c0e87332313baeb8be41f35370df8f97, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5573    5193    5138    5138
   q2   391     173     158     158
   q3   1464    1178    1153    1153
   q4   1108    831     842     831
   q5   3109    3066    3114    3066
   q6   228     136     137     136
   q7   1016    566     526     526
   q8   2159    2272    2225    2225
   q9   6690    6651    6665    6651
   q10  3181    3161    3203    3161
   q11  331     223     217     217
   q12  377     239     241     239
   q13  4398    3696    3676    3676
   q14  249     210     222     210
   q15  603     547     555     547
   q16  455     392     416     392
   q17  1043    490     542     490
   q18  7091    6794    6719    6719
   q19  1647    1538    1491    1491
   q20  563     363     385     363
   q21  2918    2410    2430    2410
   q22  412     322     344     322
   Total cold run time: 45006 ms
   Total hot run time: 40121 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5134    5135    5125    5125
   q2   338     256     262     256
   q3   3388    3311    3286    3286
   q4   2162    2053    2050    2050
   q5   5960    5937    5922    5922
   q6   227     124     130     124
   q7   2357    1889    1935    1889
   q8   3584    3660    3695    3660
   q9   9140    9042    9002    9002
   q10  3882    3922    3908    3908
   q11  581     469     491     469
   q12  803     698     666     666
   q13  3900    3219    3194    3194
   q14  296     281     272     272
   q15  592     540     549     540
   q16  544     539     506     506
   q17  2046    1797    1845    1797
   q18  8738    8324    8335    8324
   q19  1748    1671    1675    1671
   q20  2294    1997    1991    1991
   q21  5722    5335    5295    5295
   q22  591     528     513     513
   Total cold run time: 64027 ms
   Total hot run time: 60460 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