diff options
| author | Amit Kapila <akapila@postgresql.org> | 2024-11-25 11:12:32 +0530 |
|---|---|---|
| committer | Amit Kapila <akapila@postgresql.org> | 2024-11-25 11:12:32 +0530 |
| commit | d05a387d9d78a65db2c960d4f309a2649d183066 (patch) | |
| tree | adcc83c08e60586a76083993678896bffe0101e5 /doc/src | |
| parent | db80507d98462d95f2f7f8c1a58e55bb6337c3eb (diff) | |
| download | postgresql-d05a387d9d78a65db2c960d4f309a2649d183066.tar.gz postgresql-d05a387d9d78a65db2c960d4f309a2649d183066.zip | |
Doc: Clarify the `inactive_since` field description.
Updated to specify that it represents the exact time a slot became
inactive, rather than the period of inactivity.
Reported-by: Peter Smith
Author: Bruce Momjian, Nisha Moond
Reviewed-by: Amit Kapila, Peter Smith
Backpatch-through: 17
Discussion: https://postgr.es/m/CAHut+PuvsyA5v8y7rYoY9mkDQzUhwaESM05yCByTMaDoRh30tA@mail.gmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/system-views.sgml | 24 |
1 files changed, 13 insertions, 11 deletions
diff --git a/doc/src/sgml/system-views.sgml b/doc/src/sgml/system-views.sgml index 61d28e701f2..a586156614d 100644 --- a/doc/src/sgml/system-views.sgml +++ b/doc/src/sgml/system-views.sgml @@ -2435,7 +2435,7 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx <structfield>active</structfield> <type>bool</type> </para> <para> - True if this slot is currently actively being used + True if this slot is currently being streamed </para></entry> </row> @@ -2444,9 +2444,8 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx <structfield>active_pid</structfield> <type>int4</type> </para> <para> - The process ID of the session using this slot if the slot - is currently actively being used. <literal>NULL</literal> if - inactive. + The process ID of the session streaming data for this slot. + <literal>NULL</literal> if inactive. </para></entry> </row> @@ -2566,15 +2565,18 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx <structfield>inactive_since</structfield> <type>timestamptz</type> </para> <para> - The time since the slot has become inactive. - <literal>NULL</literal> if the slot is currently being used. + The time when the slot became inactive. <literal>NULL</literal> if the + slot is currently being streamed. Note that for slots on the standby that are being synced from a primary server (whose <structfield>synced</structfield> field is - <literal>true</literal>), the - <structfield>inactive_since</structfield> indicates the last - synchronization (see - <xref linkend="logicaldecoding-replication-slots-synchronization"/>) - time. + <literal>true</literal>), the <structfield>inactive_since</structfield> + indicates the time when slot synchronization (see <xref + linkend="logicaldecoding-replication-slots-synchronization"/>) + was most recently stopped. <literal>NULL</literal> if the slot + has always been synchronized. On standby, this is useful for slots + that are being synced from a primary server (whose + <structfield>synced</structfield> field is <literal>true</literal>) + so they know when the slot stopped being synchronized. </para></entry> </row> |