pg_blocking_pids ( integer ) → integer[]Returns an array of the process ID(s) of the sessions that are blocking the server process with the specified process ID from acquiring a lock, or an empty array if there is no such server process or it is not blocked.
FUNCTIONS / SYSTEM INFORMATION FUNCTIONS AND OPERATORS
pg_blocking_pids
Read PG 18 manual ↗Returns an array of the process ID(s) of the sessions that are blocking the server process with the specified process ID from acquiring a lock, or an empty array if there is no such server process or it is not blocked.
Signatures & examples
Version history 3
- PG 12 → 13changed
- PG 9.6 → 10changed
- PG 9.5 → 9.6added
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source