collect the runtime statistics for operators in the coprocessor · pingcap/tidb#8433

(1 评论) (0 反应) (0 负责人)Go (40,090 star) (6,186 fork)batch import

help wantedsig/executiontype/enhancement

描述

Feature Request

Describe the feature you'd like:

At present, TiDB has supported the explain analyze statement to show the runtime statistics about the query execution, for example:

TiDB(root@127.0.0.1:test) > explain analyze select sum(b) from t group by a;
+----------------------+----------+------+--------------------------------------------------------------------+----------------------------------+
| id                   | count    | task | operator info                                                      | execution info                   |
+----------------------+----------+------+--------------------------------------------------------------------+----------------------------------+
| StreamAgg_9          | 8000.00  | root | group by:group_0, funcs:sum(sum_0)                                 | time:399.086µs, loops:4, rows:3  |
| └─IndexLookUp_20     | 10000.00 | root |                                                                    | time:382.873µs, loops:4, rows:3  |
|   ├─IndexScan_18     | 10000.00 | cop  | table:t, index:a, range:[NULL,+inf], keep order:true, stats:pseudo |                                  |
|   └─TableScan_19     | 10000.00 | cop  | table:t, keep order:false, stats:pseudo                            |                                  |
+----------------------+----------+------+--------------------------------------------------------------------+----------------------------------+
4 rows in set (0.00 sec)

It would be more useful if we can show the runtime statistics of the operators implemented and executed in the TiKV coprocessor.

Describe alternatives you've considered: No

Teachability, Documentation, Adoption, Migration Strategy: No

贡献者指南

技术栈: go
领域: databasebackend
议题类型: feature
难度: 4
预计时间: 1-2 days
活动状态: stale
清晰度: mostly clear
前置要求: Go programmingDistributed systems knowledgeTiDB/TiKV architecture
新手友好度: 15
研究方向: The issue requests adding runtime statistics collection for operators in the TiKV coprocessor. To implement this, one should first understand the current explain analyze implementation in TiDB (e.g., files in executor/ or planner/), and the coprocessor execution framework in TiKV (likely in src/coprocessor/). Existing discussions in the issue may provide direction. The goal is to propagate execution metrics from TiKV's operations back to TiDB for display.