# SHOW NODES

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: SHOW NODES
latest-operator-version: v26.1.4
latest-console-tag: v3.7.3
latest-connect-version: 4.93.0
latest-redpanda-tag: v26.1.9
docname: sql/sql-statements/show-nodes
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/sql-statements/show-nodes.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-statements/show-nodes.adoc
description: The SHOW NODES statement returns the current state of the cluster and is only available to the superuser.
page-topic-type: reference
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-statements/show-nodes.md -->

The `SHOW NODES` statement returns the current state of the cluster. Only the superuser can run this statement.

> 📝 **NOTE**
>
> `SHOW NODES` is not case-sensitive. `show nodes`, `Show Nodes`, and `SHOW NODES` produce the same result.

## [](#examples)Examples

To view the current cluster state, run:

```sql
SHOW NODES;
```

This returns a table with information about each node in the cluster:

```sql
     name      | election_state  | followers_count | connected_nodes_count | degradation_error
---------------+-----------------+-----------------+-----------------------+-------------------
 n_oxla_node_1 | LEADER_FOLLOWER |               0 |                     3 |
 n_oxla_node_3 | LEADER          |               3 |                     3 |
 n_oxla_node_2 | LEADER_FOLLOWER |               0 |                     3 |
(3 rows)
```

Each row represents the state of an individual node, where:

-   `name`: Name of the node.

-   `election_state`: Current state of the node (for example, `LEADER`).

-   `followers_count`: Number of nodes following the leader. Only meaningful for the leader node.

-   `connected_nodes_count`: Total number of connected nodes, including itself.

-   `degradation_error`: Error message if the node is not working correctly. Otherwise `NULL`.


> 📝 **NOTE**
>
> `SHOW NODES` is equivalent to `SELECT * FROM system.nodes`. You can query the `system.nodes` table directly to filter or sort results using `WHERE` and `ORDER BY` clauses.
>
> Related [system virtual tables](https://docs.redpanda.com/cloud-data-platform/reference/sql/system-virtual-tables/) include `system.queries` (running queries) and `system.execs` (execution tasks).