How Do I Use DAS to Query SQL Statements?

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region.
3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
4. On the Instances page, locate the DB instance and click Log In in the Operation column.
5. On the displayed login page, enter the correct username and password and click Log In.
6. In the navigation pane, choose Cloud DBA (Intelligent O&M) to go to the Instance Overview page.
7. Locate the instance you want to view and click Details.
8. Choose SQL > SQL Explorer to view full SQL details of the instance.
9. On the SQL Statements tab page, click Enable DAS SQL Explorer. Query the SQL statements executed by the current instance by time range, user, keyword, operation type, or database.
   Figure 1 Enabling SQL Explorer
   

10. Filter operation types by referring to Table 1 and click Export to export the corresponding SQL statements.

    Table 1 Common SQL statement types

    Type	Keyword
    DDL	CREATE, DROP, ALTER
    DML	INSERT, UPDATE, DELETE, SELECT
    DCL	GRANT, REVOKE

    

    A maximum of 10,000 SQL statements can be displayed. If you need to view more, click Export.

    Up to 100,000 records can be exported.