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”: [Bild] 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:

Are there any jobs running? Try opening the following URL for your site: /sidekiq

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

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 [Bild] 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: [Bild] 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

Unterstützung Installation

MiG 25. August 2018 um 17:34 17

Ich antworte auf meinen eigenen Beitrag, weil mir mein Fehler aufgefallen ist

VACUUM VERBOSE ANALYZE funktioniert natürlich nur, wenn ich die Discourse-Datenbank auswähle

Thema		Antworten	Aufrufe
Postgres has 100% CPU for large databases, Discourse 2.7.7 Self-hosting server-resources	3	791	30. August 2021
Some queries that don't finish Support	16	1004	5. April 2019
Primary Postgres database process (postmaster) eating all CPU Self-hosting server-resources	13	4228	28. Mai 2020
Slow Sidekiq + Postmaster using 95%+ CPU (32 cores) after Postgresql Version Upgrade Self-hosting server-resources	22	3253	29. Mai 2020
Unusually high CPU usage Self-hosting	31	968	18. Februar 2026

Postgres using 100% of CPU

Verwandte Themen