MIME-Version: 1.0
From: Jevon Cowell <jcowell@atlassian.com>
Date: Sun, 18 May 2025 15:20:07 -0400
Message-ID: <CAMAx+cJM2Z32xvVbduGsF7rgOL6HuRcqq2Pob6w33wS1q8U0hw@mail.gmail.com>
Subject: pg_stat_statements has duplicate entries for the same query & queryId
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000d9acc406356de737"
Archived-At: <https://www.postgresql.org/message-id/CAMAx%2BcJM2Z32xvVbduGsF7rgOL6HuRcqq2Pob6w33wS1q8U0hw%40mail.gmail.com>
Precedence: bulk

--000000000000d9acc406356de737
Content-Type: text/plain; charset="UTF-8"

Hi Folks!
Let me know if there's a better mailing list to ask this in.

I have a statistics collector that collects data from various postgres
statistics tables, pg_stat_statements being one of them. This is done on an
entire fleet of Postgres databases. From the collected data we record the
timestamp of each collection in the query itself as  extract(epoch from
now()) as ts. 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. Anyone else run
into this or have any idea why this can occur?

Regards,
Jevon Cowell

--000000000000d9acc406356de737
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi Folks!</div><div>Let me know if there&#39;s a bett=
er mailing list to ask this in.</div><div><br></div><div>I have a statistic=
s=C2=A0collector that collects data from various postgres statistics=C2=A0t=
ables, pg_stat_statements being one of them. This is done on an entire flee=
t of Postgres databases. From the collected data we record the timestamp=C2=
=A0of each collection in the query itself=C2=A0as=C2=A0=C2=A0<span style=3D=
"color:rgb(195,232,141);font-family:Menlo,monospace;font-size:9pt;backgroun=
d-color:rgb(27,34,64)">extract(epoch from now()) as ts</span>. What I&#39;m=
 seeing is that for the same query <i>and</i>=C2=A0query id, there are two =
rows with different=C2=A0statistics data <i>at the same time</i>. For examp=
le=C2=A0one row can have 2 calls while another can have 4. Anyone else run =
into this or have any idea why this can occur?=C2=A0</div><div><br></div><d=
iv>Regards,</div><div>Jevon Cowell</div></div>

--000000000000d9acc406356de737--