{"Entry":{"collection":"catalog","key":"pg_prepared_xacts","name":"pg_prepared_xacts","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.0","order":false,"removed":[],"status":"added","to":"8.1","types":[]}],"column_count":5,"content_hash":"d0019421d1826ff8d3aa2df9009e84f592f242921e84a789a38aa7ff02db43bd","derived_content_hash":"0e9ffc3ad8e79340df33da190c931ea6a250d58b0bb89bc4ecc0caf6fb1f5af9","first_version":"8.1","imported_at":"2026-09-30T00:40:55.695251+08:00","kind":"view","last_version":"20","name":"pg_prepared_xacts","position":56,"present_in":["8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"catalog-bilingual-repair:d1211754a934eaea9470d259c9b4c4759c445a583da8706e1e91198e1656f9fd","summary":"The view pg_prepared_xacts displays information about transactions that are currently prepared for two-phase commit (see PREPARE TRANSACTION for details).","summary_zh":"视图 pg_prepared_xacts 显示当前已处于两阶段提交预备状态的事务的信息（详见 PREPARE TRANSACTION）。"}},"Definition":{"Collection":"catalog","Key":"pg_prepared_xacts","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_prepared_xacts","SourceRevision":"catalog-bilingual-repair:d1211754a934eaea9470d259c9b4c4759c445a583da8706e1e91198e1656f9fd","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Numeric transaction identifier of the prepared transaction","description_zh":"预备事务的数字事务 ID","documented":true,"documented_name":"transaction","hidden":false,"name":"transaction","not_null":false,"references":"","type":"xid","type_modifier":-1,"type_oid":28,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Global transaction identifier that was assigned to the transaction","description_zh":"分配给该事务的全局事务标识符","documented":true,"documented_name":"gid","hidden":false,"name":"gid","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Time at which the transaction was prepared for commit","description_zh":"该事务进入预备提交状态的时间","documented":true,"documented_name":"prepared","hidden":false,"name":"prepared","not_null":false,"references":"","type":"timestamptz","type_modifier":-1,"type_oid":1184,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Name of the user that executed the transaction","description_zh":"执行此事务的用户名","documented":true,"documented_name":"owner","hidden":false,"name":"owner","not_null":false,"references":"pg_authid.rolname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Name of the database in which the transaction was executed","description_zh":"执行此事务所在数据库的名称","documented":true,"documented_name":"database","hidden":false,"name":"database","not_null":false,"references":"pg_database.datname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"}],"description":"The view pg_prepared_xacts displays information about transactions that are currently prepared for two-phase commit (see PREPARE TRANSACTION for details).\n\npg_prepared_xacts contains one row per prepared transaction. An entry is removed when the transaction is committed or rolled back.","description_zh":"视图 pg_prepared_xacts 显示当前已处于两阶段提交预备状态的事务的信息（详见 PREPARE TRANSACTION）。\n\npg_prepared_xacts 为每个预备事务包含一行。事务提交或回滚时，对应条目会被移除。","description_zh_html":"\u003cp\u003e视图 pg_prepared_xacts 显示当前已处于两阶段提交预备状态的事务的信息（详见 PREPARE TRANSACTION）。\u003c/p\u003e\n\u003cp\u003epg_prepared_xacts 为每个预备事务包含一行。事务提交或回滚时，对应条目会被移除。\u003c/p\u003e","doc":{"anchor":"id-1.10.5.21.5","file":"view-pg-prepared-xacts.html","lang":"en","sha256":"5a3851958b1f132ca62a87da7c72711bd1311abedfe6a260ca61a163fea628af","slug":"18"},"kind":"view","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["transaction","gid","prepared","owner","database"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-prepared-xacts.html","sha256":"3b87ebaaf233951bc42c2a73b20636732fba9ed3de967b8f2ea96edb9c0eeb7d","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:afaad40723b598fc06742ac3382d95b0d42c288958778b1832b8f71300a9b37b","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.21.5","file":"view-pg-prepared-xacts.html","lang":"en","sha256":"5a3851958b1f132ca62a87da7c72711bd1311abedfe6a260ca61a163fea628af","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-prepared-xacts.html","sha256":"3b87ebaaf233951bc42c2a73b20636732fba9ed3de967b8f2ea96edb9c0eeb7d","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:afaad40723b598fc06742ac3382d95b0d42c288958778b1832b8f71300a9b37b","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["transaction","gid","prepared","owner","database"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_prepared_xacts","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_prepared_xacts","Summary":"The view pg_prepared_xacts displays information about transactions that are currently prepared for two-phase commit (see PREPARE TRANSACTION for details).\n\npg_prepared_xacts contains one row per prepared transaction. An entry is removed when the transaction is committed or rolled back.","BodyHTML":"\u003cp\u003eThe view pg_prepared_xacts displays information about transactions that are currently prepared for two-phase commit (see PREPARE TRANSACTION for details).\n\npg_prepared_xacts contains one row per prepared transaction. An entry is removed when the transaction is committed or rolled back.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:d1211754a934eaea9470d259c9b4c4759c445a583da8706e1e91198e1656f9fd","ContentHash":"46e9a1ed50741b8d67272a57050757f584039288fb3ff4c3b171c23686c7a564","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Numeric transaction identifier of the prepared transaction","description_zh":"预备事务的数字事务 ID","documented":true,"documented_name":"transaction","hidden":false,"name":"transaction","not_null":false,"references":"","type":"xid","type_modifier":-1,"type_oid":28,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Global transaction identifier that was assigned to the transaction","description_zh":"分配给该事务的全局事务标识符","documented":true,"documented_name":"gid","hidden":false,"name":"gid","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Time at which the transaction was prepared for commit","description_zh":"该事务进入预备提交状态的时间","documented":true,"documented_name":"prepared","hidden":false,"name":"prepared","not_null":false,"references":"","type":"timestamptz","type_modifier":-1,"type_oid":1184,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Name of the user that executed the transaction","description_zh":"执行此事务的用户名","documented":true,"documented_name":"owner","hidden":false,"name":"owner","not_null":false,"references":"pg_authid.rolname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Name of the database in which the transaction was executed","description_zh":"执行此事务所在数据库的名称","documented":true,"documented_name":"database","hidden":false,"name":"database","not_null":false,"references":"pg_database.datname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"}],"description":"The view pg_prepared_xacts displays information about transactions that are currently prepared for two-phase commit (see PREPARE TRANSACTION for details).\n\npg_prepared_xacts contains one row per prepared transaction. An entry is removed when the transaction is committed or rolled back."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}