PG_GET_SENDERS_CATCHUP_TIME
PG_GET_SENDERS_CATCHUP_TIME displays the catchup information of the currently active primary/standby instance sending thread on a single DN.
| 
        Column  | 
      
        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  | 
     
| 
        catchup_type  | 
      
        Text  | 
      
        Catchup task type, full or incremental  | 
     
| 
        catchup_bcm_filename  | 
      
        Text  | 
      
        BCM file executed by the current catchup task  | 
     
| 
        catchup_bcm_finished  | 
      
        Integer  | 
      
        Number of BCM files completed by a catchup task  | 
     
| 
        catchup_bcm_total  | 
      
        Integer  | 
      
        Total number of BCM files to be operated by a catchup task  | 
     
| 
        catchup_percent  | 
      
        Text  | 
      
        Completion percentage of a catchup task  | 
     
| 
        catchup_remaining_time  | 
      
        Text  | 
      
        Estimated remaining time of a catchup task  | 
     
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.