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
signature.asc
Description: PGP signature
