improvement of text execution plan

[lilyjazz]

Feature Request

Is your feature request related to a problem? Please describe:

I'm currently using TiDB Dashboard's Slow Query and SQL Statement pages to analyze query performance. However, I find it challenging to interpret the execution plan in its current text format. Additionally, there are issues with exporting statements and displaying long text, affecting user experience.

Describe the feature you'd like:

I would like to request the following enhancements to the TiDB Dashboard's Slow Query and SQL Statement pages:

1. Show the execution plan text in a more readable table format, making it easier for users to understand.

2. Ensure that the execution plan text matches the explain analyze result for consistency in analysis.

3. Make the execution plan text expandable to accommodate longer queries and improve user experience.

4. Support the download of execution plan text for offline analysis.

5. Allow users to customize which execution plan table columns are visible, enhancing flexibility.

6. Implement text truncation for excessively long text to prevent rendering performance issues while still providing essential information.

Describe alternatives you've considered:

As an alternative, users could manually analyze the execution plan text provided by TiDB Dashboard or export it to external tools for a more comprehensive analysis. However, these alternatives are less convenient and may require additional time and effort.

Teachability, Documentation, Adoption, Migration Strategy:

These enhancements would significantly improve the usability and analytical capabilities of TiDB Dashboard's Slow Query and SQL Statement pages. Users would benefit from more accessible and consistent execution plan data, making it easier to identify performance issues and optimize queries. To ensure successful adoption:

• Update the TiDB Dashboard documentation to include instructions on using the new features.
• Provide tooltips or on-screen explanations to guide users through the changes.
• Offer a migration strategy for users accustomed to the previous interface, allowing them to transition smoothly to the improved version.

These enhancements would cater to both novice and experienced users, enhancing the overall user experience and increasing the effectiveness of query performance analysis in TiDB Dashboard.