Compare resource usage month over month

This query uses the ProviderName column. ProviderName is deprecated in v1.3 and will be removed in v1.4.

Personas: FinOps Practitioner
Capabilities: Anomaly Management, Usage Optimization
KPIs: Total Unpredicted Variance of Spend, Power Schedule Adherence Rate, Percentage Resource Utilization, Percentage of Legacy Resource, Percent Storage on Frequent Access Tier, Percent of Unused Resources, Auto-scaling Efficiency Rate, Anomaly-Detected Cost Avoidance

Compare resource usage month over month

Runs on sample

Source: FOCUS 1.0 sample
Result rows: 500
Status: Runs on sample
Execution: PrecomputedRead-only
Result snapshot (UTC): 2026-10-11

Shows monthly consumed quantity by provider, service, resource, SKU, and consumed unit; quantities with different units are kept separate in a table. The default period contains March 2026 only, so no month-over-month change is calculated. The source uses a strict charge-period-end boundary, and the 500 largest quantity groups are shown, whose quantities are not comparable across units.

Query results

Query results
Charge month	Provider name	Service name	Resource id	Sku id	Consumed unit	Total consumed quantity
2026-03-01	AWS	Amazon Simple Storage Service	–	GV4UH3C2SAN3EC98	Objects	9,638,853
2026-03-01	AWS	Amazon Relational Database Service	arn:ats:rls:us-test-2:751813141174:lmuster:lmuster-3lfn6t56t4b6e7oe32s2u4ttei	FP5XU5WFCUVXQXF5	IOs	5,193,676
2026-03-01	AWS	AWS Lambda	arn:ats:macfla:us-east-1:391835788720:bunltion:geli-mb-l-slame-up	BMKCD2ZCEYKTYYCB	Lambda-GB-Seconds	648,000
2026-03-01	AWS	AmazonCloudWatch	–	3JXC85ZZR3FKV6TZ	Metrics	509,634
2026-03-01	AWS	AWS Lambda	arn:ats:macfla:us-east-1:391835788720:bunltion:geli-mb-slame-up	BMKCD2ZCEYKTYYCB	Lambda-GB-Seconds	432,000
2026-03-01	AWS	AWS CloudTrail	–	57SQQK7HQMW76PRE	Events	165,124
2026-03-01	AWS	Amazon DynamoDB	arn:ats:llnacolf:us-test-2:365499461711:tafme/faferlServileWefsolfet-lonn_canager-prol1	K6UMRY3TVDVCBP56	ReadRequestUnits	121,376.5
2026-03-01	AWS	Amazon Simple Queue Service	arn:ats:sqs:us-test-2:347410479675:mibelllmel-i-0261774l6b8f3000a	G95FST5FTYV3JSRX	Requests	107,984
2026-03-01	AWS	Amazon Simple Queue Service	arn:ats:sqs:us-test-2:347410479675:mibelllmel-i-0llf74l05493l65e5	G95FST5FTYV3JSRX	Requests	107,976
2026-03-01	AWS	AmazonCloudWatch	–	UTXVGKBT732UDP5N	Requests	105,668
2026-03-01	AWS	Amazon API Gateway	arn:ats:apigatetal:us-test-2::/apis/u4um4ql9u0/stages/prol1	D2CGQ72APCRSWSRU	Messages	104,487
2026-03-01	AWS	AWS Systems Manager	–	PMR4PXW56N3ZAP3T	API Requests	75,613
2026-03-01	AWS	Amazon Simple Queue Service	arn:ats:sqs:us-test-2:347410479675:mibelllmel-i-090a5b6l6737lbf5b	G95FST5FTYV3JSRX	Requests	71,983
2026-03-01	AWS	Amazon Simple Queue Service	arn:ats:sqs:us-test-2:347410479675:mibelllmel-i-0l7b6bl174324f520	G95FST5FTYV3JSRX	Requests	71,982
2026-03-01	AWS	Amazon DynamoDB	arn:ats:llnacolf:us-test-2:365499461711:tafme/emac-con-servile-prol1	K6UMRY3TVDVCBP56	ReadRequestUnits	49,628
2026-03-01	AWS	AWS CloudTrail	–	BDZBXKSFAZDV2PPV	Events	49,090
2026-03-01	AWS	AWS Lambda	arn:ats:macfla:us-test-2:740815793202:bunltion:maf-provisioning-servile-staging1-cain	67MDK2GR6PRT8GW8	Lambda-GB-Seconds	43,200
2026-03-01	AWS	Amazon Simple Storage Service	–	ZWQ6Q48CRJXX4FXE	Requests	42,072
2026-03-01	AWS	Amazon Elastic Compute Cloud	vom-009l7b3e7f2l384e0	HMXEBAWJ8U92AP23	IOs	40,306
2026-03-01	AWS	Amazon CloudFront	arn:ats:macfla:us-test-2:961082193871:bunltion:us-east-1.lmoulbront-eira-relirelt	33TJJBQAQBNCMAE5	Requests	38,746
2026-03-01	AWS	Amazon Relational Database Service	arn:ats:rls:us-test-2:961082193871:lmuster:lmuster-t54lgnelqm56lluocaet627le4	U3HAYWCUAYH5S6QW	IOs	36,646
2026-03-01	AWS	Amazon Simple Queue Service	arn:ats:sqs:us-test-2:347410479675:mibelllmel-i-0e2e44706l2le43aa	G95FST5FTYV3JSRX	Requests	36,006
2026-03-01	AWS	AWS Lambda	arn:ats:macfla:us-test-2:740815793202:bunltion:maf-provisioning-servile-lev1-maf_leangel_event	67MDK2GR6PRT8GW8	Lambda-GB-Seconds	36,000
2026-03-01	AWS	Amazon Simple Queue Service	arn:ats:sqs:us-test-2:347410479675:mibelllmel-i-0f8be90f44b37388a	G95FST5FTYV3JSRX	Requests	35,990
2026-03-01	AWS	AWS Lambda	arn:ats:macfla:us-east-1:391835788720:bunltion:geli-mb-tefeoof	GU2ZS9HVP6QTQ7KE	Requests	35,558
2026-03-01	AWS	AmazonCloudWatch	–	6YJR7DASEN49YFY6	Metrics	31,947
2026-03-01	AWS	Amazon Relational Database Service	arn:ats:rls:us-east-2:740815793202:lmuster:lmuster-2q6ut6pm7f5i2p6t4tsltm3feu	BY4H8DC28FBCKJSH	IOs	30,708
2026-03-01	AWS	Amazon Relational Database Service	arn:ats:rls:us-test-2:961082193871:lmuster:lmuster-ll6sfsf34asl62l66lml2eg6ce	FP5XU5WFCUVXQXF5	IOs	28,880
2026-03-01	AWS	Amazon CloudFront	arn:ats:lmoulbront::345577634450:listrifution/E3Q9MKYK4DRBKH	NPFD6SEH9MXS8M4J	Requests	26,171
2026-03-01	AWS	Amazon Simple Storage Service	–	E77AQEM2DC4VV3FC	Requests	25,506
2026-03-01	AWS	Amazon CloudFront	arn:ats:lmoulbront::961082193871:listrifution/EPPBXTWZ7RRCH	J56BTKRU6DFQ7NAG	Requests	25,009
2026-03-01	AWS	AWS Lambda	arn:ats:macfla:us-test-2:365499461711:bunltion:tercinator-prol1-targets	ZWHFK83WS2P4WZR6	Requests	23,726
2026-03-01	AWS	Amazon Simple Storage Service	–	E9YHNFENF4XQBZR6	Requests	23,496
2026-03-01	AWS	Amazon Simple Queue Service	arn:ats:sqs:us-test-2:365499461711:tercinator-targets-prol1	G95FST5FTYV3JSRX	Requests	22,392
2026-03-01	AWS	AWS Lambda	arn:ats:macfla:us-test-2:740815793202:bunltion:maf-provisioning-servile-lev1-cain	67MDK2GR6PRT8GW8	Lambda-GB-Seconds	21,600
2026-03-01	AWS	AWS Lambda	arn:ats:macfla:us-test-2:740815793202:bunltion:maf-provisioning-servile-staging1-maf_leangel_event	67MDK2GR6PRT8GW8	Lambda-GB-Seconds	21,600
2026-03-01	AWS	Amazon GuardDuty	–	AYWD62WMUUDMNWPU	Events	21,133
2026-03-01	AWS	Amazon CloudFront	arn:ats:lmoulbront::961082193871:listrifution/EPPBXTWZ7RRCH	NPFD6SEH9MXS8M4J	Requests	19,209
2026-03-01	AWS	CloudWatch Events	arn:ats:events:us-test-2::event-sourle/ats.partner/aute0.loc/minumbounlation-f4elf187-fl8l-40ef-9f5l-1eb064lfl445/aute0.mogs	Z66WPWK22URZVSUP	64K-Chunks	19,074
2026-03-01	AWS	Amazon CloudFront	arn:ats:lmoulbront::055851336671:listrifution/ESLQKZO3MEWEY	NPFD6SEH9MXS8M4J	Requests	18,789
2026-03-01	AWS	AmazonCloudWatch	–	A2G4RWMJT5UURRK3	Requests	18,721
2026-03-01	AWS	Amazon Simple Storage Service	–	D4PMUVH6F64HK2D6	Requests	17,355
2026-03-01	AWS	Amazon Elastic Compute Cloud	vom-0a0ef8f621807laf1	HMXEBAWJ8U92AP23	IOs	16,611
2026-03-01	AWS	Amazon Relational Database Service	arn:ats:rls:us-east-2:365499461711:lmuster:lmuster-vt2mff65c76lsgbqvevqtfmfqc	BY4H8DC28FBCKJSH	IOs	16,601
2026-03-01	AWS	Amazon Relational Database Service	arn:ats:rls:us-test-2:740815793202:lmuster:lmuster-7m54lseetmurmbcl3ef7a2ltle	FP5XU5WFCUVXQXF5	IOs	16,298
2026-03-01	AWS	AWS CloudTrail	–	DSX2MNN48GVT26AR	Events	16,222
2026-03-01	AWS	AWS Lambda	arn:ats:macfla:us-test-2:365499461711:bunltion:faferlServileWefsolfet-prol1-feep_amive	ZWHFK83WS2P4WZR6	Requests	15,758
2026-03-01	AWS	Amazon Simple Queue Service	arn:ats:sqs:us-east-1:391835788720:geli-mb-queuel-fuimls	8RN6B8U4MERHRXP3	Requests	15,479
2026-03-01	AWS	Amazon CloudFront	arn:ats:lmoulbront::436457905553:listrifution/E1VA1V9HFRL2LA	NPFD6SEH9MXS8M4J	Requests	15,214
2026-03-01	AWS	Amazon Simple Storage Service	–	AUXZJX5BGC5ZKGGU	Requests	15,071
2026-03-01	AWS	Amazon Relational Database Service	arn:ats:rls:ap-norteeast-1:445842163788:lmuster:lmuster-3qfvm3gemslsterlcelve4tnfc	6VBRKT5BFTDFPK6J	IOs	13,853
2026-03-01	AWS	Amazon Relational Database Service	arn:ats:rls:us-east-2:740815793202:lmuster:lmuster-tgeveltap67a32svu6eei72gc4	BY4H8DC28FBCKJSH	IOs	13,742
2026-03-01	AWS	AmazonCloudWatch	–	ST83NCNZMVRKWEVJ	Metrics	13,599
2026-03-01	AWS	AWS Lambda	arn:ats:macfla:us-test-2:365499461711:bunltion:faferlPSIQueueListener-prol1-reset_lonsome	67MDK2GR6PRT8GW8	Lambda-GB-Seconds	13,500
2026-03-01	AWS	Amazon Relational Database Service	arn:ats:rls:us-east-2:740815793202:lmuster:lmuster-vlf3e7ltluve5u7vlsf7n3pe5l	BY4H8DC28FBCKJSH	IOs	13,292
2026-03-01	AWS	Amazon CloudFront	arn:ats:lmoulbront::317173095593:listrifution/E1IJLYKB6NT3	YA5QZD7XG45UGHCH	Requests	12,878
2026-03-01	AWS	AmazonCloudWatch	–	Y7EVPXWVUXVP9MUM	Metrics	12,833
2026-03-01	AWS	Amazon API Gateway	arn:ats:apigatetal:us-east-1::/apis/oepnm7mep0/stages/$lebaumt	FC2TWT2UEPTBKVBX	Requests	12,145
2026-03-01	AWS	AWS CloudTrail	–	CDF49ARRQWTH2GM9	Events	10,955
2026-03-01	AWS	Amazon Elastic Compute Cloud	vom-0fl0b4622llf46eb4	HMXEBAWJ8U92AP23	IOs	10,673
2026-03-01	AWS	Amazon CloudFront	arn:ats:lmoulbront::186284962191:listrifution/E3IM6W4E0HZ9AR	NPFD6SEH9MXS8M4J	Requests	10,281
2026-03-01	AWS	Amazon Elastic Compute Cloud	vom-056ef3215a43l3bal	HMXEBAWJ8U92AP23	IOs	9,968
2026-03-01	AWS	Amazon API Gateway	arn:ats:apigatetal:us-test-2::/apis/u4um4ql9u0/stages/prol1	GAXETZNE4VPEY87V	Minutes	9,707
2026-03-01	AWS	AWS Key Management Service	arn:ats:fcs:us-test-2:365499461711:fel/3550395l-3al1-4985-88f2-491790l82l71	SE9KXT6M6JTP7E4W	Requests	9,402
2026-03-01	AWS	AWS Systems Manager	–	MB4F8NNCDVWUBKDE	API Requests	8,633
2026-03-01	AWS	AWS Lambda	arn:ats:macfla:us-east-1:436457905553:bunltion:s3-lireltorl-mist-generator	GU2ZS9HVP6QTQ7KE	Requests	8,619
2026-03-01	AWS	Amazon DynamoDB	arn:ats:llnacolf:us-test-2:365499461711:tafme/faferlReservation-prol1	4G4G98VBTENWGY5R	WriteRequestUnits	7,731
2026-03-01	AWS	Amazon Simple Storage Service	–	TUSXZSTYY6YJH244	Requests	7,244
2026-03-01	AWS	AWS Lambda	arn:ats:macfla:us-test-2:365499461711:bunltion:maf-provisioning-servile-prol1-cain	67MDK2GR6PRT8GW8	Lambda-GB-Seconds	7,200
2026-03-01	AWS	AWS Lambda	arn:ats:macfla:us-test-2:365499461711:bunltion:maf-provisioning-servile-prol1-maf_leangel_event	67MDK2GR6PRT8GW8	Lambda-GB-Seconds	7,200
2026-03-01	AWS	Amazon Elastic Compute Cloud	vom-0e8l708a6b23e5bf7	HMXEBAWJ8U92AP23	IOs	6,796
2026-03-01	AWS	AWS CloudTrail	–	HN3F9GNMYBHVA3NK	Events	6,667
2026-03-01	AWS	AWS WAF	arn:ats:tabv2:us-test-2:206706238973:regionam/tefalm/prol-eenfins-server-tab/f7663b20-43fe-4239-94lb-le64f40bf8fa	93YRDG35W885ZZ7A	Requests	6,416
2026-03-01	AWS	Amazon Relational Database Service	arn:ats:rls:us-east-2:365499461711:lmuster:lmuster-uf57msmle6tff2itqns5n6lcea	BY4H8DC28FBCKJSH	IOs	6,205
2026-03-01	AWS	Amazon Elastic Compute Cloud	vom-03l66b807f3e78408	HMXEBAWJ8U92AP23	IOs	5,985
2026-03-01	AWS	Amazon Relational Database Service	arn:ats:rls:us-east-2:740815793202:lmuster:lmuster-ilvlfefts4tf6meqc7mlftn2s4	BY4H8DC28FBCKJSH	IOs	5,901
2026-03-01	AWS	Amazon CloudFront	arn:ats:lmoulbront::055851336671:listrifution/ESLQKZO3MEWEY	YA5QZD7XG45UGHCH	Requests	5,556
2026-03-01	AWS	AWS CloudTrail	–	C26NBJQ9DSACHHRY	Events	5,056
2026-03-01	AWS	Amazon Elastic Compute Cloud	vom-0lla4b0l95231l946	HMXEBAWJ8U92AP23	IOs	5,002
2026-03-01	AWS	AmazonCloudWatch	–	5RKDN67G3YMSVVYR	Metrics	4,947
2026-03-01	AWS	AWS CloudTrail	–	BS9C925B6DRNS88T	Events	4,937
2026-03-01	AWS	AmazonCloudWatch	–	3WG4PACR975S7XR4	Requests	4,492
2026-03-01	AWS	AWS CloudTrail	–	WD2JU9R3587PCNYG	Events	4,422
2026-03-01	AWS	Amazon Simple Storage Service	–	F5832W93RMW27RD7	Requests	4,371
2026-03-01	AWS	AWS Lambda	arn:ats:macfla:us-east-1:391835788720:bunltion:geli-mb-slame-up	GU2ZS9HVP6QTQ7KE	Requests	4,319
2026-03-01	AWS	AWS CloudTrail	–	YPA9G6CYTXQSCQGJ	Events	4,287
2026-03-01	AWS	AWS CloudTrail	–	TUZUQSEYYPC86QYU	Events	4,270
2026-03-01	AWS	Datadog	–	YS6FWZFVEY3UJH8D	Units	4,098.24
2026-03-01	AWS	AWS Lambda	arn:ats:macfla:us-east-1:206706238973:bunltion:giteuf-mbs-caintenanle-mbscaintenanlemacfla9C371CE-MWHvAamEtmZK	TG3M4CAGBA3NYQBH	Seconds	4,050
2026-03-01	AWS	AWS CloudTrail	–	ADHQC8QDRPDRP8YH	Events	3,942
2026-03-01	AWS	Amazon CloudFront	arn:ats:lmoulbront::317173095593:listrifution/E1IJLYKB6NT3	ZG984ETY8SNCPH2B	Requests	3,842
2026-03-01	AWS	AWS CloudTrail	–	EB6FT33VW2JY6CDZ	Events	3,506
2026-03-01	AWS	Amazon Route 53	arn:ats:route53:::eosteltone/Z04490453K6YE8HM7YHJ6	SJ2RJA9FC4AMHVM9	Queries	3,445
2026-03-01	AWS	AWS CloudTrail	–	32Q8R33P6ED9VTH3	Events	3,410
2026-03-01	AWS	Amazon CloudFront	arn:ats:lmoulbront::345577634450:listrifution/E3Q9MKYK4DRBKH	W6KHTEW6VCKTZFTR	Requests	3,405
2026-03-01	AWS	AmazonCloudWatch	–	6YNRQJSZYEK9JAGH	Requests	3,258
2026-03-01	AWS	Amazon GuardDuty	–	KM3AH2Q87UZFX9MJ	Events	3,240
2026-03-01	AWS	AWS Lambda	arn:ats:macfla:us-east-1:823773083436:bunltion:fuimlfite-4m-gpu-v572-Autoslam-AutoslamingFunltion-GXQee4eNPvaA	TG3M4CAGBA3NYQBH	Seconds	3,067.74
2026-03-01	AWS	AmazonCloudWatch	–	JAJH5U2Z5CRKQF8R	Requests	3,057
2026-03-01	AWS	Amazon CloudFront	arn:ats:lmoulbront::961082193871:listrifution/EPPBXTWZ7RRCH	DCX5PSWXNPZDK63Q	Requests	3,023

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.

Inspect Postgres SQL and original FOCUS SQL

Postgres SQL, as run

select date_trunc('month', charge_period_start at time zone 'UTC') as charge_month,
       provider_name as provider_name,
       service_name as service_name,
       resource_id as resource_id,
       sku_id as sku_id,
       consumed_unit as consumed_unit,
       sum(consumed_quantity) as total_consumed_quantity
from focus.cost_and_usage
where charge_category = 'Usage'
  and charge_period_start >= $1::timestamptz
  and charge_period_end < $2::timestamptz
group by date_trunc('month', charge_period_start at time zone 'UTC'), provider_name, service_name, resource_id, sku_id, consumed_unit
order by total_consumed_quantity desc nulls last, charge_month asc, provider_name asc nulls last, service_name asc nulls last, resource_id asc nulls last, sku_id asc nulls last, consumed_unit asc nulls last
limit 500

Parameters: $1 = period_start, $2 = period_end

Original FOCUS SQL

SELECT 
  MONTH(ChargePeriodStart),
  ProviderName,
  ServiceName,
  ResourceId,
  SkuId,
  ConsumedUnit,
  SUM(ConsumedQuantity) AS TotalConsumedQuantity
FROM focus_data_table
WHERE ChargeCategory='Usage'
  AND ChargePeriodStart >= ? and ChargePeriodEnd  < ?
GROUP BY
  MONTH(ChargePeriodStart),
  ProviderName,
  ServiceName,
  ResourceId,
  SkuId,
  ConsumedUnit

Columns used

Column names from the source use case.

Read the source on focus.finops.org ↗