View session statistics-PolarDB(PolarDB)-阿里云帮助中心

The Quick Diagnostics feature for PolarDB for PostgreSQL and integrates some features from the Database Autonomy Service (DAS). The session management feature lets you view session statistics for a target cluster.

Procedure

Log on to the PolarDB console. In the left-side navigation pane, click Clusters. Select the region where your cluster is located, and then click the target cluster ID to open the cluster details page.
In the left-side navigation pane, choose Diagnostics and Optimization > Quick Diagnostics.
Click the Sessions tab.
On the Sessions page, view detailed information on Instance Sessions and Session Statistics.
- Instance Sessions: Displays current instance session information, including exceptional sessions, active sessions, and CPU utilization.
  
  The action bar contains a Refresh button, an Active Sessions toggle, auto-refresh interval settings, a Search Sessions input box, and a Kill All Sessions button. The summary cards show the number of exceptions, number of active sessions, maximum execution time, and CPU utilization. The table below lists details for each session, including its PID, client, database, user name, connection time, query duration, and the current SQL statement.
  
  Note
  If an exceptional session occurs while executing an SQL request, select the session and click Kill Selected to terminate it.
- Session Statistics: Displays the total number of sessions, the total number of running sessions, and the longest session runtime. It also provides session counts aggregated by different criteria, such as by user. The Session Statistics page is divided into four sections: Overview, By User, By Source, and By Database, each displaying the number of active and total sessions.