Skip to content

Instantly share code, notes, and snippets.

@dreamlu

dreamlu/lock.sql

Created April 23, 2023 06:56
Show Gist options
  • Save dreamlu/eb12ee9ea6119f254821cca3221b8730 to your computer and use it in GitHub Desktop.
Save dreamlu/eb12ee9ea6119f254821cca3221b8730 to your computer and use it in GitHub Desktop.
Download ZIP
pg 锁住/解锁
Raw
lock.sql
select pid, query
from pg_stat_activity
where datname = 'table'
and wait_event_type = 'Lock';
select 'select pg_cancel_backend( ''' || pid || ''');' pid
from pg_stat_activity
where datname = 'table'
and wait_event_type = 'Lock';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment