Update budgets with billed costs

Source: FOCUS 1.0 sample
Result rows: 3
Status: Runs on sample
Execution: PrecomputedRead-only
Result snapshot (UTC): 2026-10-11

Summarizes actual billed costs by provider and billing period for updating budgets. Defaults select March 2026 billing periods; the strict end filter uses April 2 to include periods ending April 1, and the sample's populated billing currencies are USD.

Billed costs by billing period

Query results
Provider name	Billing period start	Billing period end	Total billed cost
AWS	2026-03-01	2026-04-01	$833.61
Microsoft	2026-03-01	2026-04-01	$567.21
Oracle	2026-03-01	2026-04-01	$23.53

3 rows. Scroll inside the table to see more.

Default parameters use the precomputed result, generated as the read-only focus_reader role.

Inspect Postgres SQL and original FOCUS SQL

Postgres SQL, as run

select
  provider_name as provider_name,
  billing_period_start as billing_period_start,
  billing_period_end as billing_period_end,
  sum(billed_cost) as total_billed_cost
from focus.cost_and_usage
where billing_period_start >= $1::timestamptz
  and billing_period_end < $2::timestamptz
group by provider_name, billing_period_start, billing_period_end
order by billing_period_start asc, provider_name asc, billing_period_end asc
limit 500

Parameters: $1 = billing_period_start, $2 = billing_period_end

Original FOCUS SQL

SELECT
  ProviderName,
  BillingPeriodStart,
  BillingPeriodEnd,
  SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ?
GROUP BY
  ProviderName,
  BillingPeriodStart,
  BillingPeriodEnd