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)