Re: BUG #9050: pg_stat_statements() contains rows with the same dbid, userid and query

From: Peter Geoghegan <pg(at)heroku(dot)com>
To: bashtanov(at)imap(dot)cc
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #9050: pg_stat_statements() contains rows with the same dbid, userid and query
Date: 2014-01-31 08:27:09
Message-ID: CAM3SWZTC_ax3RHtVw+R5O5L4CnEDEyce2AOB7zGpgZirFB--fQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Jan 31, 2014 at 12:18 AM, <bashtanov(at)imap(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2014-01-31 21:22:51 Re: BUG #8354: stripped positions can generate nonzero rank in ts_rank_cd
Previous Message bashtanov 2014-01-31 08:18:24 BUG #9050: pg_stat_statements() contains rows with the same dbid, userid and query