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

   
   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 a42df7d0fa64ab4274585a70eae1f79609e90132, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5471    5150    5157    5150
   q2   388     156     157     156
   q3   1464    1173    1188    1173
   q4   1089    893     783     783
   q5   3109    3162    3070    3070
   q6   226     144     128     128
   q7   1009    569     509     509
   q8   2150    2225    2299    2225
   q9   6677    6666    6640    6640
   q10  3167    3145    3118    3118
   q11  339     223     214     214
   q12  388     233     230     230
   q13  4393    3636    3632    3632
   q14  256     212     221     212
   q15  609     538     539     538
   q16  448     385     401     385
   q17  1037    595     593     593
   q18  7080    6806    6830    6806
   q19  1648    1542    1617    1542
   q20  611     379     328     328
   q21  2876    2395    2463    2395
   q22  400     331     342     331
   Total cold run time: 44835 ms
   Total hot run time: 40158 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5090    5079    5109    5079
   q2   340     252     256     252
   q3   3351    3286    3306    3286
   q4   2123    2024    2029    2024
   q5   5965    5948    5935    5935
   q6   228     126     125     125
   q7   2414    1934    1930    1930
   q8   3559    3652    3663    3652
   q9   9006    9007    8989    8989
   q10  3894    3938    3954    3938
   q11  587     503     479     479
   q12  822     662     645     645
   q13  3903    3221    3153    3153
   q14  317     267     278     267
   q15  614     533     548     533
   q16  577     511     555     511
   q17  2048    1841    1800    1800
   q18  8741    8337    8464    8337
   q19  1737    1671    1656    1656
   q20  2287    1990    1991    1990
   q21  5822    5266    5299    5266
   q22  548     475     521     475
   Total cold run time: 63973 ms
   Total hot run time: 60322 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