PostgreSQL: which process is causing locks to be held?

select distinct pid from pg_locks where granted and relation in (select relation from pg_locks where not granted);