PolarDB:DBA_QUEUES

Parameter

Type

Description

owner

TEXT

The username of the owner to which a queue belongs.

name

TEXT

The name of the queue.

queue_table

TEXT

The name of the queue table to which the queue belongs.

qid

OID

The object ID of the queue. This object ID is assigned by the system.

queue_type

CHARACTER VARYING

The queue type. Valid values: EXCEPTION_QUEUE, NON_PERSISTENT_QUEUE, and NORMAL_QUEUE.

max_retries

NUMERIC

The maximum number of dequeuing attempts.

retry_delay

NUMERIC

The maximum time allowed between retries.

enqueue_enabled

CHARACTER VARYING

• YES: indicates that the queue allows enqueuing.

• NO: indicates that the queue does not allow enqueuing.

dequeue_enabled

CHARACTER VARYING

• YES: indicates that the queue allows dequeuing.

• NO: indicates that the queue does not allow dequeuing.

retention

CHARACTER VARYING

The number of seconds that a processed message is retained in the queue.

user_comment

CHARACTER VARYING

The user-defined comment.

network_name

CHARACTER VARYING

The name of the network in which the queue is.

sharded

CHARACTER VARYING

• YES: indicates the queue is in a sharded network.

• NO: indicates the queue is not in a sharded network.