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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 33837 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit c072b09b56f0fd649cdfaac0f1faa190b2fef4f3, 
data reload: false
   
   ------ Round 1 ----------------------------------
   q1   26243   5053    4987    4987
   q2   2081    279     181     181
   q3   10542   1273    699     699
   q4   10226   1004    521     521
   q5   7749    2419    2338    2338
   q6   181     160     130     130
   q7   923     746     616     616
   q8   9319    1280    1077    1077
   q9   6844    5118    5087    5087
   q10  6869    2334    1893    1893
   q11  496     286     271     271
   q12  347     351     220     220
   q13  17800   3647    3075    3075
   q14  242     221     216     216
   q15  545     479     496     479
   q16  430     438     375     375
   q17  615     855     382     382
   q18  7788    7259    7143    7143
   q19  1707    984     581     581
   q20  332     340     234     234
   q21  3724    3233    2396    2396
   q22  996     1001    936     936
   Total cold run time: 115999 ms
   Total hot run time: 33837 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   ============================================
   show table status;
   Name Engine  Version Row_format      Rows    Avg_row_length  Data_length     
Max_data_length Index_length    Data_free       Auto_increment  Create_time     
Update_time     Check_time      Collation       Checksum        Create_options  
Comment
   revenue0     View    NULL    NULL    -1      0       0       NULL    0       
NULL    NULL    2023-12-26 18:27:24     NULL    NULL    utf-8   NULL    NULL    
   partsupp     Doris   NULL    NULL    80000000        56      4534120086      
NULL    44625495        NULL    NULL    2023-12-26 18:27:23     2023-12-26 
18:44:20     NULL    utf-8   NULL    NULL    
   part Doris   NULL    NULL    20000000        37      748811035       NULL    
1935627 NULL    NULL    2023-12-26 18:27:23     2023-12-26 18:27:57     NULL    
utf-8   NULL    NULL    
   nation       Doris   NULL    NULL    25      138     3473    NULL    366     
NULL    NULL    2023-12-26 18:27:23     2023-12-26 18:27:24     NULL    utf-8   
NULL    NULL    
   customer     Doris   NULL    NULL    15000000        92      1381653732      
NULL    4374759 NULL    NULL    2023-12-26 18:27:23     2023-12-26 18:27:43     
NULL    utf-8   NULL    NULL    
   lineitem     Doris   NULL    NULL    600037902       33      19843441616     
NULL    61784740        NULL    NULL    2023-12-26 18:27:23     2023-12-26 
18:38:59     NULL    utf-8   NULL    NULL    
   supplier     Doris   NULL    NULL    1000000 87      87519212        NULL    
194931  NULL    NULL    2023-12-26 18:27:23     2023-12-26 18:27:25     NULL    
utf-8   NULL    NULL    
   region       Doris   NULL    NULL    5       240     1201    NULL    147     
NULL    NULL    2023-12-26 18:27:23     2023-12-26 18:27:24     NULL    utf-8   
NULL    NULL    
   orders       Doris   NULL    NULL    150000000       42      6422171781      
NULL    22778155        NULL    NULL    2023-12-26 18:27:23     2023-12-26 
18:42:55     NULL    utf-8   NULL    NULL    
   ============================================
   q1   5171    5095    5095    5095
   q2   243     331     229     229
   q3   2134    2682    2304    2304
   q4   1349    1765    1335    1335
   q5   4596    4427    4387    4387
   q6   214     166     127     127
   q7   2025    1977    1740    1740
   q8   2589    2526    2517    2517
   q9   7202    7186    7067    7067
   q10  3001    3230    q11     q12     q13     q14     q15     q16     q17     
q18     q19     q20     q21     q22     Total cold run time: 25523 ms
   Total hot run time: 24801 ms
   ```
   </details>
   


-- 
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