Inspect the result, its parameters and the SQL behind it.
Showing the first 20 categories. Open full screen to explore all 50 categories.
Showing 100 of 500 rows. Scroll inside the table to see more.
select 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,
sub_account_id as sub_account_id,
region_id as region_id,
region_name as region_name,
count(1) as row_count
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 row_count desc, service_provider_name, sub_account_id nulls last, region_id nulls last, region_name nulls last
limit 500SELECT ServiceProviderName, SubAccountId, RegionId, RegionName, COUNT(1) FROM focus_data_table WHERE ChargePeriodStart >= ? AND ChargePeriodEnd < ? GROUP BY ServiceProviderName, SubAccountId, RegionId, RegionName