pg_stat_statements has duplicate entries for the same query & queryId

From: Jevon Cowell <jcowell(at)atlassian(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: pg_stat_statements has duplicate entries for the same query & queryId
Date: 2025-05-18 19:20:07
Message-ID: CAMAx+cJM2Z32xvVbduGsF7rgOL6HuRcqq2Pob6w33wS1q8U0hw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-05-18 19:21:33 Re: Clarification on REVOKE ALL ON FUNCTION – Are there any privileges apart from EXECUTE?
Previous Message Ayush Vatsa 2025-05-18 19:17:13 Clarification on REVOKE ALL ON FUNCTION – Are there any privileges apart from EXECUTE?