GaussDB-GV_SESSION
GV_SESSION displays information about all current sessions. Only administrators can access this view. Common users can access the view only after being authorized. This view exists in both the PG_CATALOG and SYS schemas. When the thread pool is enabled (enable_thread_pool is set to on), all session information is displayed. When the thread pool is disabled (enable_thread_pool is set to off), the sessions connected by users are not displayed. For details about the columns, see Table 1.
| 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 that has logged in to the backend thread. (0 if the background 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 | ID of a query. |
| 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 | Time when the currently active query was started, or time when the last query was started if the value of state is not active. | | 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 | date | Login time of the current session | | last_call_et | integer | Duration when the status of the current session changes last time. | | osuser | text | OS username of the server. | | 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 | text | Name of the running module, which is set by calling DBE_APPLICATION_INFO.SET_MODULE. | | module_hash | numeric | Not supported. Its value is NULL. | | action | text | Name of the current operation in the current module, which is set by calling DBE_APPLICATION_INFO.SET_MODULE or DBE_APPLICATION_INFO.SET_ACTION. | | 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. |
更多详情请参考GaussDB 文档中心：doc.hcs.huawei.com/db/zh-cn/ga…
