Inspect the result, its parameters and the SQL behind it.
Showing the first 20 categories. Open full screen to explore all 499 categories.
Showing 100 of 500 rows. Scroll inside the table to see more.
select coalesce(tags->>'application', '(untagged)') as application_id,
provider_name as provider_name,
billing_account_id as billing_account_id,
billing_account_name as billing_account_name,
billing_currency as billing_currency,
sum(billed_cost) as total_billed_cost
from focus.cost_and_usage
where billing_period_start >= $1::timestamptz
and billing_period_end < $2::timestamptz
group by 1, provider_name, billing_account_id, billing_account_name, billing_currency
order by abs(sum(billed_cost)) desc nulls last, application_id, provider_name
limit 500SELECT Tags["ApplicationId"], ProviderName, BillingAccountId, BillingAccountName, BillingCurrency, SUM(BilledCost) AS TotalBilledCost FROM focus_data_table WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ? GROUP BY Tags["ApplicationId"], ProviderName, BillingAccountId, BillingAccountName, BillingCurrency