GLOBAL_PARALLEL_DECODE_STATUS
GLOBAL_PARALLEL_DECODE_STATUS displays parallel decoding information about replication slots on each primary DN in a cluster, as described in Table 1. The view needs to be queried on a CN. An error is reported when the view is queried on a DN.
| Name | Type | Description |
|---|---|---|
| node_name | name | Node name. |
| slot_name | text | Specifies the replication slot name. |
| parallel_decode_num | integer | Specifies the number of parallel decoder threads of the replication slot. |
| read_change_queue_length | text | Concatenates the current length of the log queue read by each decoder thread and then outputs the result. |
| decode_change_queue_length | text | Concatenates the current length of the decoding result queue of each decoder thread and then outputs the result. |
| reader_lsn | text | Specifies the location of the log read by the current reader thread. |
| working_txn_cnt | bigint | Specifies the number of transactions that are being concatenated in the current sender thread. |
| working_txn_memory | bigint | Total memory occupied by concatenation transactions in the sender thread, in bytes. |
| decoded_time | timestamp with time zone | Time when the replication slot reads the logical log for the last time. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.