备忘录

Postgres 锁检测

SELECT  a.pid,
        a.usename,
        a.application_name,
        a.client_addr,
        a.state,
        a.query_start,
        a.query,
        l.locktype,          -- relation 表示表/索引锁，tuple 表示行锁
        l.mode,              -- AccessShareLock、RowExclusiveLock 等
        l.granted            -- true 表示已拿到，false 表示在等待
FROM    pg_locks      l
            JOIN    pg_stat_activity a ON a.pid = l.pid
where a.application_name not like '%JDBC%'
ORDER BY l.granted, l.pid;