Hi there, I’m seeing an issue on my docker install. It’s on Linode on Ubuntu 14.04. Postgres is using 100% of the CPU. The forum itself is working just fine, version v1.6.0.beta7 +156. Doesn’t seem any slower or anything. Here’s a screen capture from “htop”: [image] Any pointers on how I can…

Replying to my own post, because I realized my mistake :slight_smile: VACUUM VERBOSE ANALYZE only works if I select the discourse database, of course :slight_smile:

Doesn’t look like anything else is running. [image] [image] [image] [image]

Ok, there is one job in the “scheduler” tab that is running. Jobs::EnsureDbConsistency 41 minutes ago RUNNING -1ms _scheduler_localhost-app:29119:1:29c83b7cc82551f6a2b801e82a1acb38 [image] Should I just wait that out? Seems like it’s checking the database?

To see exactly what queries are being executed you can run something like the following from the console: cd /var/discourse/ ./launcher enter app sudo -u postgres psql -c "select * from pg_stat_activity WHERE state='active'"; Try running this a couple of times with a 3/4 minute wait in-between, ca…

Ok, looks like it’s running 3 copies of this query (with 3 different pids) DELETE FROM user_actions USING user_actions ua2 WHERE ( user_actions.action_type = ua2.action_type AND user_actions.user_id = ua2.user_id AND user_actions.acting_user_id = ua2.acting_user_id AND user_actions.target_p…

Yes, you’ll need to let those queries run, because otherwise the scheduler will just keep spawning them and you’ll be playing whack-a-mole with them forever.

Do they start every x minutes or something like that? I currently have 5 of them running … Up from 3 a few hours ago.

Well, this morning we’re up to a load average of 12 :slight_smile: [image] But it does appear to have moved on from the “DELETE” queries, and is running others. I assume this is some sort of database check. The forum is still responsive with this load, so I’ll let it proceed for a while. Seems…

Are you running on our latest docker image? How many posts does your forum have?

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 …

Postgres using 100% of CPU

Support Self-hosting

DeanMarkTaylor (Dean Taylor) June 5, 2016, 12:25am 2

Are there any jobs running?

Try opening the following URL for your site:
/sidekiq

Topic		Replies	Views
Postgres has 100% CPU for large databases, Discourse 2.7.7 Self-hosting server-resources	3	842	August 30, 2021
Some queries that don't finish Support	16	1036	April 5, 2019
Primary Postgres database process (postmaster) eating all CPU Self-hosting server-resources	13	4403	May 28, 2020
Slow Sidekiq + Postmaster using 95%+ CPU (32 cores) after Postgresql Version Upgrade Self-hosting server-resources	22	3496	May 29, 2020
Unusually high CPU usage Self-hosting	31	1316	February 18, 2026

Postgres using 100% of CPU

Related topics