High CPU on Postgres process

Question

Hi, please help to have a look about this issue on my odoo server running for 5 years.
It seems that postgres process consumes high CPU recently, and the CPU usage is reached to 100% all the time. Here is the htop result below, PID 12765 of postgres process is 67.3%, but nobody is using the server.
Image [1]

Try to fix:
run this command:  sudo -u postgres psql -c " SELECT pid,        now() - query_start AS duration,        left(query,120) AS sql,        state FROM pg_stat_activity WHERE state='

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,
The root cause appears to be a long-running PostgreSQL query on the sale_order_line and sale_order tables. This query is consuming a large amount of CPU resources, which explains why the system is consistently reaching 100% CPU. The below steps may help you to solve the problem:
The below query will list all active queries and focus only on the one that has been running unusually long:
SELECT pid,
now() - query_start AS duration,
usename,
application_name,
client_addr,
state,
left(query,150)

Этот вопрос был отмечен

Не оставайтесь в стороне – присоединяйтесь к обсуждению!