RDBMS Information - PostgreSQL - How to detect locks in postgres db
Purpose
To know how to detect locks in postgres db
Applicable in CAST Version
| Release | Yes/No |
|---|---|
| 8.3.x | ✅ |
| 8.2.x | ✅ |
Applicable RDBMS
| RDBMS | Yes/No |
|---|---|
| Oracle Server | ❌ |
| Microsoft SQL Server | ❌ |
| CSS2 | ✅ |
| CSS1 | ✅ |
Applicable Platform or
| Platform or | Yes/No |
|---|---|
Details
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.
Notes/comments