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