Re: BUG #16542: High CPU Usage - Mailing list pgsql-bugs

From David Rowley
Subject Re: BUG #16542: High CPU Usage
Date
Msg-id CAApHDvqiQW7cMEum9UaBjv+DfO4YN3mv6XmnMUL-AgO_4mmdCQ@mail.gmail.com
Whole thread Raw
In response to BUG #16542: High CPU Usage  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
On Wed, 15 Jul 2020 at 19:16, PG Bug reporting form
<noreply@postgresql.org> wrote:
> I'm not sure if it's 12.0 as I installed it with "sudo apt-get install
> PostgreSQL" and only know that it is v12.x. Our VPS has a 3x vCore (3.70ghz)
> CPU but when we checked HTOP, we noticed that PostgreSQL was maxing out all
> 3 cores after sorting the list out by CPU Percentage. This is incredibly
> high and we don't know why it's being maxed out. You can view the HTOP
> results here: https://imgur.com/a/FxByiyX

There's no evidence here to suggest a bug yet.  If you connect to
PostgreSQL with psql, you can look at what each of those processes is
doing with:

SELECT * FROM pg_stat_activity;

Perhaps you just have some queries that are busy with something.

David



pgsql-bugs by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: BUG #16500: SQL Abend. select multi_key_columns_range_partition_table
Next
From: Etsuro Fujita
Date:
Subject: Re: BUG #16501: Incorrect result. select multi_key_columns_range_partition_table