# Postgres using 100% of CPU

**URL:** https://meta.discourse.org/t/postgres-using-100-of-cpu/45261
**Category:** Self-hosting
**Tags:** server-resources
**Created:** [June 5, 2016, 12:19am UTC](https://meta.discourse.org/t/postgres-using-100-of-cpu/45261 "2016-06-05T00:19:26Z")
**Posts on this page:** 1
**Showing post:** 14

<div class="post-metadata">

### Author: ![MiG](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mig/32/119486_2.png) [@MiG](https://meta.discourse.org/u/MiG)
#### Post date: [June 6, 2016, 4:43pm UTC](https://meta.discourse.org/t/postgres-using-100-of-cpu/45261/14 "2016-06-06T16:43:30Z")

</div>

> [@Falco](#):
>
> Maybe running this can help:
> 
> VACUUM VERBOSE ANALYZE user\_actions;

That seems to have done the trick.

I killed the (16!) running processes and then ran that query, and it then manually triggered the Jobs::EnsureDbConsistency job from the sidekiq web interface. This time it took 5 seconds to run.

Fingers crossed.

Thanks everyone, for your assistance. Your time and attention is definitely appreciated!

---

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