Request a Demo
Home   >   mailing lists

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

From bashtanov@imap.cc
Subject BUG #9050: pg_stat_statements() contains rows with the same dbid, userid and query
Date
Msg-id 20140131081824.26694.23233@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #9050: pg_stat_statements() contains rows with the same dbid, userid and query
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      9050
Logged by:          Alexey Bashtanov
Email address:      bashtanov@imap.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

pgsql-bugs by date:

Previous
From: m.sakrejda@gmail.com
Date:
Subject: BUG #9048: Misleading error in transferring sequence between tables
Next
From: Peter Geoghegan
Date:
Subject: Re: BUG #9050: pg_stat_statements() contains rows with the same dbid, userid and query