{"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":"efb28b00e8f2e9ccc4887f561479069f28289aa4268ee507746f12c532afaddf","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":"english-manuals:afaad40723b598fc06742ac3382d95b0d42c288958778b1832b8f71300a9b37b","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":""}},"Definition":{"Collection":"catalog","Key":"pg_prepared_xacts","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_prepared_xacts","SourceRevision":"english-manuals:afaad40723b598fc06742ac3382d95b0d42c288958778b1832b8f71300a9b37b","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Numeric transaction identifier of the prepared transaction","description_zh":"","documented":true,"documented_name":"transaction","hidden":false,"name":"transaction","not_null":false,"references":"","type":"xid","type_modifier":-1,"type_oid":28},{"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},{"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},{"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},{"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}],"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":"","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"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.21.5","file":"view-pg-prepared-xacts.html","lang":"en","sha256":"5a3851958b1f132ca62a87da7c72711bd1311abedfe6a260ca61a163fea628af","slug":"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":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_prepared_xacts","Summary":"视图pg_prepared_xacts显示当前已处于两阶段提交预备状态的事务的信息（详见PREPARE TRANSACTION）。\n\npg_prepared_xacts 为每个预备事务包含一行。事务提交或回滚时，对应条目会被移除。","BodyHTML":"\u003cp\u003e视图pg_prepared_xacts显示当前已处于两阶段提交预备状态的事务的信息（详见PREPARE TRANSACTION）。\n\npg_prepared_xacts 为每个预备事务包含一行。事务提交或回滚时，对应条目会被移除。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"412ba40b9fc15f5db5017565a82060541ea81bd4cb5c2172cc97179bf5c4f1e1","Payload":{"columns":[{"description_zh":"预备事务的数字事务 ID","name":"transaction","type":"xid","zh_from":"doc"},{"description_zh":"分配给该事务的全局事务标识符","name":"gid","type":"text","zh_from":"doc"},{"description_zh":"该事务进入预备提交状态的时间","name":"prepared","type":"timestamp with time zone","zh_from":"doc"},{"description_zh":"执行此事务的用户名","name":"owner","type":"name","zh_from":"doc"},{"description_zh":"执行此事务所在数据库的名称","name":"database","type":"name","zh_from":"doc"}],"description_zh":"视图pg_prepared_xacts显示当前已处于两阶段提交预备状态的事务的信息（详见PREPARE TRANSACTION）。\n\npg_prepared_xacts 为每个预备事务包含一行。事务提交或回滚时，对应条目会被移除。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","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}