Updated on 2025-05-29 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. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and information about a PDB is returned if this view is accessed in the PDB.

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 backend thread of the current activity, 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;