diff options
| author | Robert Haas <rhaas@postgresql.org> | 2011-01-07 11:06:55 -0500 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2011-01-07 11:06:55 -0500 |
| commit | 9b4271deb97270d336c9d34ac911748faa5a4892 (patch) | |
| tree | a1e75ee5071b7636b82017190c8013b8c1cc1940 /doc/src | |
| parent | a9f72b408325c4abb41b5ab65f8fb79af4c29495 (diff) | |
| download | postgresql-9b4271deb97270d336c9d34ac911748faa5a4892.tar.gz postgresql-9b4271deb97270d336c9d34ac911748faa5a4892.zip | |
Document pg_stat_replication, bump catversion since that was overlooked.
Itagaki Takahiro, edited by me.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/high-availability.sgml | 10 | ||||
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 9 |
2 files changed, 19 insertions, 0 deletions
diff --git a/doc/src/sgml/high-availability.sgml b/doc/src/sgml/high-availability.sgml index b1ec461f53e..d8841228e1a 100644 --- a/doc/src/sgml/high-availability.sgml +++ b/doc/src/sgml/high-availability.sgml @@ -865,6 +865,16 @@ primary_conninfo = 'host=192.168.1.50 port=5432 user=foo password=foopass' process status of the WAL receiver process, displayed using the <command>ps</> command (see <xref linkend="monitoring-ps"> for details). </para> + <para> + You can retrieve a list of WAL sender processes via the + <link linkend="monitoring-stats-views-table"> + <literal>pg_stat_replication</></link> view. Large differences between + <function>pg_current_xlog_location</> and <literal>sent_location</> field + might indicate that the master server is under heavy load, while + differences between <literal>sent_location</> and + <function>pg_last_xlog_receive_location</> on the standby might indicate + network delay, or that the the standby is under heavy load. + </para> </sect3> </sect2> diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 739b8a27fd9..e2d27da38c7 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -295,6 +295,15 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re </row> <row> + <entry><structname>pg_stat_replication</><indexterm><primary>pg_stat_replication</primary></indexterm></entry> + <entry>One row per WAL sender process, showing process <acronym>ID</>, + user OID, user name, application name, client's address and port number, + time at which the server process began execution, and transaction log + location. + </entry> + </row> + + <row> <entry><structname>pg_stat_all_tables</><indexterm><primary>pg_stat_all_tables</primary></indexterm></entry> <entry>For each table in the current database (including TOAST tables), the table OID, schema and table name, number of sequential |