STV_NODE_STORAGE_CAPACITY - Amazon Redshift
Table columnsSample queries
Services or capabilities described in AWS documentation might vary by Region. To see the differences applicable to the AWS European Sovereign Cloud Region, see the AWS European Sovereign Cloud User Guide.

Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026. We will start enforcing it in phases. For more information on the details of Python end of life and migration options, see the blog post that was published on June 30, 2025.

STV_NODE_STORAGE_CAPACITY

The STV_NODE_STORAGE_CAPACITY table shows details of total storage capacity and total used capacity for each node in a cluster. It contains a row for each node.

STV_NODE_STORAGE_CAPACITY is visible only to superusers. For more information, see Visibility of data in system tables and views.

Table columns

Column name Data type Description
node integer The node number.
used integer The number of 1 MB disk blocks currently in use on the node. For RG and RA3 node types, used blocks include both locally cached blocks and blocks persisted in Amazon S3.
capacity integer The total storage capacity provisioned for the node in 1 MB blocks. This capacity is the same as the total managed storage quota for the cluster. For more information about capacity by node type, see Node type details in the Amazon Redshift Management Guide.

Sample queries

Note

The results of the following examples vary based on the node specifications of your cluster. Add column capacity to your SQL SELECT to retrieve the capacity of your cluster.

The following query returns used space and total capacity in 1 MB disk blocks. This example ran on a two-node rg.12xlarge cluster.

select node, used from stv_node_storage_capacity order by node;

This query returns the following sample output. 


 node | used  
------+-------
    0 | 30591 
    1 | 27103