Cold Case~65min

The Invoice For Compute Instances That Never Existed

CUST-08 was billed for 12 compute instances every month for May, June, and July 2024 — but provisioned_resources shows only 7 distinct instances were ever active in any of those months. The same 5-instance gap, every month, at $85/month each: $1,275.00 in phantom compute billed across the quarter. CUST-15 was billed for 10 instances in May and only 3 were running on any single spot-check day — but counting every distinct instance active at any point that month (a short autoscaling burst added 7 more for a few hours on May 15th) totals exactly 10. The bill matches the month's real usage.

Tables you'll query

customersprovisioned_resourcesinvoice_line_items

What you'll learn

JOINsAggregations & GROUP BYDate & Time Functions
Investigate this case →