High CPU usage

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

Responses

Browse pgsql-general by date

  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?