diff options
| author | Andres Freund <andres@anarazel.de> | 2015-04-21 11:51:06 +0200 |
|---|---|---|
| committer | Andres Freund <andres@anarazel.de> | 2015-04-21 11:51:06 +0200 |
| commit | d811c037cea2e929ee5823aab6e1bca0df8be245 (patch) | |
| tree | 46cd4fdf2fc78c9f20d8c65c15814e019b08af9b /doc/src | |
| parent | 528c2e44ab0a5ba49a5a04689dae3f674b71c15e (diff) | |
Add 'active_in' column to pg_replication_slots.
Right now it is visible whether a replication slot is active in any
session, but not in which. Adding the active_in column, containing the
pid of the backend having acquired the slot, makes it much easier to
associate pg_replication_slots entries with the corresponding
pg_stat_replication/pg_stat_activity row.
This should have been done from the start, but I (Andres) dropped the
ball there somehow.
Author: Craig Ringer, revised by me Discussion:
CAMsr+YFKgZca5_7_ouaMWxA5PneJC9LNViPzpDHusaPhU9pA7g@mail.gmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 10 | ||||
| -rw-r--r-- | doc/src/sgml/logicaldecoding.sgml | 8 |
2 files changed, 14 insertions, 4 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index d0b78f27827..98847354bd0 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -5401,6 +5401,16 @@ </row> <row> + <entry><structfield>active_in</structfield></entry> + <entry><type>integer</type></entry> + <entry></entry> + <entry>The process ID of the session using this slot if the slot + is currently actively being used. <literal>NULL</literal> if + inactive. + </entry> + </row> + + <row> <entry><structfield>xmin</structfield></entry> <entry><type>xid</type></entry> <entry></entry> diff --git a/doc/src/sgml/logicaldecoding.sgml b/doc/src/sgml/logicaldecoding.sgml index 36505678526..0810a2d1f97 100644 --- a/doc/src/sgml/logicaldecoding.sgml +++ b/doc/src/sgml/logicaldecoding.sgml @@ -62,10 +62,10 @@ postgres=# SELECT * FROM pg_create_logical_replication_slot('regression_slot', ' regression_slot | 0/16B1970 (1 row) -postgres=# SELECT * FROM pg_replication_slots; - slot_name | plugin | slot_type | datoid | database | active | xmin | catalog_xmin | restart_lsn ------------------+---------------+-----------+--------+----------+--------+--------+--------------+------------- - regression_slot | test_decoding | logical | 12052 | postgres | f | | 684 | 0/16A4408 +postgres=# SELECT slot_name, plugin, slot_type, database, active, restart_lsn FROM pg_replication_slots; + slot_name | plugin | slot_type | database | active | restart_lsn +-----------------+---------------+-----------+----------+--------+------------- + regression_slot | test_decoding | logical | postgres | f | 0/16A4408 (1 row) postgres=# -- There are no changes to see yet |