geunho/pg_stat_activity.sql

Created May 2, 2022 09:56

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/geunho/dbebcb8cc9ba70a8fa52dc187b54e0a0.js"></script>
Save geunho/dbebcb8cc9ba70a8fa52dc187b54e0a0 to your computer and use it in GitHub Desktop.

Download ZIP

실행중인, blocking된 쿼리 목록 조회

Raw

pg_stat_activity.sql

	select pid,
	usename,
	pg_blocking_pids(pid) as blocked_by,
	query as blocked_query
	from pg_stat_activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment