Метрики на основе представления pg_locks:
pg_locks
postgresql.locks.all
postgresql.locks.waiting
postgresql.locks.waiting_max_duration_milliseconds