pg_safe_snapshot_blocking_pids ( integer ) → 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 safe snapshot, or an empty array if there is no such server process or it is not blocked.
pg_safe_snapshot_blocking_pids
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 safe snapshot, or an empty array if there is no such server process or it is not blocked.
English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- group
- info
- group label
- 系统信息函数和操作符
- lang
- en
- layout
- table-new
- pages
- functions-info.html
- prose only
- false
Definition PG 18
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 safe snapshot, or an empty array if there is no such server process or it is not blocked.
Signatures and overloads
Compare versions
Complete source facts
documentation revision
{"inputs":[{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","version":"18.7"},{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"f9684137c0b9fb17a691c4d905529d114472a507a007c15058f2703962b611d2","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:bf56005c05b8ae15297ea255a84ddd9cb1f3e71577f8e37933efdeab9f05379e
Text language: en · wiki-repair-20261023:bf56005c05b8ae15297ea255a84ddd9cb1f3e71577f8e37933efdeab9f05379e