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

   
   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 148ac0054af1158fda9e105b0643abf0d51dd9b0, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5461    5140    5183    5140
   q2   379     175     176     175
   q3   1464    1134    1201    1134
   q4   1088    794     689     689
   q5   3131    3107    3112    3107
   q6   220     134     132     132
   q7   960     569     513     513
   q8   2149    2306    2211    2211
   q9   6716    6678    6638    6638
   q10  3174    3115    3101    3101
   q11  336     211     208     208
   q12  381     233     233     233
   q13  4387    3651    3631    3631
   q14  250     223     210     210
   q15  577     535     539     535
   q16  455     387     390     387
   q17  1044    525     543     525
   q18  7096    6714    6799    6714
   q19  1637    1493    1608    1493
   q20  547     352     323     323
   q21  2909    2498    2419    2419
   q22  402     320     340     320
   Total cold run time: 44763 ms
   Total hot run time: 39838 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5135    5074    5147    5074
   q2   333     251     250     250
   q3   3374    3332    3311    3311
   q4   2147    2047    2062    2047
   q5   5973    5925    5962    5925
   q6   221     123     127     123
   q7   2421    1931    1921    1921
   q8   3565    3643    3649    3643
   q9   9069    8974    9105    8974
   q10  3853    3937    3904    3904
   q11  598     468     489     468
   q12  817     622     634     622
   q13  3893    3162    3191    3162
   q14  287     287     288     287
   q15  578     540     530     530
   q16  560     532     498     498
   q17  2037    1841    1840    1840
   q18  8742    8342    8341    8341
   q19  1738    1687    1712    1687
   q20  2232    1977    1980    1977
   q21  5783    5331    5470    5331
   q22  569     504     491     491
   Total cold run time: 63925 ms
   Total hot run time: 60406 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