■ 잠금 프로세스 조회하기

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

 

SELECT

    A.DATNAME

   ,L.RELATION::REGCLASS

   ,L.TRANSACTIONID

   ,L.MODE

   ,L.GRANTED

   ,A.USENAME

   ,A.QUERY

   ,A.QUERY_START

   ,AGE(NOW(), A.QUERY_START) AS AGE

   ,A.PID

FROM PG_STAT_ACTIVITY A

JOIN PG_LOCKS         L ON L.PID = A.PID

ORDER BY A.QUERY_START;

 

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

Posted by 사용자 icodebroker
TAG

댓글을 달아 주세요