Product DocumentationAppearance
sys.log_session
This view records the history of individual database sessions.
| Column Name | Data Type | Description |
|---|---|---|
| session_id | bigint | Unique ID of the session. |
| application_name | varchar(256) | Name of the application that is running the session, such as ybsql, ym, ybload, or ybunload. You will also see internal application names such as yb-lime. (Note that an unload session reports ybunload as the application name while it is running. When the unload is complete, the view reports yb-lime as the application name.) |
| client_hostname | varchar(256) | Client host name, if available. |
| client_ip_address | varchar(256) | Client IP address. |
| database_id | bigint | Unique ID for the database. |
| user_id | bigint | Unique ID for the database user. |
| start_time | timestamptz | Timestamp for when the session started. |
| end_time | timestamptz | Timestamp for when the session ended, if it is not still running. |
| process_id | bigint | Unique process ID for the session. Used internally for debugging purposes. |
| secure_connection | boolean | Whether the database connection is secure (SSL). |
| last_statement | timestamptz | When the last SQL statement was started. This column is NULL if the session did not execute any statements. |
| state | varchar(256) | If the session was shut down because of idle_in_transaction_timeout, the state is 25P03. If the session was shut down because of idle_session_timeout, the state is 25P04. Other states are idle and active. See also Managing Idle Sessions. |
| secure_details | varchar(256) | SSL version, cipher, and key size. |
Example
Join sys.log_session to sys.database to return information about ybsql sessions that lasted longer than 1 second:
premdb=# select sd.name dbname, sd.database_id, user_id, session_id, application_name, end_time-start_time duration
from sys.database sd, sys.log_session sls where sd.database_id=sls.database_id
and application_name ='ybsql' and duration>'1 sec'
order by sd.database_id, session_id;
dbname | database_id | user_id | session_id | application_name | duration
------------------+-------------+---------+------------+------------------+-----------------
yellowbrick_test | 16588 | 16590 | 17232 | ybsql | 00:00:11.774066
yellowbrick_test | 16588 | 16590 | 18279 | ybsql | 00:00:19.486412
yellowbrick_test | 16588 | 16590 | 19941 | ybsql | 00:00:30.966864
yellowbrick_test | 16588 | 16590 | 23253 | ybsql | 00:18:08.167864
premdb | 26259 | 26261 | 23285 | ybsql | 00:00:35.007097
premdb | 26259 | 26261 | 23445 | ybsql | 00:00:54.950788
(6 rows)