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/03/05 02:55:19 UTC
Re: [PR] [refactor](profile)Refactor active_queries() schema [doris]
doris-robot commented on PR #31742:
URL: https://github.com/apache/doris/pull/31742#issuecomment-1977859420
<details>
<summary>TPC-H: <b>Total hot run time: 38013 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 aebc87c9f7dc7839a0157a2ce49ab8bdf4268491, data reload: false
------ Round 1 ----------------------------------
q1 17630 4032 4032 4032
q2 2017 152 143 143
q3 10561 986 935 935
q4 4659 943 944 943
q5 7603 2947 3023 2947
q6 180 124 126 124
q7 1335 841 812 812
q8 9492 2098 2058 2058
q9 7266 6411 6417 6411
q10 8227 2559 2582 2559
q11 419 215 217 215
q12 742 315 313 313
q13 17974 2948 2917 2917
q14 288 245 257 245
q15 481 448 443 443
q16 469 408 394 394
q17 944 899 878 878
q18 6743 5926 5918 5918
q19 1586 1523 1505 1505
q20 564 281 295 281
q21 7546 3668 3648 3648
q22 791 299 292 292
Total cold run time: 107517 ms
Total hot run time: 38013 ms
----- Round 2, with runtime_filter_mode=off -----
q1 3971 3966 3968 3966
q2 318 231 229 229
q3 2944 2887 2921 2887
q4 1831 1839 1810 1810
q5 5231 5244 5217 5217
q6 201 123 118 118
q7 2257 1825 1830 1825
q8 3235 3256 3303 3256
q9 8474 8528 8483 8483
q10 6126 3770 3694 3694
q11 518 422 425 422
q12 684 574 528 528
q13 11124 2863 2738 2738
q14 274 246 247 246
q15 474 438 441 438
q16 454 392 406 392
q17 1691 1647 1667 1647
q18 7912 7408 7387 7387
q19 5105 1631 1608 1608
q20 1948 1763 1695 1695
q21 4971 4765 4792 4765
q22 470 399 469 399
Total cold run time: 70213 ms
Total hot run time: 53750 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