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

   
   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 70559108d00cbbc908ca48d53b6019c6d83db45c, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5456    5139    5126    5126
   q2   393     186     168     168
   q3   1478    1201    1179    1179
   q4   1103    821     749     749
   q5   3172    3180    3109    3109
   q6   232     139     140     139
   q7   989     592     532     532
   q8   2165    2282    2230    2230
   q9   6717    6685    6677    6677
   q10  3203    3154    3129    3129
   q11  354     237     233     233
   q12  395     247     248     247
   q13  4455    3682    3668    3668
   q14  264     226     232     226
   q15  643     580     559     559
   q16  459     409     425     409
   q17  1043    589     533     533
   q18  7132    6823    6857    6823
   q19  1646    1559    1494    1494
   q20  626     360     378     360
   q21  2881    2473    2544    2473
   q22  405     332     336     332
   Total cold run time: 45211 ms
   Total hot run time: 40395 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5153    5142    5114    5114
   q2   336     257     235     235
   q3   3399    3341    3327    3327
   q4   2163    2033    2052    2033
   q5   6006    5942    5936    5936
   q6   239     139     135     135
   q7   2420    1951    1942    1942
   q8   3567    3684    3689    3684
   q9   9094    9039    9026    9026
   q10  3886    3907    3948    3907
   q11  597     486     496     486
   q12  829     652     632     632
   q13  3882    3225    3203    3203
   q14  296     276     290     276
   q15  636     562     577     562
   q16  546     546     527     527
   q17  2063    1835    1830    1830
   q18  8874    8375    8426    8375
   q19  1752    1698    1687    1687
   q20  2309    2000    2017    2000
   q21  5763    5475    5494    5475
   q22  586     513     502     502
   Total cold run time: 64396 ms
   Total hot run time: 60894 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