1. ๋ฝ ํ์ธ ์ฟผ๋ฆฌSELECT t.relname, l.locktype, page, virtualtransaction, pid, mode, grantedFROM pg_locks l, pg_stat_all_tables tWHERE l.relation = t.relidORDER BY relation ASC;์ด๋ค ํ ์ด๋ธ์ ์ด๋ค PID๊ฐ ๋ฝ ๊ฑธ์๋์ง ํ์ธ ๊ฐ๋ฅ ํ์ฌ ํ๋์ค์ธ ์ธ์ ๋ณด๊ธฐ (pg_stat_activity๋ ๊ฐ์ด๋ณด๋ฉด์ ํ์ธ)SELECT pid, state, query, wait_event_type, wait_eventFROM pg_stat_activityWHERE state != 'idle'; 2. ๋๊ฐ ๋๊ตฌ๋ฅผ ๋ง๊ณ ์๋์ง ํ์ธSE..