Issue High CPU Usage postgres memory process

[c.vandervliet]

Server operating system version

AlmaLinux 9.2

Plesk version and microupdate number

v18.0.55_build1800230907.05 os_RedHat el9

Hello,
Our server reported high CPU usage for a postgres related process called "memory".
I'm not sure how to troubleshoot this as most posts related to memory are about ram usage instead of CPU usage.
Any clue what this or how to troubleshoot?

I already checked if there are any long running queries but there aren't any.

Thank you!

 

[Peter Debik]

"memory" is just a username like "mickey", "chap", "hal9000" or whatever. It does not mean "memory consumption".

 

[c.vandervliet]

"memory" is just a username like "mickey", "chap", "hal9000" or whatever. It does not mean "memory consumption".

That makes sense however how can I check why it is consuming so much CPU?

 

[Peter Debik]

Maybe you can find out more on what Postgres is doing by running this query from the Postgres command line?
> select * from pg_stat_activity;