系统视图pg_locks

系统函数pg_lock_status

印象中好像没有系统表 区分的话 你可以看有一个列mode

postgres=# select locktype, relname,mode  from pg_locks,pg_class where pg_locks.relation = pg_class.oid;
 locktype |              relname              |      mode       
----------+-----------------------------------+-----------------
 relation | pg_class_tblspc_relfilenode_index | AccessShareLock
 relation | pg_class_relname_nsp_index        | AccessShareLock
 relation | pg_class_oid_index                | AccessShareLock
 relation | pg_class                          | AccessShareLock
 relation | pg_locks                          | AccessShareLock
 relation | db_user_pkey                      | RowShareLock
 relation | db_user                           | RowShareLock
(7 rows)
复制