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

From: bashtanov(at)imap(dot)cc
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #9050: pg_stat_statements() contains rows with the same dbid, userid and query
Date: 2014-01-31 08:18:24
Message-ID: 20140131081824.26694.23233@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 9050
Logged by: Alexey Bashtanov
Email address: bashtanov(at)imap(dot)cc
PostgreSQL version: 9.3.1
Operating system: Linux
Description:

hello!

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;

I am not sure how to reproduce it, but it can be reproduced only on those
instances having several databases on it.

Regards, Alexey

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Geoghegan 2014-01-31 08:27:09 Re: BUG #9050: pg_stat_statements() contains rows with the same dbid, userid and query
Previous Message m.sakrejda 2014-01-31 02:03:28 BUG #9048: Misleading error in transferring sequence between tables