Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-8.x)/ System Catalogs and System Views/ System Views/ Other System Views/ PG_GET_SENDERS_CATCHUP_TIME
Updated on 2025-08-19 GMT+08:00
View PDF

PG_GET_SENDERS_CATCHUP_TIME

PG_GET_SENDERS_CATCHUP_TIME provides catchup information of the currently active primary/standby instance sender thread on the database node. In the multi-tenancy scenario, no information is returned in a PDB.

Table 1 PG_GET_SENDERS_CATCHUP_TIME columns

Name

Type

Description

pid

bigint

Current sender thread ID.

lwpid

integer

Current sender lwpid.

local_role

text

Local role.

peer_role

text

Peer role.

state

text

Current sender's replication status.

  • Startup: startup state.
  • Backup: backup state.
  • Catchup: catch-up state, which indicates that the standby node is catching up with the primary node.
  • Streaming: streaming replication state. When the standby node catches up with the primary node, the replication remains in this state.

type

text

Current sender type.

  • Wal: type that logs are written in advance.
  • Data: data type.

catchup_start

timestamp with time zone

Startup time of a catchup task.

catchup_end

timestamp with time zone

End time of a catchup task.
Parent topic: Other System Views