{"Entry":{"collection":"func","key":"pg-blocking-pids","name":"pg_blocking_pids","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"9.5","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"9.6"},{"descriptions_changed":true,"doc_overhaul":false,"from":"9.6","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"10"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"}],"content_hash":"96b38c7ccae747d906340d5098bd3c9a7d1176e7641f2f8877a985522bd0c7d3","derived_content_hash":"3c245b25a219ef07245c9eef3b354cf05db29677777e0ad3592430af19a1de67","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:4357242892448bd6ddc868cc4ac1cf9a51357ab7633266008b3167e39f99eed1","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"9.6","group":"info","group_label":"System Information Functions And Operators","groups":["info"],"imported_at":"2026-09-27T17:57:29.121968+08:00","last_version":"20","name":"pg_blocking_pids","name_key":"pg_blocking_pids","position":28036,"present_in":["9.6","10","11","12","13","14","15","16","17","18","19","20"],"repair_provenance":{"original_source_revision":"b7bd9cda","receipt_sha256":"0b7cb72db33582a7793d417c14ad3850f7a86f933fa22576d47f084ce5d9c332","repair":"wiki-repair-20261023"},"signature":"pg_blocking_pids ( integer ) → integer[]","signature_count":1,"slug":"pg-blocking-pids","source_rev":"wiki-repair-20261023:4357242892448bd6ddc868cc4ac1cf9a51357ab7633266008b3167e39f99eed1","summary":"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.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-blocking-pids","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-blocking-pids","SourceRevision":"wiki-repair-20261023:4357242892448bd6ddc868cc4ac1cf9a51357ab7633266008b3167e39f99eed1","Facts":{"description":"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.","description_html":"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.","description_zh":"返回一个数组，包含阻止指定进程 ID 对应的服务器进程获取锁的会话进程 ID；如果不存在这样的服务器进程，或该进程未被阻塞，则返回空数组。","description_zh_html":"返回一个数组，包含阻止指定进程 ID 对应的服务器进程获取锁的会话进程 ID；如果不存在这样的服务器进程，或该进程未被阻塞，则返回空数组。","doc":{"anchor":"FUNCTIONS-INFO-SESSION-TABLE","file":"functions-info.html","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","slug":"18"},"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"},"group":"info","group_label":"系统信息函数和操作符","lang":"en","layout":"table-new","pages":["functions-info.html"],"prose_only":false,"signatures":[{"description":"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.","description_html":"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.","description_zh":"返回一个数组，包含阻止指定进程 ID 对应的服务器进程获取锁的会话进程 ID；如果不存在这样的服务器进程，或该进程未被阻塞，则返回空数组。","description_zh_html":"返回一个数组，包含阻止指定进程 ID 对应的服务器进程获取锁的会话进程 ID；如果不存在这样的服务器进程，或该进程未被阻塞，则返回空数组。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_blocking_pids\u003c/code\u003e ( \u003ccode class=\"type\"\u003einteger\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003einteger[]\u003c/code\u003e","returns":"integer[]","text":"pg_blocking_pids ( integer ) → integer[]","zh_from":"same-version-manual"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-info.html","sha256":"7c33185e79430cfbda432dc4db277115c7ac846afccadfcf904ceb1bf2aa1ba5"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-INFO-SESSION-TABLE","file":"functions-info.html","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-blocking-pids","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_blocking_pids","Summary":"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.","BodyHTML":"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.","SourceRevision":"wiki-repair-20261023:4357242892448bd6ddc868cc4ac1cf9a51357ab7633266008b3167e39f99eed1","ContentHash":"c9a67b85f4acbb42453891439964aae3ef2b9add045bf3ae38f3f9389ae212d2","Payload":{"description":"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.","description_html":"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":[{"description":"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.","description_html":"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.","description_zh":"返回一个数组，包含阻止指定进程 ID 对应的服务器进程获取锁的会话进程 ID；如果不存在这样的服务器进程，或该进程未被阻塞，则返回空数组。","description_zh_html":"返回一个数组，包含阻止指定进程 ID 对应的服务器进程获取锁的会话进程 ID；如果不存在这样的服务器进程，或该进程未被阻塞，则返回空数组。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_blocking_pids\u003c/code\u003e ( \u003ccode class=\"type\"\u003einteger\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003einteger[]\u003c/code\u003e","returns":"integer[]","text":"pg_blocking_pids ( integer ) → integer[]","zh_from":"same-version-manual"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"91f18649fa9b4c73ed0c53ffcb931de5340e73f83b35fc9485270ef298266f67","Text":"pg_blocking_pids ( integer ) → integer[]","Returns":"integer[]","Payload":{"description":"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.","description_html":"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.","description_zh":"返回一个数组，包含阻止指定进程 ID 对应的服务器进程获取锁的会话进程 ID；如果不存在这样的服务器进程，或该进程未被阻塞，则返回空数组。","description_zh_html":"返回一个数组，包含阻止指定进程 ID 对应的服务器进程获取锁的会话进程 ID；如果不存在这样的服务器进程，或该进程未被阻塞，则返回空数组。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_blocking_pids\u003c/code\u003e ( \u003ccode class=\"type\"\u003einteger\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003einteger[]\u003c/code\u003e","returns":"integer[]","text":"pg_blocking_pids ( integer ) → integer[]","zh_from":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}