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

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.