Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit9b4271d

Browse files
committed
Document pg_stat_replication, bump catversion since that was overlooked.
Itagaki Takahiro, edited by me.
1 parenta9f72b4 commit9b4271d

File tree

3 files changed

+20
-1
lines changed

3 files changed

+20
-1
lines changed

‎doc/src/sgml/high-availability.sgml

Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -865,6 +865,16 @@ primary_conninfo = 'host=192.168.1.50 port=5432 user=foo password=foopass'
865865
process status of the WAL receiver process, displayed using the
866866
<command>ps</> command (see <xref linkend="monitoring-ps"> for details).
867867
</para>
868+
<para>
869+
You can retrieve a list of WAL sender processes via the
870+
<link linkend="monitoring-stats-views-table">
871+
<literal>pg_stat_replication</></link> view. Large differences between
872+
<function>pg_current_xlog_location</> and <literal>sent_location</> field
873+
might indicate that the master server is under heavy load, while
874+
differences between <literal>sent_location</> and
875+
<function>pg_last_xlog_receive_location</> on the standby might indicate
876+
network delay, or that the the standby is under heavy load.
877+
</para>
868878
</sect3>
869879

870880
</sect2>

‎doc/src/sgml/monitoring.sgml

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -294,6 +294,15 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re
294294
</entry>
295295
</row>
296296

297+
<row>
298+
<entry><structname>pg_stat_replication</><indexterm><primary>pg_stat_replication</primary></indexterm></entry>
299+
<entry>One row per WAL sender process, showing process <acronym>ID</>,
300+
user OID, user name, application name, client's address and port number,
301+
time at which the server process began execution, and transaction log
302+
location.
303+
</entry>
304+
</row>
305+
297306
<row>
298307
<entry><structname>pg_stat_all_tables</><indexterm><primary>pg_stat_all_tables</primary></indexterm></entry>
299308
<entry>For each table in the current database (including TOAST tables),

‎src/include/catalog/catversion.h

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -53,6 +53,6 @@
5353
*/
5454

5555
/*yyyymmddN */
56-
#defineCATALOG_VERSION_NO201101051
56+
#defineCATALOG_VERSION_NO201101071
5757

5858
#endif

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp