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

   
   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 a2c8ace9a3f42b1ed78e33c05ca79f8907acb252, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5498    5180    5199    5180
   q2   385     158     159     158
   q3   1462    1214    1107    1107
   q4   1090    800     784     784
   q5   3084    3005    3049    3005
   q6   217     132     132     132
   q7   980     517     562     517
   q8   2163    2287    2220    2220
   q9   6681    6635    6673    6635
   q10  3174    3095    3084    3084
   q11  352     228     219     219
   q12  383     239     234     234
   q13  4379    3613    3637    3613
   q14  256     229     218     218
   q15  577     542     521     521
   q16  438     400     396     396
   q17  1044    551     563     551
   q18  7064    6734    6808    6734
   q19  1659    1549    1567    1549
   q20  595     318     344     318
   q21  2857    2402    2488    2402
   q22  402     338     333     333
   Total cold run time: 44740 ms
   Total hot run time: 39910 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5143    5074    5077    5074
   q2   336     229     242     229
   q3   3360    3343    3308    3308
   q4   2161    2034    2048    2034
   q5   5952    5933    5922    5922
   q6   221     123     123     123
   q7   2388    1911    1946    1911
   q8   3529    3659    3658    3658
   q9   9070    8998    8926    8926
   q10  3865    3886    3900    3886
   q11  577     461     493     461
   q12  806     630     657     630
   q13  3842    3166    3219    3166
   q14  301     278     273     273
   q15  587     530     520     520
   q16  556     505     511     505
   q17  2082    1844    1806    1806
   q18  8781    8312    8296    8296
   q19  1753    1710    1700    1700
   q20  2268    1978    1954    1954
   q21  5818    5366    5358    5358
   q22  566     491     500     491
   Total cold run time: 63962 ms
   Total hot run time: 60231 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