PostgreSql查询正在执行的SQL和查询执行耗时的SQL

select * from pg_stat_activity where datname='schema名称';

select pg_cancel_backend(pid);

select  pg_terminate_backend(pid)；

create extension pg_stat_statements;
select pg_stat_reset();
select pg_stat_statements_reset();

select * from pg_stat_statements order by total_time desc limit 5;

select * from pg_stat_statements order by shared_blks_hit+shared_blks_read desc limit 5;