杀pid有两个函数：

• pg_terminate_backend()
• pg_cancel_backend()

以 pg_terminate_backend() 函数为例：

select pg_terminate_backend(pid) from pg_stat_activity where条件
复制

建议拼接SQL查杀，查杀之前确认下杀了哪些内容。select 'select pg_terminate_backend(' ||pid||');' as kill,usename,datname,current_query,now()-query_start as ctime from pg_stat_activity where now()-query_start > 300 and current_query <> '<IDLE>';

select 'select pg_terminate_backend(' ||pid||');' as kill,usename,datname,current_query,now()-query_start as ctime from pg_stat_activity where now()-query_start > 300 and current_query <> '';