Remove all blocking lock from Postgresql

rm_locks.sql

//view all blocking locks
SELECT
    *
FROM
    pg_locks pl
    LEFT JOIN pg_stat_activity psa ON pl.pid = psa.pid 
WHERE
    wait_event_type = 'Lock' AND pl.pid <> pg_backend_pid()
ORDER BY
    query_start ASC 
    LIMIT 3000
    
//Clear all blocking locks    
SELECT
    pg_terminate_backend ( pl.pid ) 
FROM
    pg_locks pl
    LEFT JOIN pg_stat_activity psa ON pl.pid = psa.pid 
WHERE
    wait_event_type = 'Lock' 
ORDER BY
    query_start ASC 
    LIMIT 3000