tencent cloud

All product documents
Tencent Cloud TCHouse-D
DocumentationTencent Cloud TCHouse-DOperation GuideQuery ManagementQuery Analysis
Query Analysis
Download PDF
Last updated: 2024-06-27 10:52:03
Query Analysis
Last updated: 2024-06-27 10:52:03
Download PDF
On the Query Analysis page, you can analyze query details of those with the Profile feature enabled. On this page, you can view SQL details, query plan, and execution details, presented in both graphical and textual format.
With these capabilities, developers can understand query execution in finer detail and carry out targeted debugging and optimization.

Operation Guide

1. Log in to Tencent Cloud TCHouse-D Console, select the target Cluster ID/Name from the cluster list, and switch to the Query Analysis page.

2. The queries that you want to analyze need to have the Profile feature enabled in advance. The enabling methods include SQL workspace enabling and client enabling:
Enable SQL Studio: When using SQL Studio for queries, you can check Enable query profile while editing the query.

Enable Client: When using other methods for queries, enter set enable_profile=true in the command line to enable the Profile feature.
Note:
Query and Analysis only applies to SQL with the Profile feature enabled. This feature may have some impact on query performance.
3. For profile enabled queries, you can view Request ID, Query Status, Operation Time, etc. in the Query and Analysis list. By clicking Request ID or Details button in the SQL column, you can proceed with detailed analysis.

4. On the Query Analysis detail page, you can view into the SQL Details, Query Plan, and Execution Details of the corresponding Request ID:
SQL Details: You can view the specific statement of the executed SQL, with support for copying with a single click.
Query Plan: It presents the current query plan in graphic or text format.
Execution Details: It presents the execution details of a query in graphic or text format.

Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 available.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon