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

   
   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 c10c1d1da590c6ddbe25719e54e8ac4368fec265, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5514    5128    5091    5091
   q2   407     167     158     158
   q3   1443    1151    1157    1151
   q4   1074    888     849     849
   q5   3145    3097    3058    3058
   q6   220     140     127     127
   q7   961     524     539     524
   q8   2137    2276    2219    2219
   q9   6651    6657    6626    6626
   q10  3183    3078    3114    3078
   q11  341     225     220     220
   q12  386     236     234     234
   q13  4400    3638    3621    3621
   q14  249     219     209     209
   q15  617     546     550     546
   q16  461     399     395     395
   q17  1039    574     515     515
   q18  7100    6789    6821    6789
   q19  1647    1496    1590    1496
   q20  571     335     330     330
   q21  2881    2440    2476    2440
   q22  379     330     323     323
   Total cold run time: 44806 ms
   Total hot run time: 39999 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5085    5011    5039    5011
   q2   345     248     241     241
   q3   3360    3310    3303    3303
   q4   2147    2017    1980    1980
   q5   5904    5919    5905    5905
   q6   224     124     124     124
   q7   2367    1940    1923    1923
   q8   3541    3663    3670    3663
   q9   9061    9012    8977    8977
   q10  3867    3890    3909    3890
   q11  583     475     493     475
   q12  812     619     651     619
   q13  3843    3203    3176    3176
   q14  320     281     260     260
   q15  601     551     547     547
   q16  556     535     489     489
   q17  2042    1804    1795    1795
   q18  8683    8279    8397    8279
   q19  1731    1602    1690    1602
   q20  2299    1992    1966    1966
   q21  5733    5342    5358    5342
   q22  539     539     510     510
   Total cold run time: 63643 ms
   Total hot run time: 60077 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