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/
