Database Autonomy Service (DAS) provides the monitoring dashboard feature for ApsaraDB RDS for PostgreSQL. DAS 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 understand the status of ApsaraDB RDS for PostgreSQL instances.

Prerequisites

Your ApsaraDB RDS for PostgreSQL instance runs RDS High-availability Edition.

Note DAS provides the monitoring dashboard feature for ApsaraDB RDS for PostgreSQL from May 20, 2022.

Create a monitoring dashboard

  1. Log on to the ApsaraDB RDS console.
  2. In the left-side navigation pane, click Performance Center.
  3. On the Performance Center page, click the Monitoring Dashboard tab.
  4. Click the tab for the database engine. Then, click Add Monitoring Dashboard.
  5. In the dialog box that appears, configure the Dashboard Name parameter and click OK.
  6. Click Select Instances and Metrics. In the dialog box that appears, select the RDS instances and the metrics that you want to monitor. Then, click the Rightwards arrow icon to add the selected RDS instances to the Selected Instances section and the selected metrics to the Selected Metrics section.
    Note
    • You can select up to 32 RDS instances at a time.
    • For more information about the metrics, see Metrics.
    Select Metrics and Instances dialog box
  7. Click Confirm.
    Note To modify the RDS instances or metrics in the monitoring dashboard, click Add Instances and Metrics.

View the metric trends of an RDS instance in the monitoring dashboard

  1. Log on to the ApsaraDB RDS console.
  2. In the left-side navigation pane, click Performance Center.
  3. On the Performance Center page, click the Monitoring Dashboard tab.
  4. Click the tab for the database engine, select the monitoring dashboard that you want to view, and then specify a time range to view the trend charts of the metrics during the specified time range.
    Note When you specify a time range, the end time must be later than the start time, and the interval between the start time and the end time cannot exceed seven days.
    • You can configure the Instance filtering parameter to filter for multiple RDS instances and then view and compare the metrics of the RDS instances.
    • You can turn on Auto Refresh (Every 5 Seconds) for the system to refresh the trend charts of the metrics every 5 seconds.
    • You can turn on Linkage Chart to view the values of different metrics at the same point in time.
    • You can configure the Chart Layout parameter to specify the number of trend charts of metrics in each row.
    • You can click Add Instances and Metrics to modify the RDS instances or metrics in the dashboard.
    • You can click Details in the trend chart of a metric to expand the chart. You can also change the time range to view the changes in the trend of the metric at the specified time range.
    • You can click Delete in the trend chart of a metric to delete the chart from the dashboard.

Metrics

CategoryMetricDescription
Hostcpu_sys_ratioThe CPU utilization of the PostgreSQL process in the kernel state.
cpu_user_ratioThe CPU utilization of the PostgreSQL process in the user state.
cpu_usageThe CPU utilization of the PostgreSQL process.
mem_usageThe memory usage of the PostgreSQL process.
data.r_sThe read IOPS of the disk on which the data directory resides.
data.iopsThe IOPS of the disk on which the data directory resides.
data.w_sThe write IOPS of the disk on which the data directory resides.
local_fs_size_totalThe total amount of disk space of the server.
data.fs.usedThe amount of used space of the disk on which the data directory resides.
data.fs.usageThe space usage of the disk on which the data directory resides.
network_out_ioThe outbound network traffic of the PostgreSQL process.
network_ioThe network traffic of the PostgreSQL process.
network_in_ioThe inbound network traffic of the PostgreSQL process.
PostgreSQL basic monitoringwaiting_connectionThe number of pending connections.
idle_in_transactionThe number of idle sessions.
active_sessionThe number of active connections.
total_sessionThe total number of current connections.
tup_insertedThe number of records that are inserted per second.
tup_deletedThe number of records that are deleted per second.
tup_updatedThe number of records that are updated per second.
tup_returnedThe number of records that are returned per second for full table scans.
tup_fetchedThe number of records that are returned per second for index scans.
tpsThe transactions per second (TPS) in PostgreSQL.
xact_rollbackThe number of transactions that are rolled back per second.
xact_commitThe number of transactions that are committed per second.
deadlocksThe number of deadlocks per second.
oldest_snapshotThe point in time before which the generated dead tuples can be recycled by the RDS instance.
max_sent_delayThe latency of data replication from the secondary RDS instance.
max_replay_delayThe latency at which the secondary RDS instance replays transaction commits.
long_query_5sThe number of SQL statements whose execution duration is greater than or equal to 5 seconds.
long_query_1sThe number of SQL statements whose execution duration is greater than or equal to 1 second.
long_query_3sThe number of SQL statements whose execution duration is greater than or equal to 3 seconds.
long_idle_in_transaction_3sThe number of transactions that are idle for 3 seconds or longer.
long_idle_in_transaction_5sThe number of transactions that are idle for 5 seconds or longer.
long_idle_in_transaction_1sThe number of transactions that are idle for 1 second or longer.
long_2pc_1sThe number of 2PC transactions that last for 1 second or longer.
long_2pc_5sThe number of 2PC transactions that last for 5 seconds or longer.
long_2pc_3sThe number of 2PC transactions that last for 3 seconds or longer.
Note You can click the Info icon icon on the right of a metric in a dashboard to view the description of the metric.