begriffs open source - ai-pg/blob - full-docs/html/view-pg-prepared-xacts.html

   1 <?xml version="1.0" encoding="UTF-8" standalone="no"?>
   2 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>53.17. pg_prepared_xacts</title><link rel="stylesheet" type="text/css" href="stylesheet.css" /><link rev="made" href="pgsql-docs@lists.postgresql.org" /><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot" /><link rel="prev" href="view-pg-prepared-statements.html" title="53.16. pg_prepared_statements" /><link rel="next" href="view-pg-publication-tables.html" title="53.18. pg_publication_tables" /></head><body id="docContent" class="container-fluid col-10"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">53.17. <code class="structname">pg_prepared_xacts</code></th></tr><tr><td width="10%" align="left"><a accesskey="p" href="view-pg-prepared-statements.html" title="53.16. pg_prepared_statements">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="views.html" title="Chapter 53. System Views">Up</a></td><th width="60%" align="center">Chapter 53. System Views</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 18.0 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="view-pg-publication-tables.html" title="53.18. pg_publication_tables">Next</a></td></tr></table><hr /></div><div class="sect1" id="VIEW-PG-PREPARED-XACTS"><div class="titlepage"><div><div><h2 class="title" style="clear: both">53.17. <code class="structname">pg_prepared_xacts</code> <a href="#VIEW-PG-PREPARED-XACTS" class="id_link">#</a></h2></div></div></div><a id="id-1.10.5.21.2" class="indexterm"></a><p>
   3    The view <code class="structname">pg_prepared_xacts</code> displays
   4    information about transactions that are currently prepared for two-phase
   5    commit (see <a class="xref" href="sql-prepare-transaction.html" title="PREPARE TRANSACTION"><span class="refentrytitle">PREPARE TRANSACTION</span></a> for details).
   6   </p><p>
   7    <code class="structname">pg_prepared_xacts</code> contains one row per prepared
   8    transaction.  An entry is removed when the transaction is committed or
   9    rolled back.
  10   </p><div class="table" id="id-1.10.5.21.5"><p class="title"><strong>Table 53.17. <code class="structname">pg_prepared_xacts</code> Columns</strong></p><div class="table-contents"><table class="table" summary="pg_prepared_xacts Columns" border="1"><colgroup><col /></colgroup><thead><tr><th class="catalog_table_entry"><p class="column_definition">
  11        Column Type
  12       </p>
  13       <p>
  14        Description
  15       </p></th></tr></thead><tbody><tr><td class="catalog_table_entry"><p class="column_definition">
  16        <code class="structfield">transaction</code> <code class="type">xid</code>
  17       </p>
  18       <p>
  19        Numeric transaction identifier of the prepared transaction
  20       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  21        <code class="structfield">gid</code> <code class="type">text</code>
  22       </p>
  23       <p>
  24        Global transaction identifier that was assigned to the transaction
  25       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  26        <code class="structfield">prepared</code> <code class="type">timestamptz</code>
  27       </p>
  28       <p>
  29        Time at which the transaction was prepared for commit
  30       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  31        <code class="structfield">owner</code> <code class="type">name</code>
  32        (references <a class="link" href="catalog-pg-authid.html" title="52.8. pg_authid"><code class="structname">pg_authid</code></a>.<code class="structfield">rolname</code>)
  33       </p>
  34       <p>
  35        Name of the user that executed the transaction
  36       </p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
  37        <code class="structfield">database</code> <code class="type">name</code>
  38        (references <a class="link" href="catalog-pg-database.html" title="52.15. pg_database"><code class="structname">pg_database</code></a>.<code class="structfield">datname</code>)
  39       </p>
  40       <p>
  41        Name of the database in which the transaction was executed
  42       </p></td></tr></tbody></table></div></div><br class="table-break" /><p>
  43    When the <code class="structname">pg_prepared_xacts</code> view is accessed, the
  44    internal transaction manager data structures are momentarily locked, and
  45    a copy is made for the view to display.  This ensures that the
  46    view produces a consistent set of results, while not blocking
  47    normal operations longer than necessary.  Nonetheless
  48    there could be some impact on database performance if this view is
  49    frequently accessed.
  50   </p></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="view-pg-prepared-statements.html" title="53.16. pg_prepared_statements">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="views.html" title="Chapter 53. System Views">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="view-pg-publication-tables.html" title="53.18. pg_publication_tables">Next</a></td></tr><tr><td width="40%" align="left" valign="top">53.16. <code class="structname">pg_prepared_statements</code> </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 18.0 Documentation">Home</a></td><td width="40%" align="right" valign="top"> 53.18. <code class="structname">pg_publication_tables</code></td></tr></table></div></body></html>