- About TiDB Cloud
- Get Started
- Manage Cluster
- Plan Your Cluster
- Create a TiDB Cluster
- Connect to Your TiDB Cluster
- Set Up VPC Peering Connections
- Use an HTAP Cluster
- Scale a TiDB Cluster
- Tune Performance
- Upgrade a TiDB Cluster
- Delete a TiDB Cluster
- Manage Data
- Import Sample Data
- Migrate Data into TiDB
- Back Up and Restore Data
- Export Data from TiDB
- Monitor Cluster
- Manage User Access
- Manage Billing
- Release Notes
Statement Analysis enables you to directly observe the SQL execution on the page, and easily locate performance problems without querying the system tables.
Key Visualizer helps you observe TiDB's data access patterns and data hotspots.
To use the statement analysis, perform the following steps:
Navigate to the Diagnostics tab of a cluster. The Statement sub-tab displays by default.
Select the time period to be analyzed in the time interval box. Then you can get the execution statistics of SQL statements of all databases in this period.
(Optional) If you only care about certain databases, you can select the corresponding schema(s) in the next box to filter the results.
The results are displayed in the form of a table, and you can sort the results by different columns.
For details, see Statement Execution Details in TiDB Dashboard.
To view the key analytics, perform the following steps:
Navigate to the Diagnostics tab of a cluster.
Select the Key Visualizer tab.
On the Key Visualizer page, a large heat map shows changes on access traffic over time. The average values along each axis of the heat map are shown below and on the right side. The left side is the table name, index name and other information.
For details, see Key Visualizer.