GV_SESSION
GV_SESSION view describes the information related to the current user's queries. The columns save information about the last query.
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 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. |
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. Its value can be:
|
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:
|
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.