暂无图片
返回数说广场
olabll1
2022-07-16 来自小程序
opengauss排查当前锁占用情况的SQL: SELECT c.relkind, d.datname, c.relname, l.mode, s.query, extract(epoch FROM pg_catalog.now() - s.xact_start) AS holding_time FROM pg_locks AS l INNER JOIN pg_database AS d ON l.database = d.oid INNER JOIN pg_class AS c ON l.relation = c.oid INNER JOIN pg_stat_activity AS s ON l.pid = s.pid WHERE s.pid != pg_catalog.pg_backend_pid();
#日有所学#
0
暂无图片 1
324
分享

评论

热门数说