postgresql查看锁表的进程

最新推荐文章于 2024-06-23 14:17:39 发布

森海北屿I

最新推荐文章于 2024-06-23 14:17:39 发布

阅读量671

点赞数

文章标签： postgresql 数据库

本文链接：https://blog.csdn.net/lornman_q/article/details/125709138

版权

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’;