Summary
pg_safe_snapshot_blocking_pids is a PostgreSQL built-in function in the Array Functions group. PostgreSQL’s system catalog (pg_proc) describes it as: “get array of PIDs of sessions blocking specified backend PID from acquiring a safe snapshot”.
Signature
pg_safe_snapshot_blocking_pids(integer) → integer[]Argument and return types are taken from the pg_proc catalog; internal type names are shown using their readable SQL spellings (for example int4 is shown as integer). (Derived from the catalog — see the linked reference for the canonical documentation.)
Classification
- Category: Array Functions
- Kind: Function
- Volatility: VOLATILE — Marked VOLATILE — its result can change even within a single statement (for example, it may depend on time, sequences or the current session).
- Returns:
integer[]
Example
Illustrative form (replace placeholder values with your own data):
SELECT pg_safe_snapshot_blocking_pids(42);The example above is illustrative and is meant to show calling syntax only; consult the linked PostgreSQL documentation for exact semantics, edge cases and accepted argument combinations.
Version applicability
pg_safe_snapshot_blocking_pids is present across the surveyed releases (PostgreSQL 15, 16, 17, 18, 19). On older major versions, behaviour may differ in detail — always check the documentation for the version you run.
Related & references
Reference: PostgreSQL documentation — Array Functions.