Feedback-ID: i0fe9450f:Fastmail
Date: Tue, 25 Mar 2025 12:51:12 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Sami Imseih <samimseih@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Christoph Berg <myon@debian.org>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
	ma lz <ma100@hotmail.com>
Subject: Re: query_id: jumble names of temp tables for better
 pg_stat_statement UX
Message-ID: <Z-IoMKL8I-r-xsuW@paquier.xyz>
References: <Z96GJEmTnvHKz_Kn@msg.df7cb.de>
 <Z96Rz-4IEyRCS4ny@paquier.xyz>
 <1831838.1742656359@sss.pgh.pa.us>
 <80506.1742660683@sss.pgh.pa.us>
 <Z99aIy9T0f-lulK5@paquier.xyz>
 <461405.1742691859@sss.pgh.pa.us>
 <Z9-sUvq8pE5uinEu@paquier.xyz>
 <CAA5RZ0t4XQ_SANiJ5VfuoKnAuxMaY2ggQWoGKkHo+U2H+Sh-Sw@mail.gmail.com>
 <1189112.1742869660@sss.pgh.pa.us>
 <CAA5RZ0uNofEXfEfNw3uRN3D3oXkFPQ_s+huLLHMKR_+MCk8RPQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="8dtaIASdkUG1m4/Z"
Content-Disposition: inline
In-Reply-To: <CAA5RZ0uNofEXfEfNw3uRN3D3oXkFPQ_s+huLLHMKR_+MCk8RPQ@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/Z-IoMKL8I-r-xsuW%40paquier.xyz>
Precedence: bulk


--8dtaIASdkUG1m4/Z
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Mon, Mar 24, 2025 at 09:38:35PM -0500, Sami Imseih wrote:
> > select * from foo s1;
> > select * from foo s2;
>=20
> ah, thanks for pointing this out. Not as good of a workaround as
> a comment since one must change aliases, but at least there is
> a workaround...

Exactly.  Like Tom I'm not really worried about the proposal, but of
course I could prove to be wrong.  I am ready to assume that bloat in
pgss entries caused by temp tables is a more common case.

So let's move on with this proposal, before the gong.
--
Michael

--8dtaIASdkUG1m4/Z
Content-Type: application/pgp-signature; name="signature.asc"

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

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmfiKDAACgkQnvQgOdby
QH0LLxAAnEZP3SsL/dxgYK7tnDc/RxPCJcqNupWF8A0TFQ0bPtlAMc+7dp/3ri8G
3F1BbiqmfgSUCubrIRUH+X0w9zulSYu049TNJyy1dvnUScaHCNhvmyZEvXAW6ysh
3A19+oTC3kR9DzN2h5j98k6g0C8z0CQxLkHr6Wurg3ed7kSWQrUoMj4M0UIxNSCL
yzYPXuQKmLWL/8tXUy31OZ2+eHOSmL+tW7Q8Ej4jd0051Wkq6NdbEV0PJ2UAQFLv
s68vQ4Yc7PixLtknwUy/R+hRCJems3PSf/2F351oGq6TeITHGtCrlUh6ZjqnDHJy
Mfy0cyZfyGpIe2W7vmG/+0gEwarpd8KGxBuQhJZJqGqVf53i8TF9Oa5un+ulo9bq
CCKgq2C5HNtfCZsIgTVXN8FABGq81Ti/DmRVVoNA136p+xFbGvM7hxRZcn+RMH7V
HWuHc5gjp52KXS8EYSxCm4ajyppRo1ZolVV9EjXghmnapgDy2tTyo9V/MxRuBLSA
4HFtOBVL/yVDReeBbJSsUkNmv8Z/qxI/TO8bvp4v3HQJ8ReL5lApyi3AIWBDIv9e
dqSY+AfXs5SGwt+oynss4WCvOivYrEAD705q+2xypEYeb80/MzLmfb95uQL5rlqO
4+099oESHhkE616qGMjqsdZgSt+QW0PCccVtZP5xztdkR4OIB3M=
=bIYA
-----END PGP SIGNATURE-----

--8dtaIASdkUG1m4/Z--