Updated on 2024-05-07 GMT+08:00

GLOBAL_PARALLEL_DECODE_STATUS

GLOBAL_PARALLEL_DECODE_STATUS displays parallel decoding information about replication slots on each primary DN in a cluster. The view needs to be queried on a CN. An error is reported when the view is queried on a DN.

Table 1 GLOBAL_PARALLEL_DECODE_STATUS columns

Name

Type

Description

node_name

name

Specifies the 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

Specifies the total memory occupied by concatenation transactions in the sender thread, in bytes.

decoded_time

timestamptz

Specifies the time of the latest WAL decoded by the replication slot.