You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Mryange (via GitHub)" <gi...@apache.org> on 2023/12/01 09:20:00 UTC

[PR] [feature](profile) add avg/min/max info in uint counter [doris]

Mryange opened a new pull request, #27883:
URL: https://github.com/apache/doris/pull/27883

   ## Proposed changes
   
   ```
           HASH_JOIN_OPERATOR  (id=959):
                                   -  BlocksProduced:  sum  96,  avg  3,  max  3,  min  3
                                   -  CloseTime:  avg  11.639us,  max  25.267us,  min  3.434us
                                   -  ExecTime:  avg  357.853us,  max  1.85ms,  min  184.547us
                                   -  OpenTime:  avg  17.981us,  max  33.539us,  min  12.562us
                                   -  ProbeRows:  sum  39.631K  (39631),  avg  1.238K  (1238),  max  1.309K  (1309),  min  1.148K  (1148)
                                   -  ProjectionTime:  avg  87.406us,  max  335.509us,  min  27.120us
                                   -  RowsProduced:  sum  39.631K  (39631),  avg  1.238K  (1238),  max  1.309K  (1309),  min  1.148K  (1148)
   ```
   
   <!--Describe your changes.-->
   
   ## Further comments
   
   If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
   
   


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


Re: [PR] [feature](profile) add avg/min/max info in uint counter [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27883:
URL: https://github.com/apache/doris/pull/27883#issuecomment-1837056903

   PR approved by anyone and no changes requested.


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


Re: [PR] [feature](profile) add avg/min/max info in uint counter [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27883:
URL: https://github.com/apache/doris/pull/27883#issuecomment-1835923353

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 44.81 seconds
    stream load tsv:          570 seconds loaded 74807831229 Bytes, about 125 MB/s
    stream load json:         18 seconds loaded 2358488459 Bytes, about 124 MB/s
    stream load orc:          65 seconds loaded 1101869774 Bytes, about 16 MB/s
    stream load parquet:          32 seconds loaded 861443392 Bytes, about 25 MB/s
    insert into select:          29.0 seconds inserted 10000000 Rows, about 344K ops/s
    storage size: 17163971341 Bytes


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


Re: [PR] [feature](profile) add avg/min/max info in uint counter [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27883:
URL: https://github.com/apache/doris/pull/27883#issuecomment-1836110502

   
   <details>
   <summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
   
   ```
   Tpch sf100 test result on commit fd90b46fbadf3f54fac8d0a4fd9e1f2a3e4d6e6b, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	4944	4654	4631	4631
   q2	352	155	155	155
   q3	1530	1316	1280	1280
   q4	1156	921	944	921
   q5	3236	3269	3242	3242
   q6	252	130	143	130
   q7	1043	539	505	505
   q8	2212	2249	2221	2221
   q9	6952	6951	6920	6920
   q10	3308	3371	3380	3371
   q11	345	202	216	202
   q12	355	209	224	209
   q13	4630	3900	3898	3898
   q14	242	209	207	207
   q15	597	543	534	534
   q16	431	411	404	404
   q17	1036	641	595	595
   q18	7902	7537	7352	7352
   q19	1553	1546	1558	1546
   q20	523	308	324	308
   q21	3438	2926	2947	2926
   q22	377	301	311	301
   Total cold run time: 46414 ms
   Total hot run time: 41858 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	4584	4586	4617	4586
   q2	324	197	231	197
   q3	3748	3725	3738	3725
   q4	2524	2508	2512	2508
   q5	6185	6221	6166	6166
   q6	248	128	129	128
   q7	2578	1991	1945	1945
   q8	3745	3705	3716	3705
   q9	9392	9399	9460	9399
   q10	4071	4146	4160	4146
   q11	656	517	503	503
   q12	806	614	717	614
   q13	4328	3643	3651	3643
   q14	282	240	251	240
   q15	596	530	532	530
   q16	551	489	479	479
   q17	2139	2029	2101	2029
   q18	9620	8946	8970	8946
   q19	1794	1770	1767	1767
   q20	2324	1992	1968	1968
   q21	7324	6985	7130	6985
   q22	665	592	577	577
   Total cold run time: 68484 ms
   Total hot run time: 64786 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


Re: [PR] [feature](profile) add avg/min/max info in uint counter [doris]

Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange commented on PR #27883:
URL: https://github.com/apache/doris/pull/27883#issuecomment-1836162886

   run external


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


Re: [PR] [feature](profile) add avg/min/max info in uint counter [doris]

Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #27883:
URL: https://github.com/apache/doris/pull/27883


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


Re: [PR] [feature](profile) add avg/min/max info in uint counter [doris]

Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange commented on PR #27883:
URL: https://github.com/apache/doris/pull/27883#issuecomment-1835747250

   run buildall


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


Re: [PR] [feature](profile) add avg/min/max info in uint counter [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27883:
URL: https://github.com/apache/doris/pull/27883#issuecomment-1837056900

   PR approved by at least one committer and no changes requested.


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