# AWS Redshift Optimization | Cloud Efficiency Hub

Canonical: https://www.pointfive.co/efficiency-hub/cloud-services/aws-redshift

4 documented AWS Redshift cost inefficiencies, each with how to detect it and how to fix it.

[Cloud Efficiency Hub](https://www.pointfive.co/efficiency-hub) 

4 documented AWS Redshift cost inefficiencies, each with how to detect it and how to fix it.

## 4 inefficiencies

[All services](https://www.pointfive.co/efficiency-hub#browse-by-service)

- AWS Redshift  CER-0363

### [Inactive Redshift Provisioned Cluster](https://www.pointfive.co/efficiency-hub/inefficiencies/inactive-redshift-provisioned-cluster)

A provisioned Amazon Redshift cluster bills every compute node for every hour it is available, whether or not any query runs. Clusters created for a proof of concept, a migration, a one-off analysis or a reporting workload that has since...

Databases

- AWS Redshift  CER-0364

### [Missing Pause Schedule for Non-Production Redshift Provisioned Clusters](https://www.pointfive.co/efficiency-hub/inefficiencies/missing-pause-schedule-for-non-production-redshift-provisioned-clusters)

Development, test and staging Redshift provisioned clusters are typically used during working hours and by scheduled test runs, but they stay available around the clock because nobody set up a pause and resume schedule. Every night and...

Databases

- AWS Redshift  CER-0365

### [Low Reserved Node Coverage for Steady-State Redshift Provisioned Clusters](https://www.pointfive.co/efficiency-hub/inefficiencies/low-reserved-node-coverage-for-steady-state-redshift-provisioned-clusters)

Production Redshift provisioned clusters usually run continuously with a fixed node type and node count for long periods, which is exactly the usage pattern reserved nodes are designed for. When those nodes are billed at on-demand rates,...

Databases

- AWS Redshift  CER-0366

### [Overprovisioned Base Capacity in Redshift Serverless Workgroups](https://www.pointfive.co/efficiency-hub/inefficiencies/overprovisioned-base-capacity-in-redshift-serverless-workgroups)

Redshift Serverless bills compute in RPU-hours for the capacity in use while queries run, and the base capacity setting of a workgroup determines the capacity Redshift uses to serve queries. The default base capacity is 128 RPUs, and many...

Databases

## More AWS services

- [AWS EC2  23](https://www.pointfive.co/efficiency-hub/cloud-services/aws-ec2)

- [AWS RDS  19](https://www.pointfive.co/efficiency-hub/cloud-services/aws-rds)

- [AWS S3  15](https://www.pointfive.co/efficiency-hub/cloud-services/aws-s3)

- [AWS Lambda  12](https://www.pointfive.co/efficiency-hub/cloud-services/aws-lambda)

- [AWS EBS  10](https://www.pointfive.co/efficiency-hub/cloud-services/aws-ebs)

- [AWS CloudWatch  8](https://www.pointfive.co/efficiency-hub/cloud-services/aws-cloudwatch)

- [AWS EKS  8](https://www.pointfive.co/efficiency-hub/cloud-services/aws-eks)

- [AWS ElastiCache  8](https://www.pointfive.co/efficiency-hub/cloud-services/aws-elasticache)

- [AWS DynamoDB  7](https://www.pointfive.co/efficiency-hub/cloud-services/aws-dynamodb)

- [AWS Bedrock  6](https://www.pointfive.co/efficiency-hub/cloud-services/aws-bedrock)

---
Source: the public page above. Product screenshots and illustrative interfaces are examples, not live customer data.