Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Plan in statement summary tables is lack of tikv/tiflash info #17278

Closed
djshow832 opened this issue May 19, 2020 · 1 comment · Fixed by #17825
Closed

Plan in statement summary tables is lack of tikv/tiflash info #17278

djshow832 opened this issue May 19, 2020 · 1 comment · Fixed by #17825
Labels
help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. severity/moderate sig/planner SIG: Planner type/bug The issue is confirmed as a bug.

Comments

@djshow832
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

mysql> explain select * from t;
+-----------------------+----------+-----------+---------------+--------------------------------+
| id                    | estRows  | task      | access object | operator info                  |
+-----------------------+----------+-----------+---------------+--------------------------------+
| TableReader_5         | 10000.00 | root      |               | data:TableFullScan_4           |
| └─TableFullScan_4     | 10000.00 | cop[tikv] | table:t       | keep order:false, stats:pseudo |
+-----------------------+----------+-----------+---------------+--------------------------------+
2 rows in set (0.01 sec)

mysql> select * from t;
Empty set (0.00 sec)

mysql> select plan from information_schema.statements_summary where digest_text='select * from t';
+----------------------------------------------------------------------------------------------------------------------+
| plan                                                                                                                 |
+----------------------------------------------------------------------------------------------------------------------+
| 	TableReader_5	root	10000	data:TableFullScan_4
	└─TableScan_4	cop 	10000	table:t, keep order:false, stats:pseudo     |
+----------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

2. What did you expect to see? (Required)

Plan in information_schema.statements_summary should be the same with explain, which contains tikv/tiflash info.

3. Affected version (Required)

v4.0.0

4. Root Cause Analysis

@djshow832 djshow832 added the type/bug The issue is confirmed as a bug. label May 19, 2020
@djshow832 djshow832 removed their assignment May 21, 2020
@djshow832 djshow832 added difficulty/easy help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. labels May 21, 2020
@XuHuaiyu XuHuaiyu added the sig/planner SIG: Planner label May 21, 2020
@pingyu
Copy link
Contributor

pingyu commented Jun 6, 2020

Let me fix it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. severity/moderate sig/planner SIG: Planner type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants