租户端 数据库 TDSQL PostgreSQL 版 开发指南 查看当前节点有那些会话

查看当前节点有那些会话

最近更新时间: 2024-06-12 15:06:00

select * from pg_stat_activity;

  • 查看活跃超时会话。

     select pid,client_addr,state_change,query_start,state_change,EXTRACT(EPOCH FROM(now()-query_start)),query,state,usename,application_name from pg_stat_activity where EXTRACT(EPOCH FROM (now()-query_start))>60 and state!='idle';

  • 按用户统计活跃连接数。

     select count(1),usename from pg_stat_activity where EXTRACT(EPOCH FROM (now()-query_start))>60 and state!='idle' group by usename;

  • 按客户端统计活跃连接数。

     select count(1),client_addr from pg_stat_activity where EXTRACT(EPOCH FROM (now()-query_start))>60 and state!='idle' group by client_addr;