From 46651ce6fe013220ed397add242004d764fc0153 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:15:05 +0200 Subject: Adding upstream version 14.5. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/view-pg-prepared-xacts.html | 50 +++++++++++++++++++++++++++ 1 file changed, 50 insertions(+) create mode 100644 doc/src/sgml/html/view-pg-prepared-xacts.html (limited to 'doc/src/sgml/html/view-pg-prepared-xacts.html') diff --git a/doc/src/sgml/html/view-pg-prepared-xacts.html b/doc/src/sgml/html/view-pg-prepared-xacts.html new file mode 100644 index 0000000..f8f071f --- /dev/null +++ b/doc/src/sgml/html/view-pg-prepared-xacts.html @@ -0,0 +1,50 @@ + +52.78. pg_prepared_xacts
52.78. pg_prepared_xacts
Prev UpChapter 52. System CatalogsHome Next

52.78. pg_prepared_xacts

+ The view pg_prepared_xacts displays + information about transactions that are currently prepared for two-phase + commit (see PREPARE TRANSACTION for details). +

+ pg_prepared_xacts contains one row per prepared + transaction. An entry is removed when the transaction is committed or + rolled back. +

Table 52.79. pg_prepared_xacts Columns

+ Column Type +

+

+ Description +

+ transaction xid +

+

+ Numeric transaction identifier of the prepared transaction +

+ gid text +

+

+ Global transaction identifier that was assigned to the transaction +

+ prepared timestamptz +

+

+ Time at which the transaction was prepared for commit +

+ owner name + (references pg_authid.rolname) +

+

+ Name of the user that executed the transaction +

+ database name + (references pg_database.datname) +

+

+ Name of the database in which the transaction was executed +


+ When the pg_prepared_xacts view is accessed, the + internal transaction manager data structures are momentarily locked, and + a copy is made for the view to display. This ensures that the + view produces a consistent set of results, while not blocking + normal operations longer than necessary. Nonetheless + there could be some impact on database performance if this view is + frequently accessed. +

Prev Up Next
52.77. pg_prepared_statements Home 52.79. pg_publication_tables
\ No newline at end of file -- cgit v1.2.3