Manage the alert rules of an ApsaraDB RDS for PostgreSQL instance - ApsaraDB RDS

You can enable the initiative alert feature or create custom alert rules. When a condition specified for an alert rule is met, the system sends alert notifications to all alert contacts in your alert contact group.

Background information

The monitoring and alerting feature of ApsaraDB RDS is implemented by using CloudMonitor. CloudMonitor allows you to configure metrics and alert rules. When a condition specified for an alert rule is met, CloudMonitor sends alert notifications to all alert contacts in your alert contact group by sending emails. You can manage the alert contact group that corresponds to a monitoring metric. When an alert is triggered, the system can notify alert contacts in the alert contact group at the earliest opportunity.

Enable the initiative alert feature

After you enable the initiative alert feature for an ApsaraDB RDS for PostgreSQL instance, an alerting system for the RDS instance is instantly built. This way, you can identify exceptions in crucial metrics at the earliest opportunity.

Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
In the left-side navigation pane, click Monitoring and Alerts.
On the page that appears, click the Alerts tab.

In the right-side section of the page, turn on the Initiative Alert switch.

After you enable the initiative alert feature, the system automatically monitors the following metrics.

Rule name	Metric	Statistical period	Description
SystemDefault_acs_rds_dashboard_PG_RO_ReadLag	Synchronization Latency of Read-only Instances	60 seconds	If the average value of the Synchronization Latency of Read-only Instances metric is greater than or equal to 7,200 seconds in five consecutive statistical periods, an alert is triggered. ApsaraDB RDS sends the alert to all contacts in the alert contact group.
SystemDefault_acs_rds_dashboard_conn_usage	Connections Usage	60 seconds	If the average value of the Connections Usage metric is greater than or equal to 90% in five consecutive statistical periods, an alert is triggered. ApsaraDB RDS sends the alert to all contacts in the alert contact group.
SystemDefault_acs_rds_dashboard_local_fs_size_usage	Disk Usage	60 seconds	If the average value of the Disk Usage metric is greater than or equal to 90% in five consecutive statistical periods, an alert is triggered. ApsaraDB RDS sends the alert to all contacts in the alert contact group.
SystemDefault_acs_rds_dashboard_cpu_usage	CPU Utilization	60 seconds	If the average value of the CPU Utilization metric is greater than or equal to 90% in five consecutive statistical periods, an alert is triggered. ApsaraDB RDS sends the alert to all contacts in the alert contact group.
SystemDefault_acs_rds_dashboard_iops_usage	IOPS Utilization	60 seconds	If the average value of the IOPS Utilization metric is greater than or equal to 80% in five consecutive statistical periods, an alert is triggered. ApsaraDB RDS sends the alert to all contacts in the alert contact group.
SystemDefault_acs_rds_dashboard_PG_MaxSlotWalDelay	Maximum Replication Slot Latency	60 seconds	If the average value of the Maximum Replication Slot Latency metric is greater than or equal to 1,024 MB in five consecutive statistical periods, an alert is triggered. ApsaraDB RDS sends the alert to all contacts in the alert contact group.
SystemDefault_acs_rds_dashboard_PG_SwellTime	Longest Transaction Duration	60 seconds	If the average value of the Longest Transaction Duration metric is greater than or equal to 36,000 seconds in five consecutive statistical periods, an alert is triggered. ApsaraDB RDS sends the alert to all contacts in the alert contact group.

Optional. Specify an alert contact. If you do not specify an alert contact, ApsaraDB RDS specifies the owner of the Alibaba Cloud account as the alert contact. You can change the alert contact.
1. Log on to the CloudMonitor console.
2. In the left-side navigation pane, choose Alert Contacts.
3. On the Alert Contacts tab, click Create Alert Contact. For more information about how to create an alert contact, see Create an alert contact or alert contact group.
4. In the search box on the Alert Contact Group tab, enter Default Contact Group to find the default contact group. Then, click the icon for the default contact group.
5. On the Modify Contact Group panel, modify the contacts.

Configure custom alert rules

ApsaraDB RDS allows you to configure custom alert rules for an RDS instance based on your business requirements. The following table describes the metrics that you can configure in custom alert rules.

PG_DBAge	PG_InactiveSlots	PG_MaxExecutingSQLTime
PG_MaxSlotWalDelay	PG_RO_ReadLag	PG_RO_StreamingStatus
PG_ReplayLatency	PG_SwellTime	PG_ActiveConnectionsPerCpu
PG_ConnectionsUtilization	PG_CPUUtilization	PG_IOPSUtilization
PG_INODEUtilization	PG_DISKUtilization	PG_MemoryUtilization

Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
In the left-side navigation pane, click Monitoring and Alerts.
On the page that appears, click the Alerts tab.
In the right-side section of the page, click Set Alert Rule to go to the CloudMonitor console.
Create an alert contract group. For more information, see Create an alert contact or alert contact group.
Create an alert rule. For more information, see Create an alert rule.
Note
- When you create an alert rule, set the Product parameter to ApsaraDB RDS for PostgreSQL.
- You can also monitor resources based on tags. For more information, see Monitor resources based on tags.