Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
odoo CPU Postgres
1 Vastaa
908 Näkymät
Avatar
Jiashun Chen

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.


Try to fix:

  1. 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='active'
ORDER BY query_start;"


and showing this below, but i don't know how to fix it. please help.

Avatar
Hylkää
Jiashun Chen
Tekijä

Thanks. will try it.

Avatar
Cybrosys Techno Solutions Pvt.Ltd
Paras vastaus

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) AS query

FROM pg_stat_activity

WHERE state = 'active'

ORDER BY query_start;


Hope it helps

Avatar
Hylkää