You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "doris-robot (via GitHub)" <gi...@apache.org> on 2024/06/01 00:14:43 UTC

Re: [PR] [Improvement](coldheat) add statment to show objects which use specific storage policy [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 41640 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 d000df5cc9e8b44b36298c9cfe91a9921b95856c, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17595	4306	4257	4257
   q2	2029	198	204	198
   q3	10434	1242	1210	1210
   q4	10184	811	815	811
   q5	7460	2713	2764	2713
   q6	219	141	151	141
   q7	961	641	643	641
   q8	9245	2139	2104	2104
   q9	9804	6707	6793	6707
   q10	9628	3857	3906	3857
   q11	449	252	249	249
   q12	462	233	270	233
   q13	18457	3212	3095	3095
   q14	275	214	233	214
   q15	520	469	487	469
   q16	520	418	414	414
   q17	972	610	660	610
   q18	8427	7804	7847	7804
   q19	7290	1482	1356	1356
   q20	637	343	327	327
   q21	5253	4108	3895	3895
   q22	381	335	343	335
   Total cold run time: 121202 ms
   Total hot run time: 41640 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4611	4425	4444	4425
   q2	364	281	269	269
   q3	3160	2979	2815	2815
   q4	1934	1585	1638	1585
   q5	5493	5484	5478	5478
   q6	228	131	134	131
   q7	2239	1850	1839	1839
   q8	3214	3363	3412	3363
   q9	8570	8664	8761	8664
   q10	4050	3890	3715	3715
   q11	587	494	486	486
   q12	785	597	637	597
   q13	16236	3118	3152	3118
   q14	309	285	271	271
   q15	534	490	487	487
   q16	495	427	440	427
   q17	1831	1509	1538	1509
   q18	8100	7465	7312	7312
   q19	1742	1467	1650	1467
   q20	2620	1776	1810	1776
   q21	6103	4775	4652	4652
   q22	645	558	539	539
   Total cold run time: 73850 ms
   Total hot run time: 54925 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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org