pg数据库执行进程相关操作命令

SELECT pid, query, query_start

FROM pg_stat_activity

WHERE state = 'active';

 // 查询正在执行的sql进程

 

SELECT

a.pid,

a.query,

a.query_start,

l.locktype,

l.mode,

l.relation::regclass AS locked_table

FROM

pg_stat_activity a

JOIN

pg_locks l ON a.pid = l.pid

WHERE

a.state = 'active';

// 查询数据库执行进程以及锁信息

SELECT pg_terminate_backend(pid);

// 关闭某个进程ID对应的进程