Performance and Query Optimization Overview

Procedure

1. Log on to the AnalyticDB for PostgreSQL console.
2. In the upper-left corner of the console, select a region.
3. Find the instance that you want to manage and click the instance ID.

4. In the left-side navigation pane, choose Diagnostics and Optimization > Overview.

   The left side of the Overview page lists instance status information, and the right side displays metrics in line charts.

   • Status information

     Section	Metric	Description
     Connection Status	Connection Status of Coordinator Node	The connection status of the coordinator node, indicated by the following colors: Red: The node connection usage is greater than or equal to 95%. Yellow: The node connection usage is greater than or equal to 90% and less than 95%. Green: The node connection usage is less than 90%. Note
     	Connection Status of Compute Node	The connection status of compute nodes, indicated by the following colors: Red: The node connection usage is greater than or equal to 95%. Yellow: The node connection usage is greater than or equal to 90% and less than 95%. Green: The node connection usage is less than 90%. Note The connection usage of compute nodes indicates the maximum connection usage among all compute nodes.
     Cluster Status	Running Status	The running status of the instance. For more information, see Instance statuses.
     	Instance Health Status	The health status of the instance, indicated by the following colors: Red: The coordinator node or one of the compute nodes is unavailable. Green: All compute nodes are available.
     	Instance Connection Status	The connection status of the instance, indicated by the following colors: Red: The instance connection usage is greater than or equal to 95%. Yellow: The instance connection usage is greater than 90% and less than or equal to 95%. Green: The instance connection usage is less than or equal to 90%. Note The instance connection usage indicates the maximum connection usage among all the coordinator and compute nodes.
     	Coordinator Node Status	The health status of the coordinator node, indicated by the following colors: Red: Both the primary and standby coordinator nodes are unavailable. Yellow: The primary or standby coordinator node is unavailable. Green: Both the primary and standby coordinator nodes are available.
     	Compute Node Status	The health status of compute nodes, indicated by the following colors: Red: All compute nodes are unavailable. Yellow: At least half of all compute nodes are unavailable. Green: All compute nodes are available.
     Storage Status	Instance Storage Status	The storage status of the instance, indicated by the following colors: Red: The instance storage usage is greater than or equal to 90%. In this case, the instance is locked. Yellow: The instance storage usage is greater than or equal to 70% and less than 90%. Green: The instance storage usage is less than 70%.
     	Maximum Storage Usage of Coordinator Node	The maximum storage usage of the coordinator node. Unit: %.
     	Maximum Storage Usage of Compute Node	The maximum storage usage of compute nodes. Unit: %.

   • Line charts

     The following metrics are displayed in line charts: SQL Statement, Connections, Instance Storage Usage (%), Coordinator Nodes, and Compute Nodes. Hover over a line chart to view details.