pg_locks和pg_stat_activy确定阻塞语句

granted为f表示pid=1155840被阻塞

查询存在锁的数据表

select a.locktype,a.database,a.pid,a.mode,a.relation,b.relname ,sa.*

from pg_locks a

join pg_class b on a.relation = b.oid

inner join pg_stat_activity sa on a.pid=sa.pid;

通过pg_blocking_pids(1155840)查询持有锁的进程

通过pg_stat_activity视图查看进程对应的语句。

select * from pg_stat_activity where pid in(1156669,1155840);