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/