foxtail463 commented on PR #61345:
URL: https://github.com/apache/doris/pull/61345#issuecomment-4234891403
benchmark for hot path:
simple:
view: select id, score from T1 where id = 5 or id > 10;
query: select id, score from T1 where id > 10 or (score = 1 and id = 5);
medium:
view: select id, score from T1 where id = 5 or id > 10 or score = 7;
query: select id, score from T1 where (id > 10 and score > 0) or (score = 7
and id = 5);
near overflow guard:
view: select id, score from T1 where
(id = 1 or score = 101) and (id = 2 or score = 102)
and (id = 3 or score = 103) and (id = 4 or score = 104)
and (id = 5 or score = 105) and (id = 6 or score = 106)
and (id = 7 or score = 107) and (id = 8 or score = 108)
and (id = 9 or score = 109) and (id = 10 or score = 110)
and (id = 11 or score = 111);
query: select id, score from T1 where
(id = 1 or score = 101) and (id = 2 or score = 102)
and (id = 3 or score = 103) and (id = 4 or score = 104)
and (id = 5 or score = 105) and (id = 6 or score = 106)
and (id = 7 or score = 107) and (id = 8 or score = 108)
and (id = 9 or score = 109) and (id = 10 or score = 110)
and (id = 11 or score = 111);
<h1 data-line="0" class="code-line" dir="auto"
id="predicate-compensation-热路径测试报告" style="margin-top: 0px; font-weight: 600;
margin-bottom: 16px; line-height: 1.25; font-size: 2em; padding-bottom: 0.3em;
border-bottom: 1px solid rgb(0, 0, 0); border-top-color: rgb(0, 0, 0);
border-right-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); position:
relative; color: rgb(255, 255, 255); font-family: -apple-system,
"system-ui", "Segoe WPC", "Segoe UI", system-ui,
Ubuntu, "Droid Sans", sans-serif; font-style: normal;
font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing:
normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none;
widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space:
normal; text-decoration-thickness: initial; text-decoration-style: initial;
text-decoration-color: initial;">Predicate Compensation 热路径测试报告</h1><h2
data-line="2" class="code-line
" dir="auto" id="测试结果" style="margin-top: 24px; font-weight: 600;
margin-bottom: 16px; line-height: 1.25; font-size: 1.5em; padding-bottom:
0.3em; border-bottom-width: 1px; border-bottom-style: solid; position:
relative; color: rgb(255, 255, 255); font-family: -apple-system,
"system-ui", "Segoe WPC", "Segoe UI", system-ui,
Ubuntu, "Droid Sans", sans-serif; font-style: normal;
font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing:
normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none;
widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space:
normal; text-decoration-thickness: initial; text-decoration-style: initial;
text-decoration-color: initial;">测试结果</h2><p data-line="3" class="code-line"
dir="auto" style="margin-top: 0px; margin-bottom: 16px; position: relative;
color: rgb(255, 255, 255); font-family: -apple-system, "system-ui",
"Segoe WPC", &qu
ot;Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif;
font-size: 14px; font-style: normal; font-variant-ligatures: normal;
font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans:
2; text-align: start; text-indent: 0px; text-transform: none; widows: 2;
word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal;
text-decoration-thickness: initial; text-decoration-style: initial;
text-decoration-color: initial;">单位：<code style="font-family: Menlo, Monaco,
"Courier New", monospace; color: rgb(255, 255, 255);
background-color: rgba(0, 0, 0, 0); padding: 1px 3px; border-radius: 4px;
font-size: 1em; line-height: 1.357em;">us/op</code></p>
Case | 热路径 median (min / max) | FE plan median (min / max) | 热路径占 FE plan
-- | -- | -- | --
simple_dnf_implication | 11.070 (7.529 / 18.799) | 7496.954 (5326.716 /
10047.357) | 0.15%
medium_dnf_implication | 7.711 (7.559 / 8.687) | 5751.264 (4174.986 /
7068.649) | 0.13%
near_overflow_guard | 900.150 (828.480 / 1372.486) | 5392.075 (5347.865 /
5756.847) | 16.69%
<ul data-line="11" class="code-line" dir="auto" style="margin-top: 0px;
margin-bottom: 0.7em; position: relative; color: rgb(255, 255, 255);
font-family: -apple-system, "system-ui", "Segoe WPC",
"Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif;
font-size: 14px; font-style: normal; font-variant-ligatures: normal;
font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans:
2; text-align: start; text-indent: 0px; text-transform: none; widows: 2;
word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal;
text-decoration-thickness: initial; text-decoration-style: initial;
text-decoration-color: initial;"><li data-line="11" class="code-line"
dir="auto" style="position: relative;"><code style="font-family: Menlo, Monaco,
"Courier New", monospace; color: rgb(255, 255, 255);
background-color: rgba(0, 0, 0, 0); padding: 1px 3px; border-radius: 4px;
font-size: 1em; line-height: 1.357em;">benchmark_blackho
le = 48960</code></li></ul><h2 data-line="13" class="code-line
code-active-line" dir="auto" id="机器规格" style="margin-top: 24px; font-weight:
600; margin-bottom: 16px; line-height: 1.25; font-size: 1.5em; padding-bottom:
0.3em; border-bottom-width: 1px; border-bottom-style: solid; position:
relative; color: rgb(255, 255, 255); font-family: -apple-system,
"system-ui", "Segoe WPC", "Segoe UI", system-ui,
Ubuntu, "Droid Sans", sans-serif; font-style: normal;
font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing:
normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none;
widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space:
normal; text-decoration-thickness: initial; text-decoration-style: initial;
text-decoration-color: initial;">机器规格</h2><ul data-line="15" class="code-line"
dir="auto" style="margin-top: 0px; margin-bottom: 0.7em; position: relative;
color: rgb(255, 255, 2
55); font-family: -apple-system, "system-ui", "Segoe WPC",
"Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif;
font-size: 14px; font-style: normal; font-variant-ligatures: normal;
font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans:
2; text-align: start; text-indent: 0px; text-transform: none; widows: 2;
word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal;
text-decoration-thickness: initial; text-decoration-style: initial;
text-decoration-color: initial;"><li data-line="15" class="code-line"
dir="auto" style="position: relative;">OS：<code style="font-family: Menlo,
Monaco, "Courier New", monospace; color: rgb(255, 255, 255);
background-color: rgba(0, 0, 0, 0); padding: 1px 3px; border-radius: 4px;
font-size: 1em; line-height: 1.357em;">Linux 5.4.0-216-generic #236-Ubuntu SMP
Fri Apr 11 19:53:21 UTC 2025 x86_64 GNU/Linux</code></li><li data-line="16"
class="code-line" dir="auto" style
="position: relative;">CPU：<code style="font-family: Menlo, Monaco,
"Courier New", monospace; color: rgb(255, 255, 255);
background-color: rgba(0, 0, 0, 0); padding: 1px 3px; border-radius: 4px;
font-size: 1em; line-height: 1.357em;">2 x Intel Xeon Gold 6267C @
2.60GHz</code></li><li data-line="17" class="code-line" dir="auto"
style="position: relative;">拓扑：<code style="font-family: Menlo, Monaco,
"Courier New", monospace; color: rgb(255, 255, 255);
background-color: rgba(0, 0, 0, 0); padding: 1px 3px; border-radius: 4px;
font-size: 1em; line-height: 1.357em;">96</code><span> </span>逻辑核，<code
style="font-family: Menlo, Monaco, "Courier New", monospace; color:
rgb(255, 255, 255); background-color: rgba(0, 0, 0, 0); padding: 1px 3px;
border-radius: 4px; font-size: 1em; line-height: 1.357em;">2</code><span>
</span>路，单路<span> </span><code style="font-family: Menlo, Monaco, "Courier
New", monospace; color: rgb(255, 255, 2
55); background-color: rgba(0, 0, 0, 0); padding: 1px 3px; border-radius: 4px;
font-size: 1em; line-height: 1.357em;">24</code><span> </span>核，<code
style="font-family: Menlo, Monaco, "Courier New", monospace; color:
rgb(255, 255, 255); background-color: rgba(0, 0, 0, 0); padding: 1px 3px;
border-radius: 4px; font-size: 1em; line-height: 1.357em;">2</code><span>
</span>线程每核，<code style="font-family: Menlo, Monaco, "Courier New",
monospace; color: rgb(255, 255, 255); background-color: rgba(0, 0, 0, 0);
padding: 1px 3px; border-radius: 4px; font-size: 1em; line-height:
1.357em;">2</code><span> </span>个 NUMA 节点</li><li data-line="18"
class="code-line" dir="auto" style="position: relative;">内存：约<span>
</span><code style="font-family: Menlo, Monaco, "Courier New",
monospace; color: rgb(255, 255, 255); background-color: rgba(0, 0, 0, 0);
padding: 1px 3px; border-radius: 4px; font-size: 1em; line-height:
1.357em;">191 GiB</code>
</li></ul>
--
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]
