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

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: BUG #9050: pg_stat_statements() contains rows with the same dbid, userid and query
Дата
Msg-id CAM3SWZTC_ax3RHtVw+R5O5L4CnEDEyce2AOB7zGpgZirFB--fQ@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #9050: pg_stat_statements() contains rows with the same dbid, userid and query  (bashtanov@imap.cc)
Список 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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: bashtanov@imap.cc
Дата:
Сообщение: BUG #9050: pg_stat_statements() contains rows with the same dbid, userid and query
Следующее
От: scratch65535@att.net
Дата:
Сообщение: BUG #9045: Misleading error message needs changed