FOCUSExplorer
Queries
Read-only sample

FOCUS 1.0 billing data. Reference snapshots are dated on each page.

Update budgets with billed costs

Inspect the result, its parameters and the SQL behind it.

← All queries
Source
FOCUS use-case library
Data
FOCUS 1.0 sample
Status
Runs on sample
Mode
Read-only
Library snapshot (UTC)
2026-10-08
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 nameBilling period startBilling period endTotal billed cost
AWS2026-03-012026-04-01$833.61
Microsoft2026-03-012026-04-01$567.21
Oracle2026-03-012026-04-01$23.53

3 rows. Scroll inside the table to see more.

Precomputed result

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