可以通过查看 pg_stat_activity 表

SELECT * FROM pg_stat_activity WHERE datname='数据库名' and waiting='t';

或者

select pid from pg_locks where relation=（select oid from pg_class where relname='可能锁表了的表'）；