# Postgres using 100% of CPU

**URL:** <https://meta.discourse.org/t/postgres-using-100-of-cpu/45261>\
**Category:** Self-hosting\
**Tags:** server-resources\
**Created:** [5 juni 2016 om 00:19 UTC](https://meta.discourse.org/t/postgres-using-100-of-cpu/45261 "2016-06-05T00:19:26Z")\
**Posts on this page:** 1\
**Showing post:** 15

<div class="post-metadata">

**Author:** ![semyoshin](https://avatars.discourse-cdn.com/v4/letter/s/d78d45/32.png) [@semyoshin](https://meta.discourse.org/u/semyoshin)\
**Post date:** [18 juni 2018 om 09:00 UTC](https://meta.discourse.org/t/postgres-using-100-of-cpu/45261/15 "2018-06-18T09:00:16Z")

</div>

Hi to everyone,

I have the same problem, and the trick with VACUUM did’t help.

I have a lot of connections running “DELETE FROM user\_actions…” and it seems that this SQL query never ends.

The table is rather big, over 9 millions,

Any help or advice is highly appreciated,

---

_[View the full topic](https://meta.discourse.org/t/postgres-using-100-of-cpu/45261)._
