Nextcloud PostgreSQL high cpu usage

[el_pistolero]

Hello to the Cloudron community,

We have a problem with Cloudron and Nextcloud. Nextcloud is continuously very very slow and this during the whole day. After analyzing the logs and statistics in real time, it appears that the postgre content consumes a lot of cpu (often in overload up to 395%).

Have you ever seen this? If so, do you have a solution?

Server infos :
CPU : E3-1225v2 (4c/4t)
Ram : 16GB DDR3
HDD : softRaid 2x2ToC

Cloudron V : 6.1.2
Nextcloud V : 22.2.3

Nbr of users : 124

Users are usually connected via the desktop client with hard or virtual file synchronization (50/50).

Thank you for your feedback

Regards,

[girish]

@el_pistolero I feel I have seen this before. Usually to do with large oc_filecache . How many entries do you have in that table?

[girish]

Maybe related - https://help.nextcloud.com/t/high-postgresql-cpu-usage-on-nextcloud-server/124958 . Also, https://github.com/nextcloud/server/issues/15995 suggests maybe plugins also influence high CPU . What plugins do you have enabled on your nextcloud install?

[el_pistolero]

@girish Hi, thx for answer.

Queston for dummies like me, did you order it to see the number of entries in postgre?

Sorry, I'm not familiar with postgre.