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

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Tpch sf100 test result on commit 31b942148444f0baa50ae5bce5d1b47ea41fd2d2, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   17716   4692    4624    4624
   q2   2037    138     131     131
   q3   10614   1074    1183    1074
   q4   10217   782     934     782
   q5   7779    2942    3054    2942
   q6   238     126     125     125
   q7   999     494     520     494
   q8   9262    1923    2006    1923
   q9   6687    6631    6607    6607
   q10  8308    3206    3173    3173
   q11  419     205     218     205
   q12  363     211     212     211
   q13  18024   3486    3491    3486
   q14  250     220     215     215
   q15  560     517     512     512
   q16  453     400     399     399
   q17  950     718     560     560
   q18  7323    6655    6629    6629
   q19  1607    1527    1525    1525
   q20  588     323     322     322
   q21  3006    2613    2642    2613
   q22  350     300     304     300
   Total cold run time: 107750 ms
   Total hot run time: 38852 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   4663    4638    4629    4629
   q2   279     167     169     167
   q3   3318    3319    3299    3299
   q4   2186    2188    2191    2188
   q5   5600    5624    5601    5601
   q6   231     116     118     116
   q7   2363    1827    1832    1827
   q8   3419    3429    3428    3428
   q9   9148    9101    9096    9096
   q10  3744    3835    3819    3819
   q11  485     365     370     365
   q12  761     606     594     594
   q13  7993    3161    3218    3161
   q14  288     248     250     248
   q15  570     527     517     517
   q16  486     442     436     436
   q17  1889    1868    1861    1861
   q18  8470    8159    8124    8124
   q19  1649    1657    1652    1652
   q20  2131    1902    1899    1899
   q21  5983    5654    5654    5654
   q22  521     456     472     456
   Total cold run time: 66177 ms
   Total hot run time: 59137 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