Managing GaussDB(DWS) Database Connections

Scenario

Maximum Number of Connections

Viewing the Maximum Number of Connections

Method 2: Use an SQL client tool to establish a database connection within the cluster and execute an SQL query to obtain the value of max_connections.

SHOW max_connections;

max_connections
----------------- 
200
(1 row)

Viewing the Number of Used Connections

1. Use the SQL client tool to connect to the database in a cluster.
2. View the number of connections in scenarios described in Table 2.
   Notice

   Except for database and user names that are enclosed with double quotation marks (") during creation, uppercase letters are not allowed in the database and user names in the commands in the following table.

   SELECT ROLNAME,ROLCONNLIMIT FROM PG_ROLES WHERE ROLNAME='dbadmin';
   
   

   SELECT COUNT(*) FROM V$SESSION WHERE USERNAME='dbadmin';
   
   

   SELECT DATNAME,DATCONNLIMIT FROM PG_DATABASE WHERE DATNAME='gaussdb';
   
   

   SELECT COUNT(*) FROM PG_STAT_ACTIVITY WHERE DATNAME='gaussdb';
   
   

   SELECT COUNT(*) FROM PG_STAT_ACTIVITY;
    count
   -------
        10
   (1 row)