postgresql查看锁表的进程

最新推荐文章于 2025-06-30 22:46:07 发布

原创最新推荐文章于 2025-06-30 22:46:07 发布 · 825 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#postgresql #数据库

本文解析了如何通过SQL查询获取特定表的名称、所属数据库、锁定进程信息、客户端地址及锁模式，重点在于针对'tablename'的表级锁定情况的详细查看。

select pg_class.relname AS 表名,pg_database.datname AS 数据库,pg_locks.pid as pg进程,client_addr || ‘:’ || client_port as 客户端地址,mode,
pg_stat_activity.application_name as 程序名称 from pg_locks,pg_class,pg_database,pg_stat_activity
where pg_locks.relation = pg_class.oid and pg_class.reltype != 0 and pg_locks.database = pg_database.oid and pg_locks.pid = pg_stat_activity.pid
and pg_class.relname = ‘tablename’;