kingbase-日常维护

查看用户连接信息

select datname,usename,client_addr,client_port,pid,state from sys_stat_activity;

select connections();

查看锁表监控

select database,relation,sc.relname,pid,mode,granted from sys_locks sl
left join sys_database sd on sl.database=sd.oid
left join sys_class sc on sl.relation=sc.oid
where sys_backend_pid()<>sl.pid and granted='f';

杀掉锁信息

select sys_terminate_backend(2342) from sys_stat_activity;

查看数据库IO统计信息

select * from sys_stat_database;