Performance optimization and diagnosis

Autonomy services that are provided by ApsaraDB RDS for PostgreSQL have the following features:

• Autonomy center

  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.

• Session management

  This feature is used to view, export, and close the sessions of your RDS instance.

• Real-time monitoring

  This feature is used to view the real-time performance of your RDS instance.

• Storage analysis

  This feature allows you to view the storage usage of your RDS instance. For example, you can view the remaining days for which storage is available, the storage usage of individual tables, the tablespace fragments, and the storage exception diagnosis. You can use this feature to identify the storage exceptions at the earliest opportunity to ensure business stability.

• Performance insight

  This feature is used to monitor loads, analyze data, and optimize performance. You can use this feature to evaluate the loads of your RDS instance and identify the root causes of performance issues to improve the stability of your RDS instance.

• Performance trend

  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.

• Slow SQL statement analysis

  This feature is used to check the trends, execution, and optimization suggestions for slow query logs of your RDS instance.

• SQL Explorer and Audit

  This feature is based on the full request analysis and security audit capabilities 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.

• Monitoring dashboard

  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.

• Event alerting

  This feature is used to send you notifications when specified events occur. You can specify a notification method based on your business requirements.

• Automatic SQL optimization

  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.

• Automatic storage expansion

  This feature is used to automatically expand the storage capacity of your RDS instance when the used storage of your RDS instance is greater than or equal to the specified threshold. This helps ensure the business stability.