[Bug]: [main tke regression] tpch 1t test oom.

[Ariznawlll]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

main

Commit ID

d5aef9e

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

job：https://github.com/matrixorigin/mo-nightly-regression/actions/runs/21401546265/job/61616717091

log：https://grafana.ci.matrixorigin.cn/explore?panes=%7B%22qm-%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-main-commit-d5aef9e6b-20260127%5C%22%7D%20%7C%3D%20%60%60%22,%22queryType%22:%22range%22,%22datasource%22:%7B%22type%22:%22loki%22,%22uid%22:%22loki%22%7D,%22editorMode%22:%22builder%22%7D%5D,%22range%22:%7B%22from%22:%221769535027000%22,%22to%22:%221769535130000%22%7D%7D%7D&schemaVersion=1&orgId=1

mem: https://grafana.ci.matrixorigin.cn/explore?panes=%7B%22Rbg%22:%7B%22datasource%22:%22pyroscope%22,%22queries%22:%5B%7B%22groupBy%22:%5B%5D,%22labelSelector%22:%22%7Bnamespace%3D%27mo-main-commit-d5aef9e6b-20260127%27%7D%22,%22queryType%22:%22both%22,%22refId%22:%22A%22,%22profileTypeId%22:%22memory:inuse_space:bytes:space:bytes%22,%22datasource%22:%7B%22type%22:%22grafana-pyroscope-datasource%22,%22uid%22:%22pyroscope%22%7D%7D%5D,%22range%22:%7B%22from%22:%221769535027000%22,%22to%22:%221769535130000%22%7D%7D%7D&schemaVersion=1&orgId=1

Expected Behavior

No response

Steps to Reproduce

trigger tke regression

Additional information

No response

[Ariznawlll]

sysbench insert 也有oom：

metric：https://grafana.ci.matrixorigin.cn/explore?panes=%7B%22Rbg%22:%7B%22datasource%22:%22pyroscope%22,%22queries%22:%5B%7B%22groupBy%22:%5B%5D,%22labelSelector%22:%22%7Bnamespace%3D%27mo-main-commit-d5aef9e6b-20260127%27%7D%22,%22queryType%22:%22both%22,%22refId%22:%22A%22,%22profileTypeId%22:%22memory:inuse_space:bytes:space:bytes%22,%22datasource%22:%7B%22type%22:%22grafana-pyroscope-datasource%22,%22uid%22:%22pyroscope%22%7D%7D%5D,%22range%22:%7B%22from%22:%221769551924000%22,%22to%22:%221769552224000%22%7D%7D%7D&schemaVersion=1&orgId=1

log：https://grafana.ci.matrixorigin.cn/explore?panes=%7B%22REB%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-main-commit-d5aef9e6b-20260127%5C%22%7D%20%7C%3D%20%60%60%22,%22queryType%22:%22range%22,%22datasource%22:%7B%22type%22:%22loki%22,%22uid%22:%22loki%22%7D,%22editorMode%22:%22builder%22%7D%5D,%22range%22:%7B%22from%22:%221769551924000%22,%22to%22:%221769552224000%22%7D%7D%7D&schemaVersion=1&orgId=1

[aptend]

经过采样后的 stats，plan 异常，在 q10 中会将 lineitem 选做 build，内存消耗非常大

+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| AP QUERY PLAN ON MULTICN(64 core)                                                                                                                                        |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
......                                                                                                      |
|                     ->  Join                                                                                                                                             |
|                           Join Type: INNER                                                                                                                               |
|                           Join Cond: (orders.o_orderkey = lineitem.l_orderkey) shuffle: range(orders.o_orderkey)                                                         |
|                           ->  Table Scan on tpch_1000g.orders                                                                                                            |
|                                 Filter Cond: (orders.o_orderdate < 1993-06-01), (orders.o_orderdate >= 1993-03-01)                                                       |
|                           ->  Table Scan on tpch_1000g.lineitem                                                                                                          |
|                                 Filter Cond: (lineitem.l_returnflag = 'R')                                                                                               |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
22 rows in set (0.06 sec)

[Ariznawlll]

二分结果