locks.sql

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();