■ 모든 잠금 조회하기

------------------------------------------------------------------------------------------------------------------------

 

SELECT

    T.RELNAME

   ,L.LOCKTYPE

   ,L.PAGE

   ,L.VIRTUALTRANSACTION

   ,L.PID

   ,L.MODE

   ,L.GRANTED

FROM  PG_LOCKS           L

     ,PG_STAT_ALL_TABLES T

WHERE L.RELATION = T.RELID

ORDER BY L.RELATION ASC;

 

------------------------------------------------------------------------------------------------------------------------

Posted by 사용자 icodebroker
TAG

댓글을 달아 주세요