[PostgreSQL]Table Lock查詢/Kill

 SELECT t.schemaname,
    t.relname,
    l.locktype,
    l.page,
    l.virtualtransaction,
    l.pid,
    l.mode,
    l.granted
   FROM pg_locks l
   JOIN pg_stat_all_tables t ON l.relation = t.relid
  WHERE t.schemaname <> 'pg_toast'::name AND t.schemaname <> 'pg_catalog'::name
  ORDER BY t.schemaname, t.relname;

What I did is first check what are the running processes by
SELECT * FROM pg_stat_activity WHERE state = 'active';

Find the process you want to kill, then type:
SELECT pg_cancel_backend(<pid of the process>)

If the process cannot be killed, try:
SELECT pg_terminate_backend(<pid of the process>)
https://wiki.postgresql.org/wiki/Lock_Monitoring