Instance Summary
On the Summary page, you can get knowledge of the overall status of your RDS for PostgreSQL instance, including active alarms, anomalies, and key performance metrics. Intelligent anomaly diagnosis uses operational data analytics and intelligent algorithms to assess instance health, and provides you with solutions and suggestions for handling detected anomalies.
Functions
Table 1 lists the functions provided on the Summary page.
| Function | Description |
|---|---|
| Instance Information | Shows basic information about your instance and allows you to modify the instance.
|
| Alarms | Shows the active alarms of your instance, including alarms in the Alarm (metric) or Triggered (event) state. |
| Intelligent Anomaly Diagnosis | Shows the health status of your instance based on operational data analysis and intelligent algorithms. |
| Performance Monitoring | Shows the instance's key performance metrics, including the CPU usage, memory usage, number of SQL statements executed for more than 3s, and number of connections. |
| Storage & Backup | Shows the storage space and backup space usage of your instance, and allows you to scale up the storage. |
Instance Summary
- Log in to the RDS console.
- Click
in the upper left corner and select a region. - On the Instances page, click the target instance name to go to the Summary page.
- In the Instance Information area, check the instance information and modify the instance as required. Figure 1 Instance Information
In the Alarms area, check alarm information of your instance.
Based on the configured alarm rules, you can see active alarms of your instance, including alarms in the Alarm (metric) or Triggered (event) state.
- To check all alarm records, click All Alarms to go to the Cloud Eye console.
- To configure alarm rules, click Alarm Settings to go to the Cloud Eye console.
- To check alarms over time, select a time window in the upper part of the Alarms area.
The time window can be the last 1 hour, last 6 hours, last 12 hours, last 24 hours, last 7 days, last 30 days, or a custom time period.
In the Intelligent Anomaly Diagnosis area, view the health diagnosis results of your instance in real time.
Intelligent Anomaly Diagnosis checks instance health using instance operation data and intelligent algorithms and provides diagnosis results and suggestions.
Table 2 provides the supported diagnosis items and handling suggestions.
| Diagnosis Item | Metric | Metric Description | Handling Suggestions | Practices |
|---|---|---|---|---|
| Memory bottleneck | Memory Usage (%) | Memory usage of the monitored object |
| |
| Active Connections(Count) | Number of active connections to the current DB instance | |||
| High-frequency slow SQL | Slow SQL Statements | Number of slow SQL statements that exceed the specified duration |
| Troubleshooting SQL Statements That Have Been Executed for 3s or 5s |
| Connection bottleneck | Active Connections(Count) | Number of active connections to the current DB instance |
| |
| Database too old | Maximum Database Age(Count) | Maximum age of the current database, which is the value of max(age(datfrozenxid)) in the pg_database table |
| |
| Capacity bottleneck | Storage Space Usage (%) | Storage space usage of the monitored object |
| |
| Used Storage Space (GiB) | Used storage space of the monitored object | |||
| Total Storage Space (GiB) | Total storage space of the monitored object | |||
| Storage bottleneck | IOPS(count/s) | Average number of I/O requests processed by the system in a specified period |
| |
| Disk Read Throughput (Bytes/s) | Number of bytes read from the disk per second | |||
| Disk Write Throughput (Bytes/s) | Number of bytes written into the disk per second | |||
| Lock wait and long transaction | Sessions Waiting for Locks(Count) | Number of sessions that are currently blocked | For long-running transactions, terminate them after confirmation. | |
| Oldest Active Transaction Duration(ms) | Length of time since the start of the transaction that has been active longer than any other current transaction | |||
| Oldest Two-Phase Commit Transaction Duration(ms) | Length of time that has elapsed since the start of the transaction that has been prepared for two-phase commit longer than any other current transaction | |||
| High vCPU utilization | CPU Usage (%) | CPU usage of the monitored object |
| |
| TPS (Times/s) | Execution times of submitted and rollback transactions per second |
In the Performance Monitoring area, you can view the vCPUs (used/total), memory (used/total), number of SQL statements executed for more than 3s, and connection count of your instance.
- To check all metrics, click Real-Time Monitoring to go to the DBA Assistant page. For details, see Viewing Performance Metrics of a DB Instance.
- To check the analysis results of slow queries, click Slow SQL Log to go to the DBA Assistant page. For details, see Viewing Slow Query Logs of a DB Instance.
- To check metric changes over time, select a time range in the upper part.
The time window can be the last 1 hour, last 3 hours, last 12 hours, last 24 hours, last 7 days, last 30 days, or a custom time period.
In the Storage & Backup area, you can check the storage space usage and backup space usage of your instance, enable disk encryption, and scale up storage space.
- Files that occupy the storage space include data files, log files, and other temporary files. To check the distribution and changes of used storage, see Managing Storage Capacity.
- To enable or modify disk encryption after an instance is purchased, refer to Configuring Disk Encryption.
If you enable disk encryption when purchasing an instance, the new storage space after scale-up still uses the original encryption key. Keep the key secure. Once the key is disabled, deleted, or frozen, your instance will become inaccessible.
- As workload data increases, the storage capacity of your instance may be insufficient. To scale up the storage space, see Scaling Storage Space.
- Backups are stored as packages in OBS and occupy the backup space. If the free space RDS provides is used up, the additional space required will be billed. For the billing details, see How Are RDS Backups Billed?
What is your overall rating for this page?
Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot