How can I find out the storage usage of a Redshift cluster?

0

I'm trying to estimate how much it will cost to enable AWS Backup across several Redshift clusters. How can I find out the total storage usage of a Redshift Cluster using the AWS API?

Blaine
demandé il y a 2 ans773 vues
1 réponse
0

This metric is not directly available but can be calculated using Cloudwatch get-metric-statistics and Redshift describe-clusters

aws cloudwatch get-metric-statistics --region <your-cluster-region> --metric-name PercentageDiskSpaceUsed --namespace AWS/Redshift --statistics Maximum --dimensions="Name=ClusterIdentifier,Value=<your-cluster-identifier>" --start-time <yyyy-mm-ddThh:mi:ss> --end-time <yyyy-mm-ddThh:mi:ss> --period 3600

This will give you PercentageDiskSpaceUsed in Percentage example 2.098025

aws redshift describe-clusters --cluster-identifier <your-cluster-identifier> --region <your-cluster-region>

This will give you TotalStorageCapacityInMegaBytes example 4000000

From these two values you will calculate 2.098025 percent of 4000000 to get storage usage in MB between the start time and end time. This should be a good estimate of the backup size for that cluster.

profile pictureAWS
EXPERT
répondu il y a 2 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions