Horton

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

Haribabu Kommi <kommi.haribabu@gmail.com>

View thread View on postgr.es
From: Haribabu Kommi <kommi.haribabu@gmail.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: Amit Kapila <amit.kapila16@gmail.com>, Alvaro Herrera <alvherre@2ndquadrant.com>, sk@zsrv.org, Robert Haas <robertmhaas@gmail.com>, Fujii Masao <masao.fujii@gmail.com>, Ashutosh Sharma <ashu.coek88@gmail.com>, Euler Taveira <euler@timbira.com.br>, Pg Hackers <pgsql-hackers@postgresql.org>, Simon Riggs <simon@2ndquadrant.com>, Dave Page <dpage@pgadmin.org>
Date: 2018-09-25T03:49:09Z
Lists: pgsql-hackers

Attachments

On Tue, Sep 25, 2018 at 1:39 AM Michael Paquier <michael@paquier.xyz> wrote:

> On Mon, Sep 24, 2018 at 12:19:44PM +1000, Haribabu Kommi wrote:
> > Attached new rebased version of the patch that enhances the
> > pg_stat_statements_reset()
> > function. This needs to be applied on top of the patch that is posted in
> > [1].
>
> +CREATE ROLE stats_regress_user1;
> +CREATE ROLE stats_regress_user2;
> Just a short note: regression tests creating roles should use regress_
> as prefix.
>

Thanks for the review.
Fixed in the attached patch as per your suggestion.

Regards,
Haribabu Kommi
Fujitsu Australia

Commits

  1. Extend pg_stat_statements_reset to reset statistics specific to a

  2. Default monitoring roles