Description

The cost explorer API calls can timeout when a very large number of accounts exist.

Detail

This is likely related to us performing a rank() window function over each account for each day in the queried time range. This does not timeout on the Overview page, even with a large number of accounts, because we are doing the rank only once over the aggregated month time range, not individually for each day.

Potential Solution

We could consider pre-computing the daily ranks by cost for account so we can bypass the API-time window function calculations.