SQL Explorer

Features

Database Autonomy Service (DAS) integrates features such as Search, SQL Explorer, Security Audit, and Traffic Replay and Stress Testing based on full request data collection and security auditing. DAS helps you retrieve the details of SQL statements, troubleshoot a wide range of performance issues, identify high-risk sources, and determine if your cluster requires scaling, which helps you effectively handle service traffic peaks.

• Search feature: Queries and exports SQL statements and their corresponding information, such as the database, status, and execution time. For more information, see Audit.

• SQL Explorer: This feature allows you to diagnose SQL health, troubleshoot performance issues, and analyze service traffic. For more information, see SQL Explorer.

  • SQL Review: Provides a global SQL workload analysis capability to help you quickly identify suspicious SQL statements in database instances, analyze them, and receive optimization suggestions. For more information, see SQL Review.

  • Traffic Replay and Stress Testing: Provides traffic replay and stress testing features to help you verify whether you need to scale up your instance specifications to effectively handle service traffic peaks. For more information, see Traffic Replay and Stress Testing.

  • The Security audit feature automatically identifies risks such as high-risk SQL, SQL injection, and new access sources. For more information, see Security Audit.

  • The Transaction Analysis feature allows you to view the transaction type, transaction count, and details for a specific thread within a specified time period. This helps you understand, analyze, and optimize database performance from a transaction perspective. For more information, see Transaction Analysis.

  • Quick Transaction Analysis: Quick Transaction Analysis helps you identify the start and end statements of the transaction that contains the SQL to be analyzed. This allows you to determine whether the transaction was committed or rolled back. For more information, see Quick Transaction Analysis.

Supported regions

You can use the SQL Explorer and Audit feature only after you enable DAS Enterprise Edition. The supported regions vary by edition. For more information, see Databases and regions supported by different editions.

Impact

When enabled, SQL Explorer records all DQL, DML, and DDL operations. This information is output by the database kernel and results in minimal CPU consumption.

Usage notes

To use the Search feature, RAM users must be granted the AliyunPolardbReadOnlyWithSQLLogArchiveAccess permission. For information about how to grant permissions to a RAM user, see Create and manage RAM users.

Billing

Enable SQL Explorer

1. Log on to the PolarDB console.

2. In the upper-left corner of the console, select a region.

3. Click the ID of the destination cluster.

4. In the navigation pane on the left, choose Logs and Auditing > SQL Insights.

5. Enable SQL Explorer.

   If DAS Enterprise Edition is not enabled for your Alibaba Cloud account, follow the on-screen instructions to enable it.

6. Click a feature tab to view related information.

   • Range View: Select a time range to view the SQL Explorer results. You can view the Execution Time Distribution, Execution Duration, and Executions for all SQL statements within the selected time range. You can also view detailed information about all SQL statements in the Full Request Statistics section and export the information to your local computer.

     Note

     You can export a maximum of 1,000 SQL logs. To retrieve more SQL logs over a longer time range, you can use the Audit feature.

   • Display by Comparison: Select time points to compare the SQL Explorer results. You can view a comparison of the Execution Time Distribution, Execution Duration, and Executions for all SQL statements. You can also view detailed comparison results in the Requests by Comparison section.

   • Source Statistics: Select a time range to view statistics about SQL sources. You can view the source information for all SQL statements within the selected time range.

Modify the storage duration of SQL logs

1. Log on to the PolarDB console.

2. In the upper-left corner of the console, select a region.

3. Click the ID of the destination cluster.

4. In the navigation pane on the left, choose Logs and Auditing > SQL Insights.

5. In the upper-right corner, click Service Settings.

6. Modify the storage duration, and click OK.

   If you have enabled DAS Enterprise Edition V3, you can modify the data storage duration for different sub-features.

   Note

   The storage space for SQL Explorer data is provided by DAS and does not occupy the storage space of the database instance.

Export SQL records

1. Log on to the PolarDB console.

2. In the upper-left corner of the console, select a region.

3. Click the ID of the destination cluster.

4. In the navigation pane on the left, choose Logs and Auditing > SQL Insights.

5. Click the Audit tab, and then click Export.

6. In the dialog box that appears, select the required Export Field, specify an Export Time Range, and click OK.

7. In the Are you sure that you want to export SQL details? dialog box, set the Task Name and CSV Separator, and then click Are you sure you want to submit the task?.

   Note

   • Once a task is submitted, it cannot be canceled.

   • No fees are charged if the task fails.

   • Task-related data is retained for only 7 days.

   • A maximum of 10 million records can be exported for a task. If the number of records to export exceeds 10 million, you must reduce the time range for the export.

   • The system requires approximately 5 minutes to process and archive the latest data. To export the latest data, wait for a few minutes and then try again.

8. After the export is complete, click Tasks in the upper-right corner of the SQL Explorer page. In the Actions column of the target task, click Download to download the exported file.

Disable SQL Explorer

1. Log on to the PolarDB console.

2. In the upper-left corner of the console, select a region.

3. Click the ID of the destination cluster.

4. In the navigation pane on the left, choose Logs and Auditing > SQL Insights.

5. Click Service Settings to disable SQL Explorer and SQL Audit.

   If you have enabled DAS Enterprise Edition V3, clear the check boxes for all SQL Explorer and SQL Audit features, and then click Submit.

   Note

   Approximately one hour after you disable the SQL Explorer and SQL Audit features, the system releases the storage space that is occupied by the SQL Explorer and SQL Audit data.

6. Select the check box to acknowledge the prompt, and then click Submit and Unsubscribe.

View audit log size and consumption

1. Log on to the Alibaba Cloud Console. In the upper-right corner of the page, choose Expenses.

2. In the left-side Expenses and Costs navigation pane, choose Bill > Bill Details. View the cost details where the Billable Item column is sql_explorer.

3. On the Bill Details page, search by Instance ID. View the cost details where the Billable Item column is sql_explorer.