LOCAL_ACTIVE_SESSION
LOCAL_ACTIVE_SESSION displays samples in the ACTIVE SESSION PROFILE memory on the current node.
Table 1 LOCAL_ACTIVE_SESSION columns
Name | Type | Description |
---|
sampleid | bigint | Sample ID |
sample_time | timestamp with time zone | Sampling time |
need_flush_sample | boolean | Specifies whether the sample needs to be flushed to disks. |
databaseid | oid | Database ID |
thread_id | bigint | Thread ID |
sessionid | bigint | Session ID |
start_time | timestamp with time zone | Start time of a session |
event | text | Event name |
lwtid | integer | Lightweight thread ID of the current thread |
psessionid | bigint | Parent thread of the streaming thread |
tlevel | integer | Level of the streaming thread, which corresponds to the level (id) of the execution plan |
smpid | integer | Concurrent thread ID in SMP execution mode |
userid | oid | ID of a session user |
application_name | text | Name of an application |
client_addr | inet | IP address of a client |
client_hostname | text | Name of a client |
client_port | integer | TCP port number used by a client to communicate with the backend |
query_id | bigint | debug query id |
unique_query_id | bigint | unique query id |
user_id | oid | User ID in the key of the unique query |
cn_id | integer | CN ID. On a DN, this parameter indicates the ID of the node that delivers the unique SQL statement, that is, the value of cn_id in the key of the unique query. |
unique_query | text | Standardized text string of the unique SQL statement |
locktag | text | Information of a lock that the session waits for, which can be parsed using locktag_decode |
lockmode | text | Mode of a lock that the session waits for |
block_sessionid | bigint | Blocks a session from obtaining the session ID of a lock if the session is waiting for the lock. |
final_block_sessionid | bigint | ID of the blocked session at the source end |
wait_status | text | Provides more details about an event column. |
global_sessionid | text | Global session ID |
openGauss 2024-11-04 03:25:14