• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_GET_SENDERS_CATCHUP_TIME

PG_GET_SENDERS_CATCHUP_TIME

PG_GET_SENDERS_CATCHUP_TIME provides the catchup information of the currently active primary/standby instance sending thread on the DN.

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

type

text

Current sender 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