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

   
   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 6d72649bbcd9f717ebabb11decc286ab4b0c883a, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5442    5173    5174    5173
   q2   391     193     168     168
   q3   1486    1251    1194    1194
   q4   1105    914     822     822
   q5   3170    3130    3070    3070
   q6   230     141     137     137
   q7   1008    560     525     525
   q8   2160    2300    2248    2248
   q9   6707    6652    6645    6645
   q10  3188    3131    3146    3131
   q11  365     225     232     225
   q12  395     243     244     243
   q13  4404    3652    3657    3652
   q14  264     221     226     221
   q15  632     589     565     565
   q16  460     427     421     421
   q17  1047    597     542     542
   q18  7107    6766    6806    6766
   q19  1660    1532    1597    1532
   q20  749     382     341     341
   q21  2913    2494    2476    2476
   q22  386     343     342     342
   Total cold run time: 45269 ms
   Total hot run time: 40439 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5144    5112    5090    5090
   q2   340     249     243     243
   q3   3376    3330    3287    3287
   q4   2139    2018    2015    2015
   q5   5945    5932    5879    5879
   q6   234     133     135     133
   q7   2401    1943    1928    1928
   q8   3571    3646    3649    3646
   q9   9048    9044    9039    9039
   q10  3868    3929    3937    3929
   q11  584     500     505     500
   q12  822     640     653     640
   q13  3869    3189    3183    3183
   q14  306     277     285     277
   q15  641     579     560     560
   q16  583     519     498     498
   q17  2035    1784    1798    1784
   q18  8855    8389    8392    8389
   q19  1741    1727    1740    1727
   q20  2286    1988    1977    1977
   q21  5681    5377    5435    5377
   q22  572     463     514     463
   Total cold run time: 64041 ms
   Total hot run time: 60564 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to