Updated on 2024-05-07 GMT+08:00

DV_SESSIONS

DV_SESSIONS displays information about all active backend threads. By default, only the system administrator can access this view. Common users can access the view only after being authorized.

Table 1 DV_SESSIONS columns

Name

Type

Description

sid

bigint

OID of the active backend thread of the current session.

serial#

integer

Sequence number of the active backend thread, which is 0 in GaussDB.

user#

oid

OID of the user logged in to the backend thread. The OID is 0 if the backend thread is a global auxiliary thread.

username

name

Name of the user logged in to the backend process. username is null if the backend thread is a global auxiliary thread.

application_name can be identified by associating with pg_stat_get_activity().

Example:

SELECT s.*,a.application_name FROM DV_SESSIONS AS s LEFT JOIN pg_stat_get_activity(NULL) AS a ON s.sid=a.sessionid;