Status Information Functions

fabricsql_query_wait_status(session_id)

Description: Displays the waiting status between execution unit threads of a specified session.

Return type: record.

The returned information is as follows:

**Table 1** fabricsql_query_wait_status(session_id) columns
Column	Type	Description
actor_name	text	Actor name.
actor_id	text	Actor ID.
actor_ip	text	Actor IP address.
db_name	text	Database name.
thread_name	text	Thread name.
query_id	bigint	Query ID.
tid	bigint	ID of the current thread.
lwtid	integer	Lightweight thread ID of the current thread.
ptid	integer	Parent thread of the streaming thread.
headop	integer	Level of the streaming thread.
smpid	integer	ID of a parallel thread.
wait_status	text	Waiting status of the current thread.
wait_event	text	If wait_status is acquire lock, acquire lwlock, or wait io, this column describes the specific lock, lightweight lock, and I/O information, respectively. Otherwise, this column is empty.

Example:

   
        SELECT * FROM fabricsql_query_wait_status(139775106588720);
  actor_name  |                   actor_id                   |  actor_ip   | db_name | thread_name |     query_id      |       tid       |  lwtid  | ptid | headop | smpid | wait_status | wait_event

--------------+----------------------------------------------+-------------+---------+-------------+-------------------+-----------------+---------+------+--------+-------+-------------+-----------
-
 coordinator1 | runtime-c7010000-0000-4000-8bad-1509e41e3b67 | 10.42.0.240 |         | gsql        | 72339069014638600 | 140406720987184 | 4194244 |      |      0 |     0 | none        |
(1 row)