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

   
   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 16fb1336669b736e20165d718a099d9e50f38e79, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5485    5184    5156    5156
   q2   382     172     155     155
   q3   1462    1205    1244    1205
   q4   1095    880     777     777
   q5   3152    3031    3175    3031
   q6   222     130     131     130
   q7   978     554     516     516
   q8   2159    2217    2293    2217
   q9   6697    6758    6643    6643
   q10  3198    3172    3097    3097
   q11  346     237     226     226
   q12  377     224     227     224
   q13  4372    3636    3648    3636
   q14  254     210     209     209
   q15  584     541     522     522
   q16  471     402     390     390
   q17  1051    563     553     553
   q18  7042    6752    6780    6752
   q19  1655    1546    1397    1397
   q20  583     354     368     354
   q21  2867    2443    2512    2443
   q22  403     316     336     316
   Total cold run time: 44835 ms
   Total hot run time: 39949 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5091    5063    5120    5063
   q2   336     239     227     227
   q3   3356    3334    3331    3331
   q4   2155    2061    2057    2057
   q5   5944    5903    5953    5903
   q6   224     125     127     125
   q7   2388    1939    1913    1913
   q8   3557    3671    3666    3666
   q9   9062    8978    9044    8978
   q10  3862    3905    3926    3905
   q11  567     482     482     482
   q12  792     621     634     621
   q13  3875    3239    3191    3191
   q14  300     268     285     268
   q15  582     527     520     520
   q16  553     516     527     516
   q17  2021    1843    1822    1822
   q18  8743    8301    8318    8301
   q19  1746    1692    1704    1692
   q20  2252    1985    1993    1985
   q21  5694    5355    5299    5299
   q22  543     489     475     475
   Total cold run time: 63643 ms
   Total hot run time: 60340 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: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to