[DATABASE/POSTGRESQL] 모든 쿼리 조회하기

icodebroker POSTGRESQL 2024-06-18

■ 모든 쿼리를 조회하는 방법을 보여준다.

▶ 예제 코드 (SQL)


SELECT
    SUBSTR(QUERY, 1, 100) QUERY
   ,BACKEND_TYPE
   ,APPLICATION_NAME
   ,QUERY_START
   ,WAIT_EVENT_TYPE
   ,WAIT_EVENT
   ,STATE
FROM PG_STAT_ACTIVITY;

1

2

3

4

5

6

7

8

9

10

11

SELECT

SUBSTR(QUERY, 1, 100) QUERY

,BACKEND_TYPE

,APPLICATION_NAME

,QUERY_START

,WAIT_EVENT_TYPE

,WAIT_EVENT

,STATE

FROM PG_STAT_ACTIVITY;