# Thousands of user api requests and invalidation

**URL:** <https://meta.discourse.org/t/thousands-of-user-api-requests-and-invalidation/279791>\
**Category:** Support\
**Created:** [September 22, 2023, 1:20pm UTC](https://meta.discourse.org/t/thousands-of-user-api-requests-and-invalidation/279791 "2023-09-22T13:20:20Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![simon](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/simon/32/339122_2.png) [@simon](https://meta.discourse.org/u/simon)\
**Post date:** [September 22, 2023, 11:40pm UTC](https://meta.discourse.org/t/thousands-of-user-api-requests-and-invalidation/279791/4 "2023-09-22T23:40:55Z")

</div>

That seems like too many requests to be coming from the DiscourseHub app. If you have the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) installed on your site, I’d be curious about the results of this query:

```sql
SELECT
application_name,
COUNT(application_name) AS user_count
FROM user_api_keys
GROUP BY application_name

```

I tested that query on my own test site, but it only has one `user_api_request` from the DiscourseHub app. I _think_ I’ve structured the query correctly for dealing with multiple users connecting to Discourse from multiple apps, but let me know if anything in the results seems off.

---

_[View the full topic](https://meta.discourse.org/t/thousands-of-user-api-requests-and-invalidation/279791)._
