How to use the session management feature to view the session statistics of an instance - PolarDB

This topic describes the diagnosis feature provided by PolarDB for PostgreSQL (Compatible with Oracle). The diagnosis feature integrates with Database Autonomy Service (DAS) and allows you to use the session management feature to view the session statistics of an instance.

Procedure

Log on to the PolarDB console. Click Clusters in the left-side navigation pane. Select a region in the upper-left corner and click the ID of the cluster in the list to go to the Basic Information page.
In the left-side navigation pane, choose Diagnostics and Optimization > Quick Diagnostics.
Click the Session Management tab.
On the Session Management page, you can view the Instance Sessions and Session Statistics sections.
- Instance Sessions: provides information about exceptional sessions, active sessions, and CPU usage.
  Note
  When you execute an SQL request, an exceptional session may occur. You can select the exceptional session and click Kill Selected to handle the exception.
- Session Statistics: provides the total number of sessions, session runtime, and other session statistics collected based on different metrics. For example, the system calculates the number of sessions initiated by different users.