数据库锁表，解锁

 

SELECT T.PID,

    T.STATE,

    T.QUERY,

    T.WAIT_EVENT_TYPE,

    T.WAIT_EVENT,

    T.QUERY_START

FROM PG_STAT_ACTIVITY T

WHERE T.DATNAME = 'gpadmin' AND T.WAIT_EVENT_TYPE = 'Lock';

 

    select *

    from pg_stat_activity

    where pid in (

      select pid from pg_locks l

      join pg_class t on l.relation = t.oid

      and t.relkind = 'r'

    );

 

select pid, state, usename, query, query_start

from pg_stat_activity

where pid in ( select pid from pg_locks l ,pg_class t

        where l.relation = t.oid and t.relkind = 'r' and t.relname =  'ods_declaration_goodsshipment_i');

 

select pid from pg_locks l join pg_class t on l.relation = t.oid

where t.relkind = 'r' and t.relname = 'ods_declaration_goodsshipment_i';