可以试试这个sql

select wait_event_type,wait_event,count(*) 
from pg_stat_activity 
where wait_event is not null 
group by 1,2 
order by 3 desc;