• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Issue High CPU Usage postgres memory process

c.vandervliet

New Pleskian
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!
 

Attachments

  • 1695625190179.png
    1695625190179.png
    118.7 KB · Views: 7
"memory" is just a username like "mickey", "chap", "hal9000" or whatever. It does not mean "memory consumption".
 
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;
 
Back
Top