Content-Type: text/plain; charset="iso-8859-15"
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
Subject: Re: pg_stat_statements has duplicate entries for the same query &
 queryId
From: "Daniel Verite" <daniel@manitou-mail.org>
To: "Jevon Cowell" <jcowell@atlassian.com>
Cc: pgsql-general@lists.postgresql.org
In-Reply-To: <CAMAx+cJM2Z32xvVbduGsF7rgOL6HuRcqq2Pob6w33wS1q8U0hw@mail.gmail.com>
Date: Mon, 19 May 2025 09:07:35 +0200
Message-Id: <2c2446a8-ec7e-4a91-b69d-62e70f1dc51c@manitou-mail.org>
Archived-At: <https://www.postgresql.org/message-id/2c2446a8-ec7e-4a91-b69d-62e70f1dc51c%40manitou-mail.org>
Precedence: bulk

	Jevon Cowell wrote:

> What I'm seeing is that for the same query *and* query id,
> there are two rows with different statistics data *at the same time*. For
> example one row can have 2 calls while another can have 4

That looks normal. The unicity to expect is on=20
(queryid, userid, dbid, toplevel).

=46rom https://www.postgresql.org/docs/current/pgstatstatements.html :

  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)


Best regards,
--=20
Daniel V=E9rit=E9=20
https://postgresql.verite.pro/