# Query causing 400% CPU Load

**URL:** https://meta.discourse.org/t/query-causing-400-cpu-load/285542
**Category:** Bug
**Tags:** chat
**Created:** [November 15, 2023, 10:46am UTC](https://meta.discourse.org/t/query-causing-400-cpu-load/285542 "2023-11-15T10:46:49Z")
**Posts on this page:** 1
**Showing post:** 16

<div class="post-metadata">

### Author: ![sok777](https://avatars.discourse-cdn.com/v4/letter/s/82dd89/32.png) [@sok777](https://meta.discourse.org/u/sok777)
#### Post date: [November 20, 2023, 9:24am UTC](https://meta.discourse.org/t/query-causing-400-cpu-load/285542/16 "2023-11-20T09:24:27Z")

</div>

> [@RGJ](#):
>
> psql : `delete from chat_mentions where chat_message_id = X`

Yes we already tried this.

For reference these are our stats:

users: 239251  
chat\_channels: 2864  
chat\_drafts: 205  
chat\_mentions: 155527 -\>7500~  
chat\_messages: 390453  
chat\_threads: 25131  
chat\_message\_reactions: 5993  
user\_chat\_channel\_memberships: 158480

---

_[View the full topic](https://meta.discourse.org/t/query-causing-400-cpu-load/285542)._