GV_SESSION

GV_SESSION displays all session information about the current session. Only administrators can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.

**Table 1** GV_SESSION columns
Name	Type	Description
inst_id	numeric	Not supported. Its value is NULL.
saddr	raw	Not supported. Its value is NULL.
sid	bigint	Session ID.
serial#	integer	Sequence number of the active backend thread.
audsid	numeric	Not supported. Its value is NULL.
paddr	raw	Not supported. Its value is NULL.
schema#	numeric	Not supported. Its value is NULL.
schemaname	name	Name of the user logged in to the backend.
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.
command	numeric	Not supported. Its value is NULL.
ownerid	numeric	Not supported. Its value is NULL.
taddr	character varying(16)	Not supported. Its value is NULL.
lockwait	character varying(16)	Not supported. Its value is NULL.
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	SQL OID.
client_info	text	Client information.
event	text	Queuing status of a statement. The value must be one of the following: waiting in queue: The statement is in the queue. Empty: The statement is running.
sql_exec_start	timestamp with time zone	Start time of SQL statement execution.
program	text	Name of the application connected to the backend.
status	text	Overall status of this backend. The value must be one of the following: 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.
server	character varying(9)	Not supported. Its value is NULL.
pdml_status	character varying(8)	Specifies whether to enable a DML parallel execution in the current session.
port	numeric	Port number of the current session.
process	character varying(24)	Process ID of the current session.
logon_time	timestamp(0) without time zone	Login time of the current session.
last_call_et	integer	Duration when the status of the current session changes last time.
osuser	character varying(128)	Not supported. Its value is NULL.
terminal	character varying(30)	Not supported. Its value is NULL.
type	character varying(10)	Not supported. Its value is NULL.
sql_address	raw	Not supported. Its value is NULL.
sql_hash_value	numeric	Not supported. Its value is NULL.
sql_child_number	numeric	Not supported. Its value is NULL.
sql_exec_id	numeric	Not supported. Its value is NULL.
prev_sql_addr	raw	Not supported. Its value is NULL.
prev_hash_value	numeric	Not supported. Its value is NULL.
prev_sql_id	character varying(13)	Not supported. Its value is NULL.
prev_child_number	numeric	Not supported. Its value is NULL.
prev_exec_start	timestamp(0) without time zone	Not supported. Its value is NULL.
prev_exec_id	numeric	Not supported. Its value is NULL.
plsql_entry_object_id	numeric	Not supported. Its value is NULL.
plsql_entry_subprogram_id	numeric	Not supported. Its value is NULL.
plsql_object_id	numeric	Not supported. Its value is NULL.
plsql_subprogram_id	numeric	Not supported. Its value is NULL.
module	character varying(64)	Not supported. Its value is NULL.
module_hash	numeric	Not supported. Its value is NULL.
action	character varying(64)	Not supported. Its value is NULL.
action_hash	numeric	Not supported. Its value is NULL.
fixed_table_sequence	numeric	Not supported. Its value is NULL.
row_wait_obj#	numeric	Not supported. Its value is NULL.
row_wait_file#	numeric	Not supported. Its value is NULL.
row_wait_block#	numeric	Not supported. Its value is NULL.
row_wait_row#	numeric	Not supported. Its value is NULL.
top_level_call#	numeric	Not supported. Its value is NULL.
pdml_enabled	character varying(3)	Not supported. Its value is NULL.
failover_type	character varying(13)	Not supported. Its value is NULL.
failover_method	character varying(10)	Not supported. Its value is NULL.
failed_over	character varying(3)	Not supported. Its value is NULL.
resource_consumer_group	character varying(32)	Not supported. Its value is NULL.
pddl_status	character varying(8)	Not supported. Its value is NULL.
pq_status	character varying(8)	Not supported. Its value is NULL.
current_queue_duration	numeric	Not supported. Its value is NULL.
client_identifier	character varying(64)	Not supported. Its value is NULL.
blocking_session_status	character varying(11)	Not supported. Its value is NULL.
blocking_instance	numeric	Not supported. Its value is NULL.
blocking_session	numeric	Not supported. Its value is NULL.
final_blocking_session_status	character varying(11)	Not supported. Its value is NULL.
final_blocking_instance	numeric	Not supported. Its value is NULL.
final_blocking_session	numeric	Not supported. Its value is NULL.
seq#	numeric	Not supported. Its value is NULL.
event#	numeric	Not supported. Its value is NULL.
p1text	character varying(64)	Not supported. Its value is NULL.
p1	numeric	Not supported. Its value is NULL.
p1raw	raw	Not supported. Its value is NULL.
p2text	character varying(64)	Not supported. Its value is NULL.
p2	numeric	Not supported. Its value is NULL.
p2raw	raw	Not supported. Its value is NULL.
p3text	character varying(64)	Not supported. Its value is NULL.
p3	numeric	Not supported. Its value is NULL.
p3raw	raw	Not supported. Its value is NULL.
wait_class_id	numeric	Not supported. Its value is NULL.
wait_class#	numeric	Not supported. Its value is NULL.
wait_class	character varying(64)	Not supported. Its value is NULL.
wait_time	numeric	Not supported. Its value is NULL.
seconds_in_wait	numeric	Not supported. Its value is NULL.
state	character varying(19)	Not supported. Its value is NULL.
wait_time_micro	numeric	Not supported. Its value is NULL.
time_remaining_micro	numeric	Not supported. Its value is NULL.
time_since_last_wait_micro	numeric	Not supported. Its value is NULL.
service_name	character varying(64)	Not supported. Its value is NULL.
sql_trace	character varying(8)	Not supported. Its value is NULL.
sql_trace_waits	character varying(5)	Not supported. Its value is NULL.
sql_trace_binds	character varying(5)	Not supported. Its value is NULL.
sql_trace_plan_stats	character varying(10)	Not supported. Its value is NULL.
session_edition_id	numeric	Not supported. Its value is NULL.
creator_addr	raw	Not supported. Its value is NULL.
creator_serial#	numeric	Not supported. Its value is NULL.
ecid	character varying(64)	Not supported. Its value is NULL.
sql_translation_profile_id	numeric	Not supported. Its value is NULL.
pga_tunable_mem	numeric	Not supported. Its value is NULL.
shard_ddl_status	character varying(8)	Not supported. Its value is NULL.
con_id	numeric	Not supported. Its value is NULL.
external_name	character varying(1024)	Not supported. Its value is NULL.
plsql_debugger_connected	character varying(5)	Not supported. Its value is NULL.