HomeMogDBMogDB StackUqbar
v3.0

Documentation:v3.0

Supported Versions:

THREAD_WAIT_STATUS

THREAD_WAIT_STATUS allows you to test the block waiting status of the backend thread and auxiliary thread in the current instance. For details about events, see Table 2, Table 3, Table 4, and Table 5 in PG_THREAD_WAIT_STATUS.

Table 1 THREAD_WAIT_STATUS columns

Name Type Description
node_name text Database process name
db_name text Database name
thread_name text Thread name
query_id bigint Query ID. The value of this column is the same as that of debug_query_id.
tid bigint Thread ID of the current thread
sessionid bigint Session ID
lwtid integer Lightweight thread ID of the current thread
psessionid bigint Parent thread of the streaming thread
tlevel integer Level of the streaming thread
smpid integer Concurrent thread ID
wait_status text Waiting status of the current thread. For details about the waiting status, see Table 2 in PG_THREAD_WAIT_STATUS.
wait_event text If wait_status is acquire lock, acquire lwlock, or wait io, this column describes the lock, lightweight lock, and I/O information, respectively. If wait_status is not any of the three values, this column is empty.
Copyright © 2011-2024 www.enmotech.com All rights reserved.