The SQL Explorer and audit feature supports the full request analysis and security audit capabilities of Database Autonomy Service (DAS). The SQL Explorer and audit feature combines the SQL statement search, SQL Explorer, and security audit features. This feature provides information about the SQL statements that are executed. You can use this information to troubleshoot performance issues and identify high-risk sources.

Prerequisites

  • The database instance that you want to manage is connected to DAS and is in the Accessed state.
  • DAS Professional Edition is activated for the database instance. For more information, see DAS Professional Edition.
  • The full request analysis feature is enabled for the database instance. For information about how to enable the full request analysis feature, see Full request analysis.
  • DAS provides the SQL Explorer and audit feature for the following types of database instances:
    • ApsaraDB RDS for MySQL High-availability Edition and Enterprise Edition
    • ApsaraDB RDS for PostgreSQL High-availability Edition
    • Single Node Edition, Archive Database Edition, and Cluster Edition of the ApsaraDB PolarDB MySQL-compatible edition
    • Cluster Edition of the ApsaraDB PolarDB PostgreSQL-compatible edition

Pricing

Procedure

In the left-side navigation pane, choose Request Analysis > SQL Explorer and Audit. You can use the following features:
  • Search: This feature allows you to query and export SQL statements and information about SQL requests, such as the databases on which the SQL statements are executed, status of the SQL requests, and SQL execution time. For more information, see Search.
  • SQL Explorer: This feature can be used to diagnose the health status of SQL statements, troubleshoot performance issues, and analyze workload traffic. For more information, see SQL Explorer.
  • Security audit: This feature can automatically identify risks, such as high-risk SQL statements, SQL injection attacks, and new request sources. For more information, see Security audit.