# Postgres using 100% of CPU

**URL:** <https://meta.discourse.org/t/postgres-using-100-of-cpu/45261>\
**Category:** Self-hosting\
**Tags:** server-resources\
**Created:** [2016年六月5日 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:** 11

<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:** [2016年六月5日 23:53 UTC](https://meta.discourse.org/t/postgres-using-100-of-cpu/45261/11 "2016-06-05T23:53:49Z")

</div>

Yes, I updated the docker image yesterday, which is when this started happening.

I did

```
git pull
./launcher cleanup
./launcher rebuild app
./launcher cleanup

```

As for posts and topics, it has 17001 topics, with 178297 posts. They were imported from a phpBB install last year.

Anyway, it eventually got up to 16 instances of that query running, so I just killed them off. They haven’t returned in a few hours. I’ll check if it starts using CPU when that scheduled task starts again.

---

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