Analyze costs of components of a resource
Using FOCUS data, an Engineer can deep dive on cost details for a single resource.
- Source
- FOCUS MCP snapshot
- FOCUS editions
- v1.0, v1.1, v1.2, v1.3, v1.4
- Queries
- 1
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
Analyze costs of components of a resource
Runs on sample- Source
- FOCUS 1.0 sample
- Result rows
- 5
- Status
- Runs on sample
- Execution
- Precomputed
- Result snapshot (UTC)
- 2026-10-11
Resource component costs
5 rows. Scroll inside the table to see more.
Inspect Postgres SQL and original FOCUS SQL
Postgres SQL, as run
select resource_id as resource_id,
resource_name as resource_name,
resource_type as resource_type,
charge_description as charge_description,
sku_id as sku_id,
sum(effective_cost) as total_effective_cost
from focus.cost_and_usage
where charge_period_start >= $1::timestamptz
and charge_period_end < $2::timestamptz
and resource_id = $3::text
group by resource_id, resource_name, resource_type, charge_description, sku_id
order by total_effective_cost desc nulls last, charge_description nulls last, sku_id nulls last, resource_id, resource_name nulls last, resource_type nulls last
limit 500Original FOCUS SQL
SELECT ResourceId, ResourceName, ResourceType, ChargeDescription, SkuId, SUM(EffectiveCost) AS TotalEffectiveCost FROM focus_data_table WHERE ChargePeriodStart >= ? AND ChargePeriodEnd < ? AND ResourceId=? GROUP BY ResourceId, ResourceName, ResourceType, ChargeDescription, SkuId
Columns used
Column names from the source use case.