postgresql清除慢查询

1、先查看运行的慢sql

select * from pg_stat_activity

2、清除表tianbao_db中所有的正在执行的语句

SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE datname='tianbao_db' AND pid<>pg_backend_pid();