blocking 체크

blocking session 모니터링

 

SELECT
          datname,
          usename,
          application_name,
          now()-backend_start AS "Session duration",
          pid,
          wait_event,
          wait_event_type,
          query
        FROM
          pg_stat_activity
        WHERE
          state='active'
        AND wait_event IS NOT NULL;