aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorRobert Haas <rhaas@postgresql.org>2014-02-25 12:34:04 -0500
committerRobert Haas <rhaas@postgresql.org>2014-02-25 12:34:04 -0500
commitdd1a3bccca241a998b4ebf39d67202698e5fa599 (patch)
treeac25477cab559d842e406a1f6ba878257c694dc4 /doc/src
parent278c94209b90b8e241f64ea4ce2d955b63b1f5d7 (diff)
downloadpostgresql-dd1a3bccca241a998b4ebf39d67202698e5fa599.tar.gz
postgresql-dd1a3bccca241a998b4ebf39d67202698e5fa599.zip
Show xid and xmin in pg_stat_activity and pg_stat_replication.
Christian Kruse, reviewed by Andres Freund and myself, with further minor adjustments by me.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/monitoring.sgml16
1 files changed, 16 insertions, 0 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml
index 370857a0e8c..958acc4fd15 100644
--- a/doc/src/sgml/monitoring.sgml
+++ b/doc/src/sgml/monitoring.sgml
@@ -629,6 +629,16 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re
</entry>
</row>
<row>
+ <entry><structfield>backend_xid</structfield></entry>
+ <entry><type>xid</type></entry>
+ <entry>Toplevel transaction identifier of this backend, if any.</entry>
+ </row>
+ <row>
+ <entry><structfield>backend_xmin</structfield></entry>
+ <entry><type>xid</type></entry>
+ <entry>The current backend's <literal>xmin</> horizon.</entry>
+ </row>
+ <row>
<entry><structfield>query</></entry>
<entry><type>text</></entry>
<entry>Text of this backend's most recent query. If
@@ -1484,6 +1494,12 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re
</entry>
</row>
<row>
+ <entry><structfield>backend_xid</structfield></entry>
+ <entry><type>xid</type></entry>
+ <entry>This standby's <literal>xmin</> horizon reported
+ by <xref linkend="guc-hot-standby-feedback">.</entry>
+ </row>
+ <row>
<entry><structfield>state</></entry>
<entry><type>text</></entry>
<entry>Current WAL sender state</entry>