pg_stat_statements has duplicate entries for the same query & queryId - Mailing list pgsql-general

From Jevon Cowell
Subject pg_stat_statements has duplicate entries for the same query & queryId
Date
Msg-id CAMAx+cJM2Z32xvVbduGsF7rgOL6HuRcqq2Pob6w33wS1q8U0hw@mail.gmail.com
Whole thread Raw
Responses Re: pg_stat_statements has duplicate entries for the same query & queryId
List 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

pgsql-general by date:

Previous
From: Ayush Vatsa
Date:
Subject: Clarification on REVOKE ALL ON FUNCTION – Are there any privileges apart from EXECUTE?
Next
From: Adrian Klaver
Date:
Subject: Re: Clarification on REVOKE ALL ON FUNCTION – Are there any privileges apart from EXECUTE?