pingcap/tidb

collect the runtime statistics for operators in the coprocessor

Open

#8,433 建立於 2018年11月24日

在 GitHub 查看
 (1 留言) (0 反應) (0 負責人)Go (6,186 fork)batch import
help wantedsig/executiontype/enhancement

倉庫指標

Star
 (40,090 star)
PR 合併指標
 (平均合併 14天 4小時) (30 天內合併 346 個 PR)

描述

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

貢獻者指南