During daily O&M of ApsaraDB RDS for PostgreSQL instances, you can use Database Autonomy Service (DAS) to handle instance failures, optimize instance performance, improve efficiency, and reduce O&M costs. DAS is a cloud service that is developed based on machine learning and expert experience. DAS provides self-awareness, self-healing, self-optimization, self-O&M, and self-securing capabilities to simplify database O&M tasks and ensure the stability, security, and efficiency of database services.
Function description
Autonomy services that are provided by DAS for ApsaraDB RDS for PostgreSQL provide the following features:
This feature allows you to specify a time range and view events such as exceptions, optimization events, and auto scaling events within the specified time range.
This feature is used to view, export, and terminate the sessions of your RDS instance.
This feature is used to view the real-time performance of your RDS instance.
This feature is used to view the storage usage, such as the remaining days for which storage is available, the storage usage of individual tables, the tablespace fragments, and the storage exception diagnosis, of your RDS instance. This feature helps you identify the storage exceptions at the earliest opportunity to ensure the stability of your RDS instance.
This feature allows you to evaluate the loads of your instance and identify the root causes of performance issues. This improves the stability of your instance.
This feature allows you to view performance trends over specified time ranges, compare performance trends, and customize charts to view the performance trends of your RDS instance.
This feature is used to check the trends, execution, and optimization suggestions for slow query logs of your RDS instance.
This feature is based on the full request analysis and security audit capabilities of DAS and is integrated with the SQL statement search feature and the SQL Explorer feature. You can use the SQL Explorer and Audit feature to query information about the SQL statements that are executed on your RDS instance. Then, you can use the information to troubleshoot various performance issues.
This feature allows you to specify RDS instances and metrics to monitor and compare the metrics of the RDS instances. You can also configure metric linkage. This helps you monitor your RDS instances.
This feature is used to send you notifications when specified events occur. You can specify a notification method based on your business requirements.
This feature is used to automatically analyze and optimize your SQL queries and create indexes. This helps you quickly resolve issues related slow SQL queries and ensure the optimal performance of your RDS instance.
This feature is used to automatically expand the storage capacity of your RDS instance and ensure the business stability when the used storage of your RDS instance is greater than or equal to the specified threshold.