Database Autonomy Service (DAS) provides the session management feature for ApsaraDB RDS for PostgreSQL. You can use this feature to view and export the statistics of the sessions on your ApsaraDB RDS for PostgreSQL instance. You can also terminate the sessions on your RDS instance. This topic describes how to use the session management feature.

Prerequisites

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

Procedure

  1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  2. In the left-side navigation pane, choose Autonomy Service > Diagnostics.
  3. Click the Session Management tab.
  4. On the Session Management tab, perform the following operations in the Instance Sessions and Session Statistics sections based on your business requirements:p2022010503
    • Kill sessions.
    • View the information of sessions: You can view information such as the numbers of exceptions and active sessions, longest execution duration, and CPU utilization.
    • View the statistics of sessions: You can view the total number of sessions, the number of running sessions, and the longest session runtime. You can also view the number of sessions and active sessions categorized by users, access sources, and databases.
    • Export the statistics of sessions: You can export session summary statistics, and statistics of sessions categorized by different users, access sources, and databases.