Re: BUG #16542: High CPU Usage

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: BUG #16542: High CPU Usage
Дата
Msg-id CAApHDvqiQW7cMEum9UaBjv+DfO4YN3mv6XmnMUL-AgO_4mmdCQ@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #16542: High CPU Usage  (PG Bug reporting form <noreply@postgresql.org>)
Список 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 по дате отправления:

Предыдущее
От: Etsuro Fujita
Дата:
Сообщение: Re: BUG #16500: SQL Abend. select multi_key_columns_range_partition_table
Следующее
От: Etsuro Fujita
Дата:
Сообщение: Re: BUG #16501: Incorrect result. select multi_key_columns_range_partition_table