Product Introduction

Overview

Concepts

Cluster Architecture

Strengths

Scenarios

Purchase Guide

Billing Overview

Renewal Instructions

Overdue Policy

Refund Instructions

Configuration Adjustment Billing Instructions

Getting Started

Using Tencent Cloud TCHouse-D Through the Console

Using Tencent Cloud TCHouse-D Through a Client

Operation Guide

Cluster Operation

Monitoring and Alarm Configuration

Account Privilege Management

Data Management

Query Management

Modify Configurations

Node Management

Log Analysis

SQL Studio

Enabling Resource Isolation

Development Guide

Design of Data Table

Importing Data

Exporting Data

Basic Feature

Query Optimization

Ecological Expansion Feature

API Documentation

History

Introduction

API Category

Making API Requests

Cluster Operation APIs

Database and Table APIs

Cluster Information Viewing APIs

Hot-Cold Data Layering APIs

Database and Operation Audit APIs

User and Permission APIs

Resource Group Management APIs

Data Types

Error Codes

Cloud Ecosystem

Granting CAM Policies to Sub-accounts

Query Acceleration for Tencent Cloud DLC

Practical Tutorial

Basic Feature Usage

Advanced Features Usage

Resource Specification Selection and Optimization Suggestions

Naming Specifications and Limits to the Database and Data Table

Table Design and Data Import

Query Optimization

Suggested Usage to Avoid

Accessing TCHouse-D via JDBC over the Public Network

Performance Testing

TPC-H Performance Testing

SSB Performance Testing

TPC-DS Performance Testing

FAQs

Common Operational Issues

Common Errors

Glossary

Product Policy

Service Level Agreement

Data Processing And Security Agreement

Query Analysis

PDF

Mode fokus

Ukuran font

Terakhir diperbarui: 2024-06-27 10:52:03

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.
﻿