Determine Effective Savings Rate
The Effective Savings Rate (ESR) is a KPI to track the efficiency of using commitment discounts. The KPI calculation is (Contracted Cost – Effective Cost) / Contracted Cost. Outcome: FinOps Practitioners are able to compute the ESR, which is (Contracted Cost – Effective Cost) / Contracted Cost.
- Source
- FOCUS MCP snapshot
- FOCUS editions
- v1.0, v1.1, v1.2
- Queries
- 1
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
This query uses the Provider column. Provider is deprecated in v1.3 and will be removed in v1.4.
Determine Effective Savings Rate
Runs on sample- Source
- FOCUS 1.0 sample
- Result rows
- 1
- Status
- Runs on sample
- Execution
- Precomputed
- Result snapshot (UTC)
- 2026-10-11
Effective savings rate
-3.89%
Effective savings rate
1 row. Scroll inside the table to see more.
Inspect Postgres SQL and original FOCUS SQL
Postgres SQL, as run
select sum(contracted_cost) as contracted_cost,
sum(effective_cost) as effective_cost,
(sum(contracted_cost) - sum(effective_cost)) / nullif(sum(contracted_cost), 0) as effective_savings_rate
from focus.cost_and_usage
where charge_period_start >= $1::timestamptz
and charge_period_end < $2::timestamptzOriginal FOCUS SQL
SELECT SUM(ContractedCost) AS ContractedCost, SUM(EffectiveCost) AS EffectiveCost, (SUM(ContractedCost) - SUM(EffectiveCost)) / NULLIF(SUM(ContractedCost), 0) AS EffectiveSavingsRate FROM focus_data_table WHERE ChargePeriodStart >= ? AND ChargePeriodEnd < ?
Columns used
Column names from the source use case.