Analyze cost per compute service for a subaccount

Personas: Engineering
Capabilities: Usage Optimization
KPIs: Effective Average Compute Cost per Core, Percent of Compute Spend Covered by Commitment Discounts, Percentage of Legacy Resource, Percentage Resource Utilization

Analyze cost per compute service for a subaccount

Runs on sample

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

Lists compute resources in one sub account with their pricing quantity and effective cost over the window, highest cost first. The default is the Azure subscription with the most compute effective cost, since AWS effective costs in this sample are whole-dollar rounded.

Sub accountCharge period startCharge period end before

Compute resources by effective cost

Chart controls and notes

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

Query results
First charge period start	Last charge period end	Service name	Resource id	Resource name	Total pricing quantity	Monthly effective cost
2026-03-08	2026-03-16	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/ahbtest/providers/microsoft.compute/virtualmachines/sqlahbonvm	SQLAHBonVM	114	$51.19
2026-03-02	2026-03-17	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/ahbtest/providers/microsoft.compute/virtualmachines/sqlvmstandard	sqlvmstandard	72	$28.80
2026-03-06	2026-03-19	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/ahbtest/providers/microsoft.compute/disks/sqlahbonvm_datadisk_0	SQLAHBonVM_DataDisk_0	0.07	$8.19
2026-03-03	2026-03-07	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/firearrow/providers/microsoft.compute/virtualmachines/ramban	ramban	65.63	$6.99
2026-03-17	2026-03-20	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/ahbtest/providers/microsoft.compute/disks/sqlvmstandard_datadisk_1	sqlvmstandard_DataDisk_1	0.06	$6.83
2026-03-01	2026-03-13	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/mynewresourcegroup/providers/microsoft.compute/disks/mytestvmdl_osdisk_1_d4a07ceac0954f2e9e945dd392ad9746	MytestVMDL_OsDisk_1_d4a07ceac0954f2e9e945dd392ad9746	0.07	$1.31
2026-03-05	2026-03-18	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/acm-demo01/providers/microsoft.compute/virtualmachines/jupiterlander	jupiterlander	20.98	$1.23
2026-03-12	2026-03-19	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/az2demovm2_group/providers/microsoft.compute/virtualmachines/az2demovm2	AZ2DemoVM2	48	$0.96
2026-03-12	2026-03-16	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/capres_test/providers/microsoft.compute/virtualmachines/az1-demovm1	AZ1-DemoVM1	48	$0.96
2026-03-01	2026-03-18	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/acm-demo01/providers/microsoft.compute/virtualmachines/venuslander	venuslander	12	$0.83
2026-03-03	2026-03-19	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/capres_test/providers/microsoft.compute/virtualmachines/az2demovm1	AZ2DemoVM1	11	$0.64
2026-03-10	2026-03-11	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/ahbtest/providers/microsoft.compute/disks/sqlvmstandard_osdisk_1_45d2477fec0e49c7a67ff1c91a8ecad5	sqlvmstandard_OsDisk_1_45d2477fec0e49c7a67ff1c91a8ecad5	0.03	$0.60
2026-03-09	2026-03-15	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/costmanagement-rest-rg/providers/microsoft.compute/disks/marketplacebyoltest2_osdisk_1_8907aee9042745b785e8f4f98dad9e1f	MarketplaceBYOLTest2_OsDisk_1_8907aee9042745b785e8f4f98dad9e1f	0.07	$0.43
2026-03-11	2026-03-12	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/ahbtest/providers/microsoft.compute/virtualmachines/sqlahbonvm	SQLAHBONVM	19	$0.38
2026-03-03	2026-03-04	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/firearrow/providers/microsoft.compute/disks/ramban_osdisk_1_f6622e6580774923af8112b78f5d2b06	ramban_OsDisk_1_f6622e6580774923af8112b78f5d2b06	0.07	$0.35
2026-03-11	2026-03-12	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/mar-ccm/providers/microsoft.compute/virtualmachines/mar-ccm-vm01	MAR-CCM-VM01	14	$0.28
2026-03-03	2026-03-04	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/firearrow/providers/microsoft.compute/virtualmachines/ramban	RAMBAN	12	$0.24
2026-03-11	2026-03-12	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/capres_test/providers/microsoft.compute/disks/az1demovm2_osdisk_1_a54283b0695a49b0b2ee5731431e611e	AZ1DemoVM2_OsDisk_1_a54283b0695a49b0b2ee5731431e611e	0.03	$0.16
2026-03-17	2026-03-18	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/capres_test/providers/microsoft.compute/virtualmachines/az1-demovm1	AZ1-DEMOVM1	6	$0.12
2026-03-17	2026-03-18	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/capres_test/providers/microsoft.compute/virtualmachines/az1demovm2	AZ1DEMOVM2	6	$0.12
2026-03-07	2026-03-14	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/mar-ccm/providers/microsoft.compute/disks/mar-ccm-vm01_osdisk_1_d0beead4b6ff4b4088a687701d355d61	mar-ccm-vm01_OsDisk_1_d0beead4b6ff4b4088a687701d355d61	0.07	$0.10
2026-03-05	2026-03-16	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/mar-ccm/providers/microsoft.compute/virtualmachines/mar-ccm-vm01	mar-ccm-vm01	0.05	$0.00317
2026-03-13	2026-03-20	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/capres_test/providers/microsoft.compute/virtualmachines/az1demovm2	az1demovm2	0.04	$0.00295
2026-03-04	2026-03-17	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/az2demovm2_group/providers/microsoft.compute/virtualmachines/az2demovm2	az2demovm2	0.03	$0.0023
2026-03-05	2026-03-16	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/capres_test/providers/microsoft.compute/virtualmachines/az1-demovm1	az1-demovm1	0.02	$0.00186
2026-03-04	2026-03-11	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/capres_test/providers/microsoft.compute/virtualmachines/az2demovm1	az2demovm1	0.02	$0.00184
2026-03-05	2026-03-10	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/ahbtest/providers/microsoft.compute/virtualmachines/sqlahbonvm	sqlahbonvm	0.02	$0.000985
2026-03-06	2026-03-16	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d/resourcegroups/awsconnectos/providers/microsoft.compute/virtualmachines/justinwb-test	justinwb-test	0	$0.00000322

28 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 min(charge_period_start) as first_charge_period_start,
       max(charge_period_end) as last_charge_period_end,
       service_name as service_name,
       resource_id as resource_id,
       resource_name as resource_name,
       sum(pricing_quantity) as total_pricing_quantity,
       sum(effective_cost) as monthly_effective_cost
from focus.cost_and_usage
where sub_account_id = $1::text
  and service_category = 'Compute'
  and charge_period_start >= $2::timestamptz
  and charge_period_end < $3::timestamptz
group by service_name, resource_id, resource_name
order by monthly_effective_cost desc nulls last, resource_id
limit 500

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

Original FOCUS SQL

SELECT
  Min(ChargePeriodStart),
  Max(ChargePeriodEnd),
  ServiceName,
  ResourceId,
  ResourceName,
  SUM(PricingQuantity),
  SUM(EffectiveCost) AS MonthlyEffectiveCost
FROM focus_data_table
WHERE SubAccountId = ?
  AND ServiceCategory = 'Compute'
  AND ChargePeriodStart >= ? and ChargePeriodEnd  < ?
GROUP BY
  ServiceName,
  ResourceId,
  ResourceName
ORDER BY MonthlyEffectiveCost DESC

Columns used

Column names from the source use case.

Read the source on focus.finops.org ↗