linux查找postgre进程,postgresql数据库某一个进程占用大量CPU，问题排查详解

postgresql某一个进程占用大量

CPU，问题排查，目前服务器cpu为4核，内存8G

1.查下是不是我们的业务SQL

SELECT

procpid,

START,

now() - START AS lap,

current_query

FROM (SELECT

backendid,

pg_stat_get_backend_pid(S.backendid)            AS procpid,

pg_stat_get_backend_activity_start(S.backendid) AS START,

pg_stat_get_backend_activity(S.backendid)       AS current_query

FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS S) AS S

WHERE current_query <> '' AND procpid = 35500

ORDER BY lap DESC;

2.linux root shell下面执行updatedb

updatedb 是重建本地文件索引，没有影响

3.locate x2fca82f6

x2fca82f6是占用大量CPU的进程名称，大概是99%左右。

4.查询进程文件