To detect locks in PostgreSQL by using PGADMIN4:
Connect to the server that you need to monitor
- Go to the locks tab
- On the lock window check any process that has it mode as "ExclusiveLock".
If any process has this mode we can determine that there is a lock on it.