postgresql——数据库性能视图

select state,usename,datname,pid,wait_event_type, wait_event,substr(query ,1,50), xact_start, query_start,query from pg_stat_activity where state <>'idle';