Database Autonomy Service (DAS) allows you to use the SQL Explorer and Audit feature on ApsaraDB RDS for PostgreSQL instances. The SQL Explorer and Audit feature is integrated with other features, such as the search and SQL Explorer features, based on the full request analysis capability of DAS. You can query information about executed SQL statements and use the information to troubleshoot performance issues. This topic describes how to use the SQL Explorer and Audit feature.
Billing
You are charged if you use the features of the SQL Explorer and Audit module. For more information, see Billing overview.
Enable SQL Explorer and Audit
If you have enabled DAS Professional Edition for a database instance, the SQL Explorer and Audit module is automatically enabled for the database instance. You do not need to manually enable this module. For more information, see Purchase DAS Professional Edition.
Log on to the DAS console.
In the left-side navigation pane, click Instance Monitoring.
On the page that appears, find the database instance that you want to manage and click the instance ID. The instance details page appears.
In the left-side navigation pane, choose Request Analysis > SQL Explorer and Audit.
On the SQL Explorer and Audit page, click Enable.
If DAS Professional Edition is not purchased within your Alibaba Cloud account, follow the instructions to purchase DAS Professional Edition. For more information, see Purchase DAS Professional Edition.
NoteIt takes 10 to 20 minutes to enable the SQL Explorer and Audit module.
Procedure
Log on to the DAS console.
In the left-side navigation pane, click Instance Monitoring.
On the page that appears, find the database instance that you want to manage and click the instance ID. The instance details page appears.
In the left-side navigation pane, choose . On the page that appears, you can use the following features:
Search: This feature is used to query and export SQL statements and related information, such as the databases on which the SQL statements are executed, the status of SQL requests, and the execution duration of each SQL statement. For more information, see Search.
SQL Explorer: This feature is used to diagnose the health status of SQL statements, troubleshoot performance issues, and analyze business traffic. For more information, see SQL Explorer.
Modify the storage duration of data generated by SQL Explorer and Audit
If you reduce the storage duration of data generated by the SQL Explorer and Audit module, DAS immediately clears the SQL audit logs that are stored for a period longer than the specified storage duration. We recommend that you export and save SQL audit logs to your computer before you reduce the storage duration.
Log on to the DAS console.
In the left-side navigation pane, click Instance Monitoring.
On the page that appears, find the database instance that you want to manage and click the instance ID. The instance details page appears.
In the left-side navigation pane, choose Request Analysis > SQL Explorer and Audit.
On the SQL Explorer and Audit page, click the SQL Explorer tab. On this tab, click Service Settings.
In the Service Settings dialog box, modify the storage duration and click OK.
NoteThe default storage duration of data generated by the SQL Explorer and Audit module is 30 days. The SQL audit logs that are stored for a period longer than the specified storage duration are deleted.
You can also specify the storage duration of data generated by the SQL Explorer and Audit module for your database instance on the DAS Professional Edition Management page. For more information, see Purchase DAS Professional Edition.
The storage space that is occupied by the data generated by the SQL Explorer and Audit module is provided by DAS and does not consume the storage of your database instance.
Disable SQL Explorer and Audit
After you disable the SQL Explorer and Audit module, your business is not affected. However, SQL audit logs are cleared. Before you disable the SQL Explorer and Audit module, we recommend that you export the SQL audit logs as a file and download the file to your computer. If you enable the SQL Explorer and Audit module again, SQL audit logs are generated from the point in time when the SQL Explorer and Audit module is enabled.
Log on to the DAS console.
In the left-side navigation pane, click Instance Monitoring.
On the page that appears, find the database instance that you want to manage and click the instance ID. The instance details page appears.
In the left-side navigation pane, choose Request Analysis > SQL Explorer and Audit.
On the SQL Explorer and Audit page, click the Search tab.
In the Logs section of the Search tab, click Export.
In the dialog box that appears, configure the Exported Fields and Export Time Range parameters, and then click OK.
Download the exported file to your computer and keep the file safe.
If SQL Explorer and Audit of the previous version is enabled for your database instance, you can download the exported log file on the Task list tab.
If SQL Explorer and Audit of the new version is enabled for your database instance, you can click View Exported Logs on the Search tab to download the exported log file.
Click Service Settings. In the Service Settings dialog box, turn off the switch and click OK.
The storage space that is occupied by the data generated by the SQL Explorer and Audit module is released one hour after the SQL Explorer and Audit module is disabled.