> For the complete documentation index, see [llms.txt](https://docs.starrocks.io/llms.txt). This page is also available as Markdown at its `.md` URL.
# SHOW COMPUTE NODES
SHOW COMPUTE NODES shows the information of all CN nodes in the cluster.
tip
Only users with the SYSTEM-level OPERATE privilege or the `cluster_admin` role can perform this operation.
## Syntax[](#syntax "Direct link to Syntax")
```sql
SHOW COMPUTE NODES
```
## Return[](#return "Direct link to Return")
```sql
+---------------+--------------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+--------+--------------------+----------+-------------------+------------+------------+----------------+-------------+----------+-------------------+-----------+------------+
| ComputeNodeId | IP | HeartbeatPort | BePort | HttpPort | BrpcPort | LastStartTime | LastHeartbeat | Alive | SystemDecommissioned | ClusterDecommissioned | ErrMsg | Version | CpuCores | NumRunningQueries | MemUsedPct | CpuUsedPct | HasStoragePath | StarletPort | WorkerId | WarehouseName | TabletNum | StatusCode |
+---------------+--------------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+--------+--------------------+----------+-------------------+------------+------------+----------------+-------------+----------+-------------------+-----------+------------+
```
The following table describes the parameters returned by this statement.
| **Parameter** | **Description** |
| --------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| ComputeNodeId | The ID of the CN node. |
| IP | The IP address of the CN node. |
| HeartbeatPort | The heartbeat port of the CN node. It is used to receive heartbeats from the FE node. |
| BePort | Thrift server port of the CN node. It is used to receive requests from the FE node. |
| HttpPort | HTTP server port of the CN node. It is used to access the CN node via web page. |
| BrpcPort | bRPC port of the CN node. It is used for communication across CN nodes. |
| LastStartTime | The last time at which the CN node starts. |
| LastHeartbeat | The last time at which the CN node sends a heartbeat. |
| Alive | Whether the CN node is alive or not.- `true`: the CN node is alive.
- `false`: the CN node is not alive. |
| SystemDecommissioned | If the value of the parameter is `true`, the CN node is removed from your StarRocks cluster. |
| ClusterDecommissioned | This parameter is used for system compatibility. |
| ErrMsg | The error message if the CN node fails to send a heartbeat. |
| Version | The StarRocks version of the CN node. |
| CpuCores | The number of CPU cores in the CN node. |
| NumRunningQueries | The number of running queries on the CN node. |
| MemUsedPct | The percentage of used memory. |
| CpuUsedPct | The percentage of used CPU cores. |
| HasStoragePath | Whether the CN node has storage paths configured. |
| StarletPort | The `starlet_port` of the CN node. It is an extra agent service port. |
| WorkerId | The ID of the CN node for internal scheduling. |
| WarehouseName | The name of the warehouse to which the CN node belongs. The value is always `default_warehouse`. |
| TabletNum | The number of tablets (of cached data) on the CN node. |
| StatusCode | CN status code. Valid values: - `CONNECTING`: The CN node is being added to the cluster for the first time.
- `OK`: The CN node is running.
- `SHUTDOWN`: The CN node is being shut down gracefully.
- `DISCONNECTED`: The CN node is disconnected. |
## Example[](#example "Direct link to Example")
View the information of all CN nodes in the cluster.
```plain
MySQL > SHOW COMPUTE NODES\G
*************************** 1. row ***************************
ComputeNodeId: 10001
IP: x.x.x.x
HeartbeatPort: 9050
BePort: 9060
HttpPort: 8040
BrpcPort: 8060
LastStartTime: 2024-05-14 15:45:34
LastHeartbeat: 2024-05-14 15:47:59
Alive: true
SystemDecommissioned: false
ClusterDecommissioned: false
ErrMsg:
Version: 3.3.0-rc01-3b8cb0c
CpuCores: 4
NumRunningQueries: 0
MemUsedPct: 1.95 %
CpuUsedPct: 0.0 %
HasStoragePath: true
StarletPort: 8167
WorkerId: 1
WarehouseName: default_warehouse
TabletNum: 58
1 row in set (0.00 sec)
```