Viewing Session Statistics

Scenarios

On the GaussDB console, you can monitor both active and total session counts categorized by user, access source, and database.

Constraints

The DB engine version of GaussDB instances must be V2.0-3.100 or later, and the kernel version must be 503.0 or later. For details about how to query the version, see Checking the DB Engine and Kernel Engine Version of a GaussDB Instance.

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner of the page and choose Databases > GaussDB.
4. On the Instances page, click the name of the target instance to go to the Basic Information page.
5. In the navigation pane, choose Diagnostics and Optimization > Session Management. Then, click the Session Statistics tab.

   Table 1 Metrics for real-time session statistics

   Metric	Description
   User	Database login username
   Source	Origin of the session connection to the database
   Database	Name of the database being accessed
   Active Sessions	Number of active sessions
   Total Sessions	Total number of sessions