public inbox for [email protected]  

help / color / mirror / Atom feed

From: Daniel Verite <[email protected]>
To: Jevon Cowell <[email protected]>
Cc: [email protected]
Subject: Re: pg_stat_statements has duplicate entries for the same query & queryId
Date: Mon, 19 May 2025 09:07:35 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAMAx+cJM2Z32xvVbduGsF7rgOL6HuRcqq2Pob6w33wS1q8U0hw@mail.gmail.com>

	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 
(queryid, userid, dbid, toplevel).

From 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,
-- 
Daniel Vérité 
https://postgresql.verite.pro/

view thread (2+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: pg_stat_statements has duplicate entries for the same query & queryId
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox