FOCUSExplorer
Queries
Read-only sample

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

Report costs by service category

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
35
Status
Runs on sample
Execution
PrecomputedRead-only
Result snapshot (UTC)
2026-10-11

Billed cost by provider, billing currency, billing period and service category. The strict billing-period-end filter defaults to April 2 so the March 2026 period (ending April 1) is included.

Billed cost by service category

Query results
Provider nameBilling currencyBilling period startService categoryTotal billed cost
AWSUSD2026-03-01Compute$506.73
MicrosoftUSD2026-03-01Compute$169.03
MicrosoftUSD2026-03-01Databases$144.15
MicrosoftUSD2026-03-01Other$139.82
AWSUSD2026-03-01Storage$109.74
AWSUSD2026-03-01Databases$69.48
AWSUSD2026-03-01Other$60.49
AWSUSD2026-03-01Networking$45.31
AWSUSD2026-03-01Management and Governance$39.42
MicrosoftUSD2026-03-01Web$35.98
MicrosoftUSD2026-03-01Analytics$19.28
OracleUSD2026-03-01Compute$18.01
MicrosoftUSD2026-03-01Storage$17.63
MicrosoftUSD2026-03-01Networking$16.85
MicrosoftUSD2026-03-01Developer Tools$10.00
MicrosoftUSD2026-03-01Management and Governance$8.75
MicrosoftUSD2026-03-01AI and Machine Learning$5.05
OracleUSD2026-03-01Web$2.60
OracleUSD2026-03-01–$2.49
AWSUSD2026-03-01Security$1.06
AWSUSD2026-03-01Identity$0.73
MicrosoftUSD2026-03-01Security$0.67
AWSUSD2026-03-01Migration$0.30
OracleUSD2026-03-01Storage$0.27
AWSUSD2026-03-01Integration$0.24
AWSUSD2026-03-01Business Applications$0.11
OracleUSD2026-03-01Others$0.11
OracleUSD2026-03-01Identity$0.06
AWSUSD2026-03-01Developer Tools$0.0037
MicrosoftUSD2026-03-01Integration$0.000355
AWSUSD2026-03-01Analytics$0.00018
AWSUSD2026-03-01Web$0.00
OracleUSD2026-03-01Networking$0.00
Oracle–2026-03-01Storage$0.00
Oracle–2026-03-01–$0.00

35 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_currency as billing_currency,
       billing_period_start as billing_period_start,
       service_category as service_category,
       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_currency, billing_period_start, service_category
order by total_billed_cost desc nulls last, provider_name, billing_period_start, service_category nulls last
limit 500

Parameters: $1 = billing_period_start, $2 = billing_period_end

Original FOCUS SQL

SELECT
  ProviderName,
  BillingCurrency,
  BillingPeriodStart,
  ServiceCategory,
  SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE BillingPeriodStart >= ? and BillingPeriodEnd < ?
GROUP BY
  ProviderName,
  BillingCurrency,
  BillingPeriodStart,
  ServiceCategory
ORDER BY TotalBilledCost DESC