Re: BUG #9050: pg_stat_statements() contains rows with the same dbid, userid and query - Mailing list pgsql-bugs

On Fri, Jan 31, 2014 at 12:18 AM,  <bashtanov@imap.cc> wrote:
> such a query run under superuser produces non-empty result:
>
> select userid, dbid, query from pg_stat_statements() group by 1,2,3 having
> count(1) > 1;

Did you drop and recreate the table? That counts as a distinct table
and distinct query as far as pg_stat_statements is concerned.


--
Peter Geoghegan