Postgresql 17查锁情况

SELECT l.pid, st.relname::varchar, l.transactionid, l.mode, l.granted ,
t.pid,t.state,t.query,t.wait_event_type,t.wait_event,t.xact_start
FROM pg_locks l
left join PG_STAT_ACTIVITY t on t.pid=l.pid
JOIN  pg_stat_user_tables st ON l.relation = st.relid
order by t.xact_start