Skip to content

Instantly share code, notes, and snippets.

@steevehook

steevehook/locks.sql

Created April 1, 2024 02:41
Show Gist options
  • Save steevehook/b78a4813e6cb9db211991b1bc50e61cd to your computer and use it in GitHub Desktop.
Save steevehook/b78a4813e6cb9db211991b1bc50e61cd to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. steevehook created this gist Apr 1, 2024.
    22 changes: 22 additions & 0 deletions locks.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,22 @@
    SELECT
    pg_stat_activity.query,
    pg_locks.locktype,
    pg_locks.mode,
    pg_locks.granted
    FROM
    pg_locks
    JOIN
    pg_stat_activity
    ON
    pg_locks.pid = pg_stat_activity.pid
    JOIN
    pg_class
    ON
    pg_locks.relation = pg_class.oid
    WHERE
    pg_class.relname = 'table-name';

    SELECT pg_terminate_backend(pg_stat_activity.pid)
    FROM pg_stat_activity
    WHERE pg_stat_activity.datname = 'database-name'
    AND pid <> pg_backend_pid();