pg维护
1、死锁进程查看:
SELECT * FROM pg_stat_activity WHERE datname='数据库名称' and waiting=true;
pid 进程id。
2、慢查询SQL:
select datname, pid, usename, application_name, client_addr, client_port, xact_start, query_start, state_change, waiting, state, backend_xid, backend_xm
原创
2020-07-09 11:18:22 ·
1193 阅读 ·
0 评论