Home • Explore • Blog • CI
☰



postgresql
3rd chunk of `doc/src/sgml/ref/pg_waldump.sgml`
f56db3ab9202c4564302259461c1625f301ecfddf2d053e00000000100000ebe
 three-digit resource manager ID.
        Names of this form will always be considered valid.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-R <replaceable>tblspc</replaceable>/<replaceable>db</replaceable>/<replaceable>rel</replaceable></option></term>
      <term><option>--relation=<replaceable>tblspc</replaceable>/<replaceable>db</replaceable>/<replaceable>rel</replaceable></option></term>
      <listitem>
       <para>
        Only display records that modify blocks in the given relation.  The
        relation is specified with tablespace OID, database OID, and relfilenode
        separated by slashes, for example <literal>1234/12345/12345</literal>.
        This is the same format used for relations in the program's output.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-s <replaceable>start</replaceable></option></term>
      <term><option>--start=<replaceable>start</replaceable></option></term>
      <listitem>
       <para>
        WAL location at which to start reading. The default is to start reading
        the first valid WAL record found in the earliest file found.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-t <replaceable>timeline</replaceable></option></term>
      <term><option>--timeline=<replaceable>timeline</replaceable></option></term>
      <listitem>
       <para>
        Timeline from which to read WAL records. The default is to use the
        value in <replaceable>startseg</replaceable>, if that is specified; otherwise, the
        default is 1.  The value can be specified in decimal or hexadecimal,
        for example <literal>17</literal> or <literal>0x11</literal>.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
       <term><option>-V</option></term>
       <term><option>--version</option></term>
       <listitem>
       <para>
       Print the <application>pg_waldump</application> version and exit.
       </para>
       </listitem>
     </varlistentry>

     <varlistentry>
       <term><option>-w</option></term>
       <term><option>--fullpage</option></term>
       <listitem>
       <para>
        Only display records that include full page images.
       </para>
       </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-x <replaceable>xid</replaceable></option></term>
      <term><option>--xid=<replaceable>xid</replaceable></option></term>
      <listitem>
       <para>
        Only display records marked with the given transaction ID.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-z</option></term>
      <term><option>--stats[=record]</option></term>
      <listitem>
       <para>
        Display summary statistics (number and size of records and
        full-page images) instead of individual records. Optionally
        generate statistics per-record instead of per-rmgr.
       </para>

       <para>
        If <application>pg_waldump</application> is terminated by signal
        <systemitem>SIGINT</systemitem>
        (<keycombo action="simul"><keycap>Control</keycap><keycap>C</keycap></keycombo>),
        the summary of the statistics computed is displayed up to the
        termination point. This operation is not supported on
        <productname>Windows</productname>.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
       <term><option>--save-fullpage=<replaceable>save_path</replaceable></option></term>
       <listitem>
       <para>
        Save full page images found in the WAL records to the
        <replaceable>save_path</replaceable> directory. The images saved
        are subject to the same
Title: pg_waldump Options: Filtering and Output Control (Continued)
Summary
This section continues detailing command-line options for pg_waldump. It covers options to filter WAL records by relation (tablespace/database/relfilenode), specify the starting WAL location and timeline, display the pg_waldump version, show only records with full-page images, filter by transaction ID, and display summary statistics (optionally per-record). It also mentions the ability to display partial statistics upon interruption (SIGINT) and the option to save full page images to a specified directory.