Standard monitoring

Updated at:

Reviewing performance metrics is essential for routine database maintenance and troubleshooting. RDS for PostgreSQL provides comprehensive performance metrics to help you promptly identify database anomalies.

Feature overview

RDS for PostgreSQL has upgraded its Standard Monitoring feature, which now integrates performance trends to offer enhanced functionality.

In standard monitoring, you can view the following metrics:

Metric category

Metrics

Basic metrics

CPU utilization, memory utilization, available memory percentage, available memory, storage usage, disk space usage details, space used, network traffic, and data disk IOPS.

Database metrics

latency, 2PC, long-running transaction, slow query, bloat, transactions per second, rows touched, and connections.

Standard monitoring

  1. Log on to the ApsaraDB RDS console and 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 instance ID.

  2. In the left-side navigation pane, click Monitoring and Alerts.

  3. On the Standard Monitoring page, you can perform the following operations:

    • Query monitoring metrics for a specific time range

      Select a time range to view the corresponding metrics. You can query monitoring data from the past 30 days only.

      At the top of the monitoring page, select a preset time range from the Quick Time drop-down list, or manually specify a start and end time.

    • Enable real-time mode

      Click the image icon before the time selection box to enable real-time mode. In this mode, the system automatically refreshes the monitoring metrics every 5 seconds, showing you real-time performance changes in your database.

    • Change the monitoring frequency

      Set the Data Granularity to view metric trends at different granularities (5 seconds, 30 seconds, or 1 minute).

    • View metric descriptions

      In the metric trend chart, click the 指标.png icon next to each monitoring item to view the descriptions of the included metrics.

    • Switch nodes

      For Cluster Edition instances of RDS for PostgreSQL, you can select different nodes to view, or select multiple nodes for comparison.

Note

On the Standard Monitoring page, click Old Version in the upper-right corner to revert to legacy monitoring.

Appendix: Legacy monitoring

Legacy metrics

Legacy monitoring provides the following metrics:

Metric category

Metrics

Resource Monitoring

CPU utilization, memory utilization, IOPS, data disk IOPS, data disk usage, network traffic, and disk usage.

Engine Monitoring

connections, rows touched, transactions per second, bloat, latency, slow query, long-running transaction, and 2PC.

Legacy monitoring

  1. Log on to the ApsaraDB RDS console and 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 instance ID.

  2. In the left-side navigation pane, click Monitoring and Alerts.

  3. Click the Standard Monitoring tab and then click Old Version.

  4. On the legacy monitoring page, select Resource Monitoring and Engine Monitoring, and then select a time range (For Cluster Edition instances, you can also select an instance or node ID) to view monitoring data. You can query monitoring data from the past 30 days only.

Legacy monitoring frequency

Monitoring frequency configuration

The following table describes the supported monitoring frequencies for different instances in legacy monitoring.

Important

In legacy monitoring, the monitoring frequency for an instance that uses cloud disks is fixed at every 60 seconds. Even if you change the frequency, the change does not take effect.

Instance type

Every 5 seconds

Every 60 seconds

Every 300 seconds

High-availability Edition with less than 8 GB of memory

Not supported

Free

Free (default)

High-availability Edition with 8 GB or more of memory

Paid

Free (default)

Free

Basic Edition

Not supported

Not supported

Free (default)

Cluster Edition

Not supported

Free

Free

Billing

In legacy monitoring, the 5-second monitoring frequency is a paid service. Other frequencies are free.

  • Billable item: 5-second monitoring frequency.

  • Billing method: Pay-As-You-Go (billed hourly).

  • Price: CNY 0.05 per hour.

Procedure
  1. 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.

  2. In the left-side navigation pane, click Monitoring and Alarms.

  3. In the upper-right corner of the page, click Return to Old Version.

  4. On the legacy monitoring page, click Set Monitoring Frequency.

  5. In the Set Monitoring Frequency dialog box, select a monitoring frequency and click OK.

Related APIs

API

Description

DescribeDBInstanceMonitor

Queries the legacy monitoring frequency.