DV_SESSIONS

DV_SESSIONS displays all session information about the current session. 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 background thread of the current session
serial#	integer	Sequence number of the active background thread, which is 0 in GaussDB
user#	oid	OID of the user that has logged in to the background thread (0 if the background thread is a global auxiliary thread)
username	name	Username of the user that has logged in to the background thread. (null if the background thread is a global auxiliary thread) The 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;