[DATABASE/POSTGRESQL] 잠금 프로세스 조회하기

■ 잠금 프로세스를 조회하는 방법을 보여준다.

▶ 예제 코드 (SQL)


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;

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;