Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query

Sergei Kornilov <sk@zsrv.org>

From: Sergei Kornilov <sk@zsrv.org>
To: Haribabu Kommi <kommi.haribabu@gmail.com>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2018-06-20T08:02:05Z
Lists: pgsql-hackers
Hello

>	key.userid = GetUserId();
We can remove query id only from current user, right? Maybe better provide optional argument for userid? Typically user with pg_read_all_stats and user for application queries are different users.
At least it should be documented.

regards, Sergei


Commits

  1. Extend pg_stat_statements_reset to reset statistics specific to a

  2. Default monitoring roles