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

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 * from pgxc_get_lock_conflicts();
                                             pgxc_get_lock_conflicts

-----------------------------------------------------------------------------------------------------------------
 (relation,cn_5001,gaussdb,u1,test,,,,,omm,648406,,,"<insufficient privilege>",140651661784832,ExclusiveLock,f,2024-10-29 17:24:13.425672+08,)
(1 row