GV_SESSION

GV_SESSION view describes the information related to the current user's queries. The columns save the information about the last query.

**Table 1** GV_SESSION columns
Name	Type	Description
SID	bigint	Session ID
SERIAL#	integer	Sequence number of the active backend thread, which is 0 in GaussDB.
SCHEMANAME	name	Name of the user logged in to the backend.
USER#	oid	OID of the user that has logged in to the backend thread. (0 if the backend thread is a global auxiliary thread)
USERNAME	name	Username of the user that has logged in to the backend thread. (null if the backend thread is a global auxiliary thread)
MACHINE	text	Host name of the connected client, as reported by a reverse DNS lookup of client_addr. This column will be non-null only for IP connections and only when log_hostname is enabled.
SQL_ID	bigint	ID of a query.
CLIENT_INFO	text	Host name of the connected client, as reported by a reverse DNS lookup of client_addr. This column will be non-null only for IP connections and only when log_hostname is enabled.
EVENT	text	Queuing status of a statement. Possible values are: ● waiting in queue: The statement is in the queue. ● null: The statement is running.
SQL_EXEC_START	timestamp with time zone	Time when the currently active query was started, or if state is not active, when the last query was started.
PROGRAM	text	Name of the application connected to the backend.
STATUS	text	Overall status of this backend. Possible values are: ● active: The backend is executing a query. ● idle: The backend is waiting for a new client command. ● idle in transaction: The backend is in a transaction, but there is no statement being executed in the transaction. ● idle in transaction (aborted): The backend is in a transaction, but there are statements failed in the transaction. ● fastpath function call: The backend is executing a fast-path function. ● disabled: This state is reported if track_activities is disabled in this backend.