첨부 실행 코드는 나눔고딕코딩 폰트를 사용합니다.
728x90
반응형
728x170
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;
728x90
반응형
그리드형(광고전용)
Posted by icodebroker

댓글을 달아 주세요