Analyze service costs by region

Personas: FinOps Practitioner

Analyze service costs by region v1.3

Adapted to v1.0

Source: FOCUS 1.0 sample
Result rows: 458
Status: Adapted to v1.0
Execution: PrecomputedRead-only
Result snapshot (UTC): 2026-10-11

Effective cost by service provider, region and service over the period. The source groups by hourly/daily ChargePeriodStart, which yields thousands of groups here; this translation rolls charge periods up to the month (the sample is essentially March 2026) so all region/service groups fit in the result.

Column adaptations (1)

Effective cost by region

Chart controls and notes

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

Query results
Charge month	Service provider name	Region id	Service name	Total effective cost
2026-03-01	AWS	us-east-1	Amazon Elastic Compute Cloud	$139.00
2026-03-01	Microsoft	westus2	Azure SQL Database	$119.13
2026-03-01	Microsoft	westus2	Virtual Machines	$108.00
2026-03-01	Microsoft	westus2	SQL Database	$70.15
2026-03-01	Datadog Inc.	us-east-1	Datadog	$40.32
2026-03-01	Microsoft	eastus	SQL Database	$38.57
2026-03-01	Microsoft	westus	Virtual Machines	$34.93
2026-03-01	AWS	eu-central-1	Amazon Elastic Compute Cloud	$31.00
2026-03-01	Microsoft	eastus2	Azure Synapse Analytics	$30.25
2026-03-01	AWS	ap-southeast-1	Amazon Elastic Compute Cloud	$30.00
2026-03-01	Microsoft	eastus	Azure SQL Database	$29.62
2026-03-01	Microsoft	southcentralus	Azure App Service	$28.80
2026-03-01	AWS	us-east-1	AmazonCloudWatch	$21.00
2026-03-01	Microsoft	westcentralus	Microsoft.Fabric	$19.20
2026-03-01	Oracle	–	COMPUTE	$18.00
2026-03-01	AWS	us-west-2	Amazon Elastic Compute Cloud	$14.00
2026-03-01	Microsoft	eastus	Virtual Machines	$13.96
2026-03-01	Microsoft	eastus2	Storage Accounts	$11.26
2026-03-01	Microsoft	canadacentral	Virtual Machines	$10.66
2026-03-01	Microsoft	eastus	Azure Load Testing	$10.00
2026-03-01	AWS	us-west-2	Amazon Relational Database Service	$9.00
2026-03-01	Microsoft	centralus	Virtual Network	$8.81
2026-03-01	Microsoft	eastus	Azure Kubernetes Service	$8.62
2026-03-01	Microsoft	francecentral	Virtual Machines	$7.64
2026-03-01	Microsoft	centralus	Azure App Service	$7.18
2026-03-01	Microsoft	eastus2	Azure Machine Learning	$5.05
2026-03-01	Microsoft	southcentralus	Virtual Machines	$5.03
2026-03-01	Microsoft	eastus2	Azure Container Instances	$5.02
2026-03-01	AWS	ap-southeast-1	Amazon Elastic File System	$5.00
2026-03-01	AWS	eu-central-1	Amazon Elastic File System	$5.00
2026-03-01	AWS	us-east-1	AWS Config	$5.00
2026-03-01	Microsoft	uksouth	Azure Monitor	$4.70
2026-03-01	Microsoft	eastasia	Virtual Machines	$4.27
2026-03-01	Microsoft	southcentralus	Azure ExpressRoute	$4.19
2026-03-01	Microsoft	eastus	Azure Monitor	$4.05
2026-03-01	AWS	ap-southeast-1	Amazon CloudFront	$4.00
2026-03-01	AWS	us-west-2	Amazon Simple Storage Service	$4.00
2026-03-01	Microsoft	centralus	Azure DB for MySQL	$3.69
2026-03-01	AWS	af-south-1	Amazon Elastic Compute Cloud	$3.00
2026-03-01	AWS	us-east-1	Amazon CloudFront	$3.00
2026-03-01	AWS	us-east-2	Amazon Elastic Container Service for Kubernetes	$3.00
2026-03-01	AWS	us-west-2	Elastic Load Balancing	$3.00
2026-03-01	Oracle	–	OPENSEARCH	$3.00
2026-03-01	Microsoft	centralus	Virtual Machines	$2.54
2026-03-01	Microsoft	eastus	Virtual Network	$2.34
2026-03-01	Microsoft	centralus	Storage Accounts	$2.11
2026-03-01	AWS	us-west-2	AmazonCloudWatch	$2.00
2026-03-01	Oracle	–	ODSP	$2.00
2026-03-01	Microsoft	westus	Virtual Network	$1.32
2026-03-01	Microsoft	eastasia	Storage Accounts	$1.29
2026-03-01	Microsoft	ukwest	Virtual Machines	$1.22
2026-03-01	Microsoft	westus2	Azure Private Link	$1.11
2026-03-01	AWS	eu-west-1	Amazon CloudFront	$1.00
2026-03-01	AWS	us-east-1	Amazon Elastic Container Service for Kubernetes	$1.00
2026-03-01	AWS	us-west-2	AWS Config	$1.00
2026-03-01	Microsoft	northeurope	Storage Accounts	$0.97
2026-03-01	Microsoft	eastus2	Load Balancer	$0.72
2026-03-01	Microsoft	centralus	Azure Private Link	$0.72
2026-03-01	Microsoft	northcentralus	Storage Accounts	$0.65
2026-03-01	Microsoft	global	Microsoft Defender for Cloud	$0.65
2026-03-01	Microsoft	westus	Load Balancer	$0.60
2026-03-01	Microsoft	canadaeast	Storage Accounts	$0.53
2026-03-01	Microsoft	northcentralus	Virtual Machines	$0.39
2026-03-01	Microsoft	eastus	Storage Accounts	$0.36
2026-03-01	Microsoft	eastus2	Virtual Machines	$0.32
2026-03-01	Microsoft	centralus	Azure SQL Database	$0.28
2026-03-01	Microsoft	southcentralus	Virtual Network	$0.27
2026-03-01	Microsoft	westus2	Virtual Network	$0.19
2026-03-01	Microsoft	koreacentral	Storage Accounts	$0.17
2026-03-01	Microsoft	eastus2	Azure Container Registry	$0.17
2026-03-01	Microsoft	southeastasia	Azure Site Recovery	$0.16
2026-03-01	Microsoft	ukwest	Storage Accounts	$0.15
2026-03-01	Microsoft	southeastasia	Storage Accounts	$0.11
2026-03-01	Microsoft	canadaeast	Virtual Network	$0.10
2026-03-01	Microsoft	eastasia	Virtual Network	$0.10
2026-03-01	Microsoft	ukwest	Virtual Network	$0.09
2026-03-01	Microsoft	westus2	Microsoft.Fabric	$0.08
2026-03-01	Microsoft	westus2	Storage Accounts	$0.08
2026-03-01	Microsoft	westus	Key Vault	$0.02
2026-03-01	Microsoft	global	Azure DNS	$0.02
2026-03-01	Microsoft	global	Azure Private Link	$0.02
2026-03-01	Microsoft	eastus	Key Vault	$0.00816
2026-03-01	Microsoft	canadacentral	Storage Accounts	$0.00663
2026-03-01	Microsoft	eastus	Application Gateway	$0.00146
2026-03-01	Microsoft	westus	Azure Monitor	$0.00112
2026-03-01	Microsoft	southcentralus	Storage Accounts	$0.00109
2026-03-01	Microsoft	westus	Logic Apps	$0.00025
2026-03-01	Microsoft	eastus2	Key Vault	$0.000123
2026-03-01	Microsoft	eastus	Azure Data Factory	$0.00008
2026-03-01	Microsoft	westus	Event Grid	$0.0000408
2026-03-01	Microsoft	brazilsouth	Storage Accounts	$0.0000341
2026-03-01	Microsoft	eastus2	Event Grid	$0.0000306
2026-03-01	Microsoft	northcentralus	Azure Monitor	$0.00002
2026-03-01	Microsoft	westus2	Azure Data Factory	$0.00002
2026-03-01	Microsoft	eastus2euap	Storage Accounts	$0.0000169
2026-03-01	Microsoft	westcentralus	Storage Accounts	$0.0000162
2026-03-01	Microsoft	norwayeast	Storage Accounts	$0.0000115
2026-03-01	Microsoft	francecentral	Storage Accounts	$0.00000873
2026-03-01	Microsoft	eastus	Event Grid	$0.0000054
2026-03-01	Microsoft	westus	Service Bus	$0.00000205

Showing 100 of 458 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 date_trunc('month', charge_period_start at time zone 'UTC') as charge_month,
       case when publisher_name is not null and publisher_name is distinct from invoice_issuer_name then publisher_name else provider_name end as service_provider_name,
       region_id as region_id,
       service_name as service_name,
       sum(effective_cost) as total_effective_cost
from focus.cost_and_usage
where charge_period_start >= $1::timestamptz
  and charge_period_end < $2::timestamptz
group by 1, 2, 3, 4
order by charge_month, total_effective_cost desc nulls last, service_provider_name, region_id nulls last, service_name nulls last
limit 500

Parameters: $1 = period_start, $2 = period_end

Original FOCUS SQL

SELECT
  ChargePeriodStart,
  ServiceProviderName,
  RegionId,
  ServiceName,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
GROUP BY
  ChargePeriodStart,
  ServiceProviderName,
  RegionId,
  ServiceName
ORDER BY ChargePeriodStart,
  SUM(EffectiveCost) DESC

Columns used

Column names from the source use case.

Read the source on focus.finops.org ↗