Find PSQL Locks #psql

psql_locks.sql

select pid, query_start, state, query from pg_stat_activity where pid in (
    select pid from pg_locks where granted = true and relation in (
        select distinct relation from pg_locks where granted = false)
    );