Idle data warehouses: stop paying for a Redshift that nobody queries
6 min read · June 17, 2026 · TurboFinOps
A data warehouse is expensive per hour and often busy only during batch windows. Between runs — nights, weekends, the gap after a project ends — it can sit nearly idle while billing full compute. For multi-node clusters, that adds up fast.
The shape of warehouse waste
Warehouses are provisioned for the heaviest query and then left running continuously. Outside the batch window, connections drop to near zero and CPU flatlines, but the cluster keeps charging for every node-hour.
Because warehouses are central infrastructure, teams are nervous about touching them — so an over-provisioned or idle cluster persists far longer than an idle VM would.
Detecting idle compute
Low database connections combined with low CPU over a sustained window is a clear idle signal. A warehouse that is genuinely serving analysts shows bursts; an idle one shows a flat line.
Because the per-hour cost is high, even partial idleness is worth acting on — this is usually a high-severity finding, not a rounding error.
Pause, schedule or downsize
Modern warehouses can pause and retain data while charging only for storage. Schedule pause/resume around the batch window so you pay for compute only when queries run.
If a cluster is permanently oversized, reduce the node count or node type. If it is abandoned, snapshot and delete it.
Frequently asked questions
- Does pausing lose my data?
- No. On RA3-class Redshift, pausing retains your data and you pay only for storage while paused. Compute charges stop until you resume.
- What about BigQuery?
- BigQuery is consumption-priced rather than node-hour, so the waste there is inefficient queries and idle slot reservations — a query-pattern problem rather than an idle-instance one. The discipline is the same: stop paying for capacity you are not using.
See your own cloud waste in minutes
Connect AWS, Azure or GCP and get a read-only scan of your top savings opportunities — with verified savings receipts when you fix them.
Run a free cloud waste scan