Analyze costs of components of a resource
Inspect the result, its parameters and the SQL behind it.
- Source
- FOCUS use-case library
- Data
- FOCUS 1.0 sample
- Status
- Runs on sample
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
Loading sample results
Inspect the result, its parameters and the SQL behind it.
5 rows. Scroll inside the table to see more.
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 500SELECT 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