SHOW MASTER STATUS

Function

Views the progress of WAL (Xlog).

Precautions

• This statement can also be executed in a non-primary database.
• When the command is executed on the primary database, the results of Xlog_Lsn and pg_current_xlog_location are the same. When the command is executed on a non-primary database, the results of Xlog_Lsn and pg_last_xlog_replay_location are the same.
• The primary database uses this statement to query the real-time progress of Xlog writing.
• The standby database uses this statement to query the real-time progress of the current Xlog replay.

Syntax

SHOW MASTER STATUS

Parameter Description

• Xlog_File_Name

   Name of the Xlog file that is being processed.
  

• Xlog_File_Offset

   Offset position of the Xlog file that is being processed.
  

• Xlog_Lsn

   LSN of the current Xlog.
  

Examples

openGauss=# show master status;
      Xlog_File_Name      | Xlog_File_Offset |  Xlog_Lsn
--------------------------+------------------+------------
 000000010000000000000010 |          7142672 | 0/106CFD10
(1 row)