begriffs open source - ai-pg/blob - full-docs/src/sgml/html/logical-replication-monitoring.html

   1 <?xml version="1.0" encoding="UTF-8" standalone="no"?>
   2 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>29.10. Monitoring</title><link rel="stylesheet" type="text/css" href="stylesheet.css" /><link rev="made" href="pgsql-docs@lists.postgresql.org" /><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot" /><link rel="prev" href="logical-replication-architecture.html" title="29.9. Architecture" /><link rel="next" href="logical-replication-security.html" title="29.11. Security" /></head><body id="docContent" class="container-fluid col-10"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">29.10. Monitoring</th></tr><tr><td width="10%" align="left"><a accesskey="p" href="logical-replication-architecture.html" title="29.9. Architecture">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="logical-replication.html" title="Chapter 29. Logical Replication">Up</a></td><th width="60%" align="center">Chapter 29. Logical Replication</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 18.0 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="logical-replication-security.html" title="29.11. Security">Next</a></td></tr></table><hr /></div><div class="sect1" id="LOGICAL-REPLICATION-MONITORING"><div class="titlepage"><div><div><h2 class="title" style="clear: both">29.10. Monitoring <a href="#LOGICAL-REPLICATION-MONITORING" class="id_link">#</a></h2></div></div></div><p>
   3    Because logical replication is based on a similar architecture as
   4    <a class="link" href="warm-standby.html#STREAMING-REPLICATION" title="26.2.5. Streaming Replication">physical streaming replication</a>,
   5    the monitoring on a publication node is similar to monitoring of a
   6    physical replication primary
   7    (see <a class="xref" href="warm-standby.html#STREAMING-REPLICATION-MONITORING" title="26.2.5.2. Monitoring">Section 26.2.5.2</a>).
   8   </p><p>
   9    The monitoring information about subscription is visible in
  10    <a class="link" href="monitoring-stats.html#MONITORING-PG-STAT-SUBSCRIPTION" title="27.2.8. pg_stat_subscription">
  11    <code class="structname">pg_stat_subscription</code></a>.
  12    This view contains one row for every subscription worker.  A subscription
  13    can have zero or more active subscription workers depending on its state.
  14   </p><p>
  15    Normally, there is a single apply process running for an enabled
  16    subscription.  A disabled subscription or a crashed subscription will have
  17    zero rows in this view.  If the initial data synchronization of any
  18    table is in progress, there will be additional workers for the tables
  19    being synchronized. Moreover, if the
  20    <a class="link" href="sql-createsubscription.html#SQL-CREATESUBSCRIPTION-PARAMS-WITH-STREAMING"><code class="literal">streaming</code></a>
  21    transaction is applied in parallel, there may be additional parallel apply
  22    workers.
  23   </p></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="logical-replication-architecture.html" title="29.9. Architecture">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="logical-replication.html" title="Chapter 29. Logical Replication">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="logical-replication-security.html" title="29.11. Security">Next</a></td></tr><tr><td width="40%" align="left" valign="top">29.9. Architecture </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 18.0 Documentation">Home</a></td><td width="40%" align="right" valign="top"> 29.11. Security</td></tr></table></div></body></html>