Help Center > > Developer Guide> System Catalogs and System Views> System Views> PG_PREPARED_XACTS

PG_PREPARED_XACTS

Updated at: Jul 15, 2020 GMT+08:00

PG_PREPARED_XACTS displays information about transactions that are currently prepared for two-phase commit.

Table 1 PG_PREPARED_XACTS columns

Name

Type

Reference

Description

transaction

xid

-

Numeric transaction identifier of the prepared transaction

gid

text

-

Global transaction identifier that was assigned to the transaction

prepared

timestamp with time zone

-

Time at which the transaction is prepared for commit

owner

name

PG_AUTHID.rolname

Name of the user that executes the transaction

database

name

PG_DATABASE.datname

Name of the database in which the transaction is executed

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel