pingcap/tidb
Voir sur GitHubcollect the runtime statistics for operators in the coprocessor
Open
#8 433 ouverte le 24 nov. 2018
help wantedsig/executiontype/enhancement
Métriques du dépôt
- Stars
- (40 090 stars)
- Métriques de merge PR
- (Merge moyen 14j 4h) (346 PRs mergées en 30 j)
Description
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