High CPU usage - Mailing list pgsql-general

From
Subject High CPU usage
Date
Msg-id 005e01d8e4be$6a516cf0$3ef446d0$@1nar.com.tr
Whole thread Raw
Responses Re: High CPU usage
Re: High CPU usage
Re: High CPU usage
List 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 by date:

Previous
From: Lists
Date:
Subject: Re: PG RPMS for RHEL 9 on aarch64?
Next
From: Ron
Date:
Subject: Re: pg_restore 12 "permission denied for schema" errors