Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-3.x)/ System Catalogs and System Views/ System Views/ GV_SESSION
Updated on 2025-08-19 GMT+08:00
View PDF

GV_SESSION

GV_SESSION describes information about all current sessions. Only administrators can access this view. Common users can access this 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, which is 0 in GaussDB.

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 who has logged in to the backend thread. Its value is 0 if the backend thread is a global auxiliary thread.

username

name

Name of the user logged in to the backend thread. 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

ID of a query.

client_info

text

Client information.

event

text
Queuing status of a statement. Its value can be:
  • waiting in queue: The statement is in the queue.
  • Empty: 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. Its value can be:
  • 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

date

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

date

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.
Parent topic: System Views