Feedback-ID: i0fe9450f:Fastmail
Date: Tue, 20 May 2025 06:51:23 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Daniel Verite <daniel@manitou-mail.org>
Cc: Jevon Cowell <jcowell@atlassian.com>,
	pgsql-general@lists.postgresql.org
Subject: Re: pg_stat_statements has duplicate entries for the same query &
 queryId
Message-ID: <aCun21dAxukwyoW0@paquier.xyz>
References: <CAMAx+cJM2Z32xvVbduGsF7rgOL6HuRcqq2Pob6w33wS1q8U0hw@mail.gmail.com>
 <2c2446a8-ec7e-4a91-b69d-62e70f1dc51c@manitou-mail.org>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="Zurnl/wA0Ov18ful"
Content-Disposition: inline
In-Reply-To: <2c2446a8-ec7e-4a91-b69d-62e70f1dc51c@manitou-mail.org>
Archived-At: <https://www.postgresql.org/message-id/aCun21dAxukwyoW0%40paquier.xyz>
Precedence: bulk


--Zurnl/wA0Ov18ful
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Mon, May 19, 2025 at 09:07:35AM +0200, Daniel Verite wrote:
> That looks normal. The unicity to expect is on=20
> (queryid, userid, dbid, toplevel).
>=20
> From https://www.postgresql.org/docs/current/pgstatstatements.html :
>=20
>   This view contains one row for each distinct combination of database
>   ID, user ID, query ID and whether it's a top-level statement or not
>   (up to the maximum number of distinct statements that the module can
>   track)

Yeah.  The uniqueness of the entries in the PGSS hash table is
enforced by pgssHashKey in pg_stat_statements.c.  Or an unknown bug
has been found, but there is no data proving that here.
--
Michael

--Zurnl/wA0Ov18ful
Content-Type: application/pgp-signature; name="signature.asc"

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

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmgrp9sACgkQnvQgOdby
QH0QaRAAglIdj0mdI8O4oqc8ScZdwnYbiRQu4+yEHmaINN73uVAORAoB1/JnSPfq
j5rRiUMH2FGcoYCRzJlQqP2u33r8LowZ0Rg4IStdW0pzAVaLpRvdX2OJIRlGjeNr
Ocf6lD76Xe1jUmEW+zBnI3o7yUX6819xXN6YAqp3cORY5sWdGxvIxW157yayPfXS
RKqyETOeYg/h2TLKVgB2oZZ/huRge8v4Ahn/QQswlYbtUJ4SH6DccyMt7tD9v7g2
Wc4B7ApvKQVvnlPsz4Pdx7SQzALXofthz7oV2gkAuDLGqttSNEkoEW/8Y0F80ACl
U+CKfKbX7JOwSOLMv0AHsOhmmkUkPkluo91k3Bl2K9gSni2P2cVN6gNMfeBIslYc
aLLlbwAyzq7CQ5E3MkjctNTt6hrLJ7/ZMiQA3hN+5qdEDfJKWh1ClTOlpD0c1iUa
LQMbkNRcb5Nv69lfEFZrCUTIiClDOQFOwJBsj1br7YaBABTbKem7wlr77k0l0WWZ
ChZe4Ev+HYhZs7Fbme0zc0HPeD8WHH4wMsQRDoFZs0DmRq35Q0OIGS+/0u0jv2Yf
Exgw7wyd7B/Bjyvz8QgqZeocdewrbdujjoAQ+5StSEXVdLH3JkXyAAZlr5do5OaR
hryZRVc//TUil7P4dRoawYdFwKyZG7l8/n/nAksYFemidI3rtf8=
=EZqn
-----END PGP SIGNATURE-----

--Zurnl/wA0Ov18ful--