HomeMogDBMogDB StackUqbar
v2.1

Documentation:v2.1

Supported Versions:

Other Versions:

LOCAL_ACTIVE_SESSION

The LOCAL_ACTIVE_SESSION view displays the samples in the ACTIVE SESSION PROFILE memory on this node.

表 1 LOCAL_ACTIVE_SESSION field

Name Type Description
sampleid bigint Sample ID.
sample_time timestamp with time zone The time of sampling.
need_flush_sample boolean Whether the sample needs to be refreshed on disk.
databaseid oid Database ID.
thread_id bigint Thread ID.
sessionid bigint Session ID.
start_time timestamp with time zone The start time of the session.
event text The specific event name.
lwtid integer The lightweight thread ID of the current thread.
psessionid bigint The parent thread of the streaming thread.
tlevel integer The level of streaming threads. Correspond to the level (ID) of the execution plan.
smpid integer The parallel ID of the parallel thread in the smp execution mode.
userid oid Session user ID。
application_name text The name of the application.
client_addr inet The address of the client.
client_hostname text The name of the client.
client_port integer The TCP port number used by the client to communicate with the backend.
query_id bigint debug query id。
unique_query_id bigint unique query id。
user_id oid The user_id in the key of the unique query.
cn_id integer cn id, on the DN, it means the ID of the node that issued the unique sql, and the cn_id in the key of the unique query.
unique_query text UniqueSQL text string after normalization.
locktag text The session waiting lock information can be parsed by locktag_decode.
lockmode text The session waits for the lock mode.
block_sessionid bigint If the session is waiting for a lock, block the session ID from acquiring the lock.
final_block_sessionid bigint Indicates the source blocking session ID.
wait_status text Describe more detailed information about the event column.
global_sessionid text Global session ID.
Copyright © 2011-2024 www.enmotech.com All rights reserved.