From: | <ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr> |
---|---|
To: | <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | High CPU usage |
Date: | 2022-10-20 19:59:07 |
Message-ID: | 005e01d8e4be$6a516cf0$3ef446d0$@1nar.com.tr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2022-10-20 21:34:57 | Re: pg_restore 12 "permission denied for schema" errors |
Previous Message | Lists | 2022-10-20 19:51:39 | Re: PG RPMS for RHEL 9 on aarch64? |