Help Center/ GaussDB(DWS)/ SQL Syntax Reference (8.1.3.x)/ Functions and Operators/ System Information Functions/ Lock Information Function
Updated on 2024-12-19 GMT+08:00
View PDF

Lock Information Function

pgxc_get_lock_conflicts()

Description: Obtains information about conflicting locks in the cluster. When a lock is waiting for another lock or another lock is waiting for it, a lock conflict occurs.

Return type: SETOF record

Example:

1
2
3
4
5
6
 
SELECT pgxc_get_lock_conflicts();
                                             pgxc_get_lock_conflicts

-----------------------------------------------------------------------------------------------------------------
 (relation,cn_5001,gaussdb,u1,test,,,,,omm,648406,,,"<insufficient privilege>",140651661784832,ExclusiveLock,f)
(1 row