Feedback-ID: i0fe9450f:Fastmail
Date: Thu, 4 Sep 2025 09:25:00 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: zhouenbing <zhouenbing@sunwoda-evb.com>,
	pgsql-bugs@lists.postgresql.org
Subject: Re: empty,query_id, pg_stat_activity
Message-ID: <aLjcXPixsn8XltZv@paquier.xyz>
References: <000a01dc1beb$8837b910$98a72b30$@sunwoda-evb.com>
 <CAKAnmmKn9Q0Kw6qiQu1dvW1hkq0twOCsX4AO9=Xbk56cOh1aJw@mail.gmail.com>
 <000201dc1c76$7d36e320$77a4a960$@sunwoda-evb.com>
 <CAKAnmmL=dtnV5JxmrJNM=dFnQXRb6U3ah0E=bwxSD_+iDPv=ag@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="S1n7bqj9JrK+C9IX"
Content-Disposition: inline
In-Reply-To: 
 <CAKAnmmL=dtnV5JxmrJNM=dFnQXRb6U3ah0E=bwxSD_+iDPv=ag@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/aLjcXPixsn8XltZv%40paquier.xyz>
Precedence: bulk


--S1n7bqj9JrK+C9IX
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Wed, Sep 03, 2025 at 04:54:27PM -0400, Greg Sabino Mullane wrote:
> The session is active, but there is no I/O yet, as the query has arrived,
> but has not been parsed yet. The queryid appears right before the query
> actually executes, so a lack of queryid is a safe indicator that the query
> is not actually doing any work yet- it's still spinning up. From a
> performance monitoring standpoint, you should be safe to exclude rows with
> no queryid.

Yeah, and there's likely no point in feeding the data of
pg_stat_activity to a CTAS, something that pg_stat_statements does for
most people these days.

FWIW, I use queries based on pg_stat_activity for monitoring purposes
in benchmarks to get aggregated values about wait events, to be able
to grab patterns, most of the time.  Filtering out query IDs would
lead to less information gathered.  You did not mention why
pg_stat_activity coupled with a query ID would be useful for you,=20
especially since we have a bunch of pgstats views that are able to get
aggregated data for the user, as well, to grab for bottlenecks, like
pg_stat_io, etc.
--
Michael

--S1n7bqj9JrK+C9IX
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmi43FwACgkQnvQgOdby
QH3Oug/+KT9LB+jgen+zqhGsj73TskWiIUw/H3UwyFREKw6WArLoIX9TaufRihQg
5Wfs877vAapzaDWS2qxLWmr4Q3QOXKWP9DetD6cM+4Mqh+l6NnyjGpMZa4aFEoTV
Xi6oSSTeotIK/2nY199IdTmRHlbz5aiaN1DkKUGOxCCKyy5SMXskUGyzsGpbByPh
W02RyGB938ItEfigG5LB/RuT5SvNFA7MAH3Z137rgq0rwZdTAhmugFMEy9ruP6u+
1WBXbV3xkjYdO92EVubzshTuUcvpAzxZ7cCqct4cuEn/+M0rNr4y7xxcS575nYCn
0alleCnn24BRrpigFJhrYy5ZThd0cPFY5//SV4lqX3NDiYR2pzAnreZxkiCyDU7Q
A9vXLpcwkXc19lJ3BeasZCGZD0KqVJGpkGAqTisJdhAigK4odoAnLYhw93+JLY35
fC6qyQbaye3vcuBuyJ2Wsmus41eJjBGjmpoNVEfrlCQK35XuuqY5pRD6vT0+b3+m
N97NRNcz1xRDzuzViEhheTQjDshj8xMqyAkMaAwx/BXhoxbKG8YJ8XWw/rfbrKVe
nhQzGRQBKds4/zFqUNeA4s798UjYJ7L5rNTOYM32k6D1de0giszGdNfrxV3rDeYz
yIhotPCQcSJ2qpvXd5OW26OrHXHb9jgMnSmdwOhiVXxw7Yc5qe4=
=UGfI
-----END PGP SIGNATURE-----

--S1n7bqj9JrK+C9IX--