On Mon, May 19, 2025 at 09:07:35AM +0200, Daniel Verite wrote:
> 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)
Yeah. The uniqueness of the entries in the PGSS hash table is
enforced by pgssHashKey in pg_stat_statements.c. Or an unknown bug
has been found, but there is no data proving that here.
--
Michael