PARALLEL_DECODE_STATUS

PARALLEL_DECODE_STATUS displays parallel decoding information about replication slots on the current node, as described in Table 1. This view needs to be queried on DNs. If it is queried on CNs, no information is returned.

**Table 1** PARALLEL_DECODE_STATUS columns
Name	Type	Description
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.