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

   
   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 37b047590a160ff9f14ecb7536718581f9d621c7, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5490    5124    5128    5124
   q2   383     173     165     165
   q3   1460    1198    1164    1164
   q4   1086    889     810     810
   q5   3122    3160    3180    3160
   q6   216     134     133     133
   q7   977     562     523     523
   q8   2165    2207    2211    2207
   q9   6715    6678    6673    6673
   q10  3179    3193    3149    3149
   q11  346     210     223     210
   q12  380     229     229     229
   q13  4397    3675    3611    3611
   q14  250     219     219     219
   q15  573     537     525     525
   q16  449     416     398     398
   q17  1053    492     490     490
   q18  7133    6688    6809    6688
   q19  1647    1522    1435    1435
   q20  560     325     316     316
   q21  2921    2512    2463    2463
   q22  393     330     320     320
   Total cold run time: 44895 ms
   Total hot run time: 40012 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5105    5076    5105    5076
   q2   347     239     235     235
   q3   3366    3335    3325    3325
   q4   2158    2056    2043    2043
   q5   5948    5913    5913    5913
   q6   222     128     129     128
   q7   2380    1940    1901    1901
   q8   3531    3664    3669    3664
   q9   9042    8996    8963    8963
   q10  3869    3902    3930    3902
   q11  586     479     473     473
   q12  811     635     623     623
   q13  3884    3201    3184    3184
   q14  296     271     270     270
   q15  590     540     524     524
   q16  562     517     502     502
   q17  2017    1822    1794    1794
   q18  8776    8335    8432    8335
   q19  1744    1706    1714    1706
   q20  2262    2002    1959    1959
   q21  5815    5381    5366    5366
   q22  549     497     465     465
   Total cold run time: 63860 ms
   Total hot run time: 60351 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