Skip to main content

SHOW BROKER

Description

This statement is used to view the status of the currently existing broker processes.

Syntax:

SHOW BROKER;

Output

ColumnDateTypeNote
NamevarcharBroker Process Name
HostvarcharBroker Process Node IP
PortvarcharBroker Process Node Port
AlivevarcharBroker Process Node Status
LastStartTimevarcharBroker Process Last Start Time
LastUpdateTimevarcharBroker Process Last Update Time
ErrMsgvarcharError message of the last failed startup of the Broker process

Access Control Requirements

The user executing this statement needs to have the ADMIN/OPERATOR permission.

Examples

  1. View the status of the currently existing broker processes
    show broker;
    +-------------+------------+------+-------+---------------------+---------------------+--------+
    | Name | Host | Port | Alive | LastStartTime | LastUpdateTime | ErrMsg |
    +-------------+------------+------+-------+---------------------+---------------------+--------+
    | broker_test | 10.10.10.1 | 8196 | true | 2025-01-21 11:30:10 | 2025-01-21 11:31:40 | |
    +-------------+------------+------+-------+---------------------+---------------------+--------+