Health and performance · stop 6 of 13
find_blocking_locks
Finds which queries are stuck and who is blocking them.
Works in read modeTool sets: dba · full
You might ask
“Why is the checkout update hanging?”
Your assistant may call find_blocking_locks to answer.
How it works
- Pairs each waiting query with the pid and query holding the lock it needs. To stop one, see
terminate_query.
Parameters
None. Call it as it is.
What your assistant reads
The description nexql-mcp sends with the tool. It's how the assistant decides when to use it.
Find lock contention: which queries are blocked waiting on locks and which pids/queries are blocking them.