From: Julien Rouhaud <rjuju123@gmail.com>
To: thien.phan@apollo.edu.vn
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17645: Strange queries that stuck in database system
Date: Mon, 17 Oct 2022 16:15:16 +0800
Message-ID: <20221017081516.g2elezml2fppsubf@jrouhaud> (raw)
In-Reply-To: <17645-7cbc0f9bf94bb2a6@postgresql.org>
References: <17645-7cbc0f9bf94bb2a6@postgresql.org>
Hi,
On Sun, Oct 16, 2022 at 11:43:24PM +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 17645
> Logged by: Thien, Phan Phuoc
> Email address: thien.phan@apollo.edu.vn
> PostgreSQL version: 14.0
Unrelated, but you should definitely update to the latest minor version (so
14.5 right now).
> Operating system: Windows Server 2012 R2
> Description:
>
> When I run this query
>
> SELECT NOW() - query_start AS elapsed, pid, client_addr, query,
> query_start, *
> FROM pg_stat_activity
> WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
> ORDER BY query_start DESc;
>
> I noticed that there are many queries (as below) that create many Windows
> processes and CPU is 100%. Is it a bug? Please help!
Nothing here looks like a bug. Note that your query is incorrect as there's a
dedicated "state" field to give this information since version 9.2, so a bit
more than 10 years ago. You can refer to
https://www.postgresql.org/docs/14/monitoring-stats.html#MONITORING-PG-STAT-ACTIVITY-VIEW
for more details about this view.
I'm not sure if you had question related to the rest of the message, but if you
do please send a message to pgsql-general list instead
(https://www.postgresql.org/list/).
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: rjuju123@gmail.com, thien.phan@apollo.edu.vn, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17645: Strange queries that stuck in database system
In-Reply-To: <20221017081516.g2elezml2fppsubf@jrouhaud>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox