| 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: | Whole Thread | Raw Message | 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
| 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? |