High CPU usage
| От | |
|---|---|
| Тема | High CPU usage |
| Дата | |
| Msg-id | 005e01d8e4be$6a516cf0$3ef446d0$@1nar.com.tr обсуждение исходный текст |
| Ответы |
Re: High CPU usage
Re: High CPU usage Re: High CPU usage |
| Список | pgsql-general |
Hello,
I am using PostgreSQL v14.5 on Linux Debian 11.5. I recently observe very
high CPU usage on my Linux system as below
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+
COMMAND
2357756 postgres 20 0 2441032 2,3g 4 S 298,7 67,9 2114:58
Tspjzj2Z
I could not find any file named Tspjzj2Z on the file system. I could not
find PID number using below SQL
SELECT * FROM pg_stat_activity
I also see another suggestion like below to identify long running queries
SELECT max(now() - xact_start) FROM pg_stat_activity
WHERE state IN ('idle in transaction',
'active');
I get no long running query at all.
There is no replication of any kind. This is a single instance server which
alows certification login only.
I appreciate any help to figure this out.
Thanks & Regards,
Ertan
В списке pgsql-general по дате отправления: