Inspect the result, its parameters and the SQL behind it.
Daily effective cost per provider, sub account, region and service, for spotting anomalous days. The full grain is about 20,000 rows for March 2026, so the result keeps the 500 rows with the largest absolute cost (every non-zero combination is about 1,200 rows, holding nearly all spend). AWS and Oracle effective_cost values in this sample are whole-dollar rounded, so many AWS rows show 0 effective cost.
The largest 7 series keep their own colors; the remaining series are combined as Other.
| Day | Provider name | Sub account id | Region id | Region name | Service name | Daily effective cost |
|---|---|---|---|---|---|---|
| 2026-03-12 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | -$121.00 |
| 2026-03-27 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | $104.00 |
| 2026-03-30 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | -$79.00 |
| 2026-03-17 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | -$74.00 |
| 2026-03-26 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | $72.00 |
| 2026-03-19 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | $51.00 |
| 2026-03-16 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | $48.00 |
| 2026-03-29 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | $39.00 |
| 2026-03-23 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | -$38.00 |
| 2026-03-21 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | -$37.00 |
| 2026-03-09 | Microsoft | /subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d | westus2 | West US 2 | Virtual Machines | $36.00 |
| 2026-03-25 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | $35.00 |
| 2026-03-04 | Microsoft | /subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d | westus2 | West US 2 | Azure SQL Database | $33.00 |
| 2026-03-18 | Microsoft | /subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d | westus2 | West US 2 | Azure SQL Database | $31.50 |
| 2026-03-15 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | -$31.00 |
| 2026-03-20 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | $31.00 |
| 2026-03-16 | Microsoft | /subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d | westus2 | West US 2 | SQL Database | $29.18 |
| 2026-03-12 | Microsoft | /subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d | westus2 | West US 2 | Azure SQL Database | $28.50 |
| 2026-03-18 | Microsoft | /subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d | westus2 | West US 2 | SQL Database | $27.00 |
| 2026-03-14 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | $26.00 |
| 2026-03-13 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | $25.00 |
| 2026-03-24 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | $25.00 |
| 2026-03-28 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | $22.00 |
| 2026-03-02 | Microsoft | /subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf42 | eastus2 | East US 2 | Azure Synapse Analytics | $21.02 |
| 2026-03-26 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | AmazonCloudWatch | $21.00 |
| 2026-03-18 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | -$20.00 |
| 2026-03-14 | Microsoft | /subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf42 | eastus2 | East US 2 | Azure Synapse Analytics | $17.50 |
| 2026-03-14 | Microsoft | /subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf42 | southcentralus | South Central US | Azure App Service | $14.40 |
| 2026-03-09 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | $14.00 |
| 2026-03-11 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | $13.00 |
| 2026-03-04 | Microsoft | /subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf42 | eastus2 | East US 2 | Storage Accounts | $11.15 |
| 2026-03-04 | Microsoft | /subscriptions/299611fd-f57d-4591-a2ce-b485ba0021cd | canadacentral | Canada Central | Virtual Machines | $10.66 |
| 2026-03-03 | Microsoft | /subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf42 | eastus2 | East US 2 | Azure Synapse Analytics | -$10.51 |
| 2026-03-08 | Microsoft | /subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf42 | eastus2 | East US 2 | Azure Synapse Analytics | $10.51 |
| 2026-03-18 | Microsoft | /subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf42 | eastus2 | East US 2 | Azure Synapse Analytics | -$10.50 |
| 2026-03-10 | Microsoft | /subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf42 | eastus | East US | Azure Load Testing | $10.00 |
| 2026-03-25 | AWS | 52305261521 | ap-northeast-1 | Japan | Amazon CloudFront | -$10.00 |
| 2026-03-02 | Microsoft | /subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d | westus2 | West US 2 | Virtual Machines | $9.60 |
| 2026-03-03 | Microsoft | /subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf42 | westcentralus | West Central US | Microsoft.Fabric | $9.60 |
| 2026-03-04 | Microsoft | /subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d | westus2 | West US 2 | Virtual Machines | $9.60 |
| 2026-03-12 | Microsoft | /subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf42 | westcentralus | West Central US | Microsoft.Fabric | $9.60 |
| 2026-03-14 | Microsoft | /subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d | westus2 | West US 2 | Virtual Machines | $9.60 |
| 2026-03-05 | Microsoft | /subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d | westus2 | West US 2 | Azure SQL Database | $8.50 |
| 2026-03-15 | Microsoft | /subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d | westus2 | West US 2 | SQL Database | $8.44 |
| 2026-03-07 | Microsoft | /subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf42 | eastus | East US | Azure DB for MySQL | -$8.21 |
| 2026-03-25 | AWS | 45038667490 | us-west-2 | US West (Oregon) | Amazon Relational Database Service | -$8.00 |
| 2026-03-11 | Microsoft | /subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d | westus2 | West US 2 | Azure SQL Database | $7.50 |
| 2026-03-01 | Microsoft | /subscriptions/9ec51cfd-5ca7-4d76-8101-dd0a4abc5674 | eastus | East US | Azure SQL Database | -$7.30 |
| 2026-03-03 | Microsoft | /subscriptions/ed570627-0265-4620-bb42-bae06bcfa914 | eastus | East US | SQL Database | $7.30 |
| 2026-03-07 | Microsoft | /subscriptions/9ec51cfd-5ca7-4d76-8101-dd0a4abc5674 | eastus | East US | Azure SQL Database | $7.30 |
| 2026-03-07 | Microsoft | /subscriptions/ed570627-0265-4620-bb42-bae06bcfa914 | eastus | East US | Azure SQL Database | $7.30 |
| 2026-03-11 | Microsoft | /subscriptions/9ec51cfd-5ca7-4d76-8101-dd0a4abc5674 | eastus | East US | SQL Database | $7.30 |
| 2026-03-13 | Microsoft | /subscriptions/9ec51cfd-5ca7-4d76-8101-dd0a4abc5674 | eastus | East US | SQL Database | $7.30 |
| 2026-03-17 | Microsoft | /subscriptions/9ec51cfd-5ca7-4d76-8101-dd0a4abc5674 | eastus | East US | SQL Database | -$7.30 |
| 2026-03-18 | Microsoft | /subscriptions/9ec51cfd-5ca7-4d76-8101-dd0a4abc5674 | eastus | East US | SQL Database | $7.30 |
| 2026-03-18 | Microsoft | /subscriptions/ed570627-0265-4620-bb42-bae06bcfa914 | eastus | East US | Azure SQL Database | $7.30 |
| 2026-03-18 | Microsoft | /subscriptions/ed570627-0265-4620-bb42-bae06bcfa914 | eastus | East US | SQL Database | $7.30 |
| 2026-03-15 | Microsoft | /subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf42 | southcentralus | South Central US | Azure App Service | $7.20 |
| 2026-03-03 | AWS | 69918885631 | us-east-1 | – | Datadog | $7.20 |
| 2026-03-03 | Microsoft | /subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf42 | southcentralus | South Central US | Azure App Service | $7.20 |
| 2026-03-20 | AWS | 69918885631 | us-east-1 | – | Datadog | $7.20 |
| 2026-03-21 | AWS | 69918885631 | us-east-1 | – | Datadog | $7.20 |
| 2026-03-30 | AWS | 69918885631 | us-east-1 | – | Datadog | $7.20 |
| 2026-03-13 | Microsoft | /subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d | westus2 | West US 2 | Virtual Machines | $7.18 |
| 2026-03-15 | Microsoft | /subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d | westus2 | West US 2 | Virtual Machines | $7.18 |
| 2026-03-22 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | $7.00 |
| 2026-03-13 | Microsoft | /subscriptions/9ec51cfd-5ca7-4d76-8101-dd0a4abc5674 | westus | West US | Virtual Machines | $6.93 |
| 2026-03-10 | Microsoft | /subscriptions/ed570627-0265-4620-bb42-bae06bcfa914 | eastus | East US | Virtual Machine Scale Sets | $6.86 |
| 2026-03-03 | Microsoft | /subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d | westus | West US | Virtual Machines | $6.62 |
| 2026-03-08 | Microsoft | /subscriptions/9ec51cfd-5ca7-4d76-8101-dd0a4abc5674 | eastus | East US | Virtual Machine Scale Sets | -$6.21 |
| 2026-03-05 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | $6.00 |
| 2026-03-09 | AWS | 69460568468 | us-west-2 | US West (Oregon) | Amazon Relational Database Service | $6.00 |
| 2026-03-10 | Oracle | ocid6.tenancy.oc6..aaaaaaaalnpeq6xok1okj8vknc9pzancima2g8bwvk2kk9jgwhgycacrie2q | – | us-sanjose-1 | COMPUTE | $6.00 |
| 2026-03-21 | AWS | 70077301883 | us-west-2 | US West (Oregon) | Amazon Elastic File System | -$6.00 |
| 2026-03-29 | AWS | 70077301883 | us-west-2 | US West (Oregon) | Amazon Elastic Compute Cloud | -$6.00 |
| 2026-03-01 | Microsoft | /subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf42 | ukwest | UK West | Virtual Machines | -$5.91 |
| 2026-03-19 | Microsoft | /subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf42 | eastus2 | East US 2 | Azure Synapse Analytics | -$5.68 |
| 2026-03-04 | Microsoft | /subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d | westus2 | West US 2 | SQL Database | $5.53 |
| 2026-03-05 | Microsoft | /subscriptions/ed570627-0265-4620-bb42-bae06bcfa914 | eastus | East US | Azure SQL Database | $5.28 |
| 2026-03-07 | Microsoft | /subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf42 | francecentral | France Central | Virtual Machines | $5.26 |
| 2026-03-14 | Microsoft | /subscriptions/9ec51cfd-5ca7-4d76-8101-dd0a4abc5674 | eastus | East US | Azure Kubernetes Service | -$5.10 |
| 2026-03-01 | AWS | 69918885631 | us-east-1 | – | Datadog | $5.04 |
| 2026-03-02 | AWS | 18938484842 | eu-central-1 | EU (Frankfurt) | Amazon Elastic Compute Cloud | $5.00 |
| 2026-03-03 | AWS | 11353890204 | us-east-1 | US East (N. Virginia) | Amazon Elastic Compute Cloud | -$5.00 |
| 2026-03-03 | AWS | 18938484842 | eu-central-1 | EU (Frankfurt) | Amazon Elastic Compute Cloud | $5.00 |
| 2026-03-04 | AWS | 18938484842 | ap-southeast-1 | Asia Pacific (Singapore) | Amazon Elastic Compute Cloud | $5.00 |
| 2026-03-06 | AWS | 18938484842 | ap-southeast-1 | Asia Pacific (Singapore) | Amazon Elastic Compute Cloud | $5.00 |
| 2026-03-09 | AWS | 18938484842 | eu-central-1 | EU (Frankfurt) | Amazon Elastic Compute Cloud | $5.00 |
| 2026-03-14 | AWS | 18938484842 | ap-southeast-1 | Asia Pacific (Singapore) | Amazon Elastic Compute Cloud | $5.00 |
| 2026-03-14 | AWS | 18938484842 | eu-central-1 | EU (Frankfurt) | Amazon Elastic Compute Cloud | $5.00 |
| 2026-03-18 | AWS | 18938484842 | ap-southeast-1 | Asia Pacific (Singapore) | Amazon Elastic Compute Cloud | $5.00 |
| 2026-03-23 | AWS | 18938484842 | us-east-1 | US East (N. Virginia) | AWS Config | $5.00 |
| 2026-03-24 | AWS | 18938484842 | ap-southeast-1 | Asia Pacific (Singapore) | Amazon Elastic Compute Cloud | $5.00 |
| 2026-03-25 | AWS | 18938484842 | eu-central-1 | EU (Frankfurt) | Amazon Elastic Compute Cloud | $5.00 |
| 2026-03-28 | AWS | 18938484842 | ap-southeast-1 | Asia Pacific (Singapore) | Amazon Elastic Compute Cloud | $5.00 |
| 2026-03-30 | AWS | 18938484842 | eu-central-1 | EU (Frankfurt) | Amazon Elastic Compute Cloud | $5.00 |
| 2026-03-13 | Microsoft | /subscriptions/9ec51cfd-5ca7-4d76-8101-dd0a4abc5674 | eastus | East US | Virtual Machine Scale Sets | -$4.86 |
| 2026-03-02 | Microsoft | /subscriptions/ed570627-0265-4620-bb42-bae06bcfa914 | eastus | East US | Azure SQL Database | $4.80 |
| 2026-03-03 | Microsoft | /subscriptions/ed570627-0265-4620-bb42-bae06bcfa914 | eastus | East US | Azure SQL Database | $4.80 |
| 2026-03-10 | Microsoft | /subscriptions/ed570627-0265-4620-bb42-bae06bcfa914 | eastus | East US | SQL Database | $4.80 |
Showing 100 of 500 rows. Scroll inside the table to see more.
Default parameters use the precomputed result, generated as the read-only focus_reader role.
select (charge_period_start at time zone 'UTC')::date as day,
provider_name as provider_name,
sub_account_id as sub_account_id,
region_id as region_id,
region_name as region_name,
service_name as service_name,
sum(effective_cost) as daily_effective_cost
from focus.cost_and_usage
where charge_period_start >= $1::timestamptz
and charge_period_end < $2::timestamptz
group by 1, provider_name, sub_account_id, region_id, region_name, service_name
order by abs(sum(effective_cost)) desc nulls last, day, provider_name, sub_account_id, service_name
limit 500Parameters: $1 = period_start, $2 = period_end
SELECT DATE(ChargePeriodStart) AS Day, ProviderName, SubAccountId, RegionId, RegionName, ServiceName, SUM(EffectiveCost) AS DailyEffectiveCost FROM focus_data_table WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ? GROUP BY DATE(ChargePeriodStart) AS StartDay, ProviderName, SubAccountId, RegionId, RegionName, ServiceName