查看Docker the server heap size

docker exec -it worker-openerp java -XshowSettings:vm -version

查看細節
docker exec -t openerp java -XX:+PrintFlagsFinal -version | grep HeapSize

再看docker JVM 佔 docker memory的百分比

docker exec -it openerp java -XX:+PrintFlagsFinal -version | grep MaxRAMPercentage

    double MaxRAMPercentage                         = 25.000000 


如果 docker的配置是
docker run -d \
    --memory=20g \

所有 dokcer jvm的內存是 20g * 25% = 5g

异常情况

ID   NAME    CPU    MEM USAGE/LIMIT      MEM%       NET / I O               BLOCK I / O       PIDS

ce    open     0.31%   3.54GiB   /  20GiB       17.7%     8.67GB / 6.79GB     6.32MB / 633MB    69

刚启动正常

ID   NAME    CPU    MEM USAGE/LIMIT      MEM%       NET / I O               BLOCK I / O       PIDS
ce   open      0.31%     2.976GiB / 20GiB      14.88%    627MB / 532MB     54.4MB / 69.8MB   66

查询异常SQL（runtime 》>5mins）

SELECT
    procpid,
    usename,
    datname,
    current_query,
    query_start,
    age(clock_timestamp(), query_start) AS running_time
FROM pg_stat_activity

WHERE 
  datname = 'E**'
  AND query_start IS NOT NULL
  AND age(clock_timestamp(), query_start) > interval '5 minutes'
  
ORDER BY running_time DESC;