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:
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:
1 2 3 4 5 6 7 |
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) |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot