Session management allows you to view the session statistics of an instance, identify exceptional sessions, and terminate them from the console. This feature is integrated with Database Autonomy Service (DAS) and is available for PolarDB for PostgreSQL (Compatible with Oracle) clusters.
View and manage sessions
To view session data and terminate problematic sessions:
Log on to the PolarDB console.
In the left-side navigation pane, click Clusters.
In the upper-left corner, select the region where your cluster is deployed.
Click the cluster ID to go to the Basic Information page.
In the left-side navigation pane, choose Diagnostics and Optimization > Quick Diagnostics.
Click the Session Management tab.
The Session Management page displays two sections: Instance Sessions and Session Statistics.
Instance Sessions
The Instance Sessions section displays session data for the selected instance, including:
| Metric | Description |
|---|---|
| Exceptional sessions | Sessions that may be causing issues during SQL request execution |
| Active sessions | Sessions currently running operations |
| CPU usage | Current CPU utilization of the instance |
To terminate an exceptional session, select the session and click Kill Selected.
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
The Session Statistics section provides aggregated session metrics, including:
Total number of sessions
Session runtime
Breakdowns by different metrics, such as the number of sessions per user
Use these statistics to identify patterns, such as a single user consuming a disproportionate number of sessions.
