2

I have a database with a shared Throughput of 400. This database contains two containers.

When I run the following query on one of these containers, I get charged for 1183 RUs :

SELECT VALUE COUNT(1) FROM c where c.GroupClaim = 'None'

GroupClaim is the partition key of the container.

How can a 1183 RUs query do not get rejected/throttled when I have a Throughput set to 400 ?

Here is a screen of my query stats :

David Makogon
  • 69,407
  • 21
  • 141
  • 189
Anthony Hocquet
  • 348
  • 1
  • 3
  • 9

1 Answers1

3

I can't explain why your query costs so much but... if you run a query that exceeds subscribed RU/sec, Cosmos DB will complete the query. But now you'll be "in debt" and you'll be throttled until your debt is paid off.

In your case, you're over the 400 by just over 700 (your debt), so you'll see the throttle time period be somewhere between 2 and 3 seconds (since you would have 1200 RU available over a 3-second period, per your service tier).

David Makogon
  • 69,407
  • 21
  • 141
  • 189