Analyze costs by availability zone for a subaccount

This query uses the Provider column. Provider is deprecated in v1.3 and will be removed in v1.4.

Personas: Engineering
Capabilities: Usage Optimization

Analyze costs by availability zone for a subaccount

Runs on sample

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

Effective cost by region and availability zone for one subaccount. Rows with a null availability zone are regional or global charges. Microsoft rows in this anonymized sample carry numeric values in availability_zone, so pick an AWS subaccount (default 18938484842) for meaningful zones. Results are ordered by cost (largest first) rather than the source's name ordering so the chart shows the top zones.

Subaccount IDCharge period startCharge period end before

Effective cost by availability zone

Chart controls and notes

Showing the first 20 categories. Open full screen to explore all 35 categories.

The largest 7 series keep their own colors; the remaining series are combined as Other.

Query results
Provider name	Region name	Availability zone	Billing period start	Total effective cost
AWS	EU (Frankfurt)	eu-central-1a	2026-03-01	$20.00
AWS	Asia Pacific (Singapore)	ap-southeast-1b	2026-03-01	$15.00
AWS	Asia Pacific (Singapore)	ap-southeast-1c	2026-03-01	$10.00
AWS	Asia Pacific (Singapore)	ap-southeast-1a	2026-03-01	$5.00
AWS	Asia Pacific (Singapore)	–	2026-03-01	$5.00
AWS	EU (Frankfurt)	eu-central-1b	2026-03-01	$5.00
AWS	EU (Frankfurt)	eu-central-1c	2026-03-01	$5.00
AWS	EU (Frankfurt)	–	2026-03-01	$5.00
AWS	US East (N. Virginia)	–	2026-03-01	$5.00
AWS	US East (N. Virginia)	us-east-1b	2026-03-01	$3.00
AWS	US East (N. Virginia)	us-east-1c	2026-03-01	$3.00
AWS	US West (Oregon)	us-west-2a	2026-03-01	$3.00
AWS	US West (Oregon)	us-west-2c	2026-03-01	$3.00
AWS	Africa (Cape Town)	af-south-1c	2026-03-01	$2.00
AWS	Africa (Cape Town)	af-south-1a	2026-03-01	$1.00
AWS	US West (Oregon)	–	2026-03-01	$1.00
AWS	Africa (Cape Town)	–	2026-03-01	$0.00
AWS	Any	–	2026-03-01	$0.00
AWS	Asia Pacific	–	2026-03-01	$0.00
AWS	Asia Pacific (Mumbai)	ap-south-1a	2026-03-01	$0.00
AWS	Asia Pacific (Mumbai)	ap-south-1b	2026-03-01	$0.00
AWS	Asia Pacific (Mumbai)	ap-south-1c	2026-03-01	$0.00
AWS	Asia Pacific (Mumbai)	–	2026-03-01	$0.00
AWS	Asia Pacific (Osaka)	–	2026-03-01	$0.00
AWS	Asia Pacific (Seoul)	–	2026-03-01	$0.00
AWS	Asia Pacific (Sydney)	ap-southeast-2b	2026-03-01	$0.00
AWS	Asia Pacific (Sydney)	ap-southeast-2c	2026-03-01	$0.00
AWS	Asia Pacific (Sydney)	–	2026-03-01	$0.00
AWS	Asia Pacific (Tokyo)	ap-northeast-1a	2026-03-01	$0.00
AWS	Asia Pacific (Tokyo)	ap-northeast-1c	2026-03-01	$0.00
AWS	Asia Pacific (Tokyo)	ap-northeast-1d	2026-03-01	$0.00
AWS	Asia Pacific (Tokyo)	–	2026-03-01	$0.00
AWS	Canada	–	2026-03-01	$0.00
AWS	Canada (Central)	–	2026-03-01	$0.00
AWS	EU (Ireland)	–	2026-03-01	$0.00
AWS	EU (London)	eu-west-2a	2026-03-01	$0.00
AWS	EU (London)	eu-west-2b	2026-03-01	$0.00
AWS	EU (London)	eu-west-2c	2026-03-01	$0.00
AWS	EU (London)	–	2026-03-01	$0.00
AWS	EU (Paris)	–	2026-03-01	$0.00
AWS	EU (Stockholm)	–	2026-03-01	$0.00
AWS	Europe	–	2026-03-01	$0.00
AWS	External	–	2026-03-01	$0.00
AWS	India	–	2026-03-01	$0.00
AWS	Japan	–	2026-03-01	$0.00
AWS	Middle East	–	2026-03-01	$0.00
AWS	South Africa	–	2026-03-01	$0.00
AWS	South America	–	2026-03-01	$0.00
AWS	South America (Sao Paulo)	sa-east-1a	2026-03-01	$0.00
AWS	South America (Sao Paulo)	sa-east-1b	2026-03-01	$0.00
AWS	South America (Sao Paulo)	sa-east-1c	2026-03-01	$0.00
AWS	South America (Sao Paulo)	–	2026-03-01	$0.00
AWS	United States	–	2026-03-01	$0.00
AWS	US East (N. Virginia)	us-east-1	2026-03-01	$0.00
AWS	US East (N. Virginia)	us-east-1a	2026-03-01	$0.00
AWS	US East (N. Virginia)	us-east-1d	2026-03-01	$0.00
AWS	US East (N. Virginia)	us-east-1f	2026-03-01	$0.00
AWS	US East (Ohio)	us-east-2	2026-03-01	$0.00
AWS	US East (Ohio)	–	2026-03-01	$0.00
AWS	US West (N. California)	–	2026-03-01	$0.00
AWS	US West (Oregon)	us-west-2	2026-03-01	$0.00
AWS	US West (Oregon)	us-west-2b	2026-03-01	$0.00
AWS	US West (Oregon)	us-west-2d	2026-03-01	$0.00
AWS	–	–	2026-03-01	$0.00

64 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,
       region_name,
       availability_zone,
       billing_period_start,
       sum(effective_cost) as total_effective_cost
from focus.cost_and_usage
where sub_account_id = $1::text
  and charge_period_start >= $2::timestamptz
  and charge_period_end < $3::timestamptz
group by 1, 2, 3, 4
order by total_effective_cost desc nulls last, provider_name, region_name, availability_zone, billing_period_start
limit 500

Parameters: $1 = sub_account_id, $2 = period_start, $3 = period_end

Original FOCUS SQL

SELECT
  ProviderName,
  RegionName,
  AvailabilityZone,
  BillingPeriodStart,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE SubAccountId = ?
  AND ChargePeriodStart >= ? AND ChargePeriodEnd < ?
GROUP BY
  ProviderName,
  RegionName,
  AvailabilityZone,
  BillingPeriodStart
 ORDER BY ProviderName,
  RegionName,
  AvailabilityZone,
  BillingPeriodStart

Columns used

Column names from the source use case.

Read the source on focus.finops.org ↗