Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query - Mailing list pgsql-hackers

From Sergei Kornilov
Subject Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query
Date
Msg-id 9153961543403718@myt6-23299ba78d64.qloud-c.yandex.net
Whole thread Raw
In response to Re: New function pg_stat_statements_reset_query() to reset statisticsof a specific query  (Vik Fearing <vik.fearing@2ndquadrant.com>)
Responses Re: New function pg_stat_statements_reset_query() to reset statisticsof a specific query
List pgsql-hackers
Hello

> My preference is for NULL to mean *all* so this is my favorite option,
> except that the first query should reset everything.

I am +1 for this option. NULL treat as "any" and pg_stat_statements_reset(NULL,NULL,NULL) to reset everything

We can use named notation?
https://www.postgresql.org/docs/current/sql-syntax-calling-funcs.html#SQL-SYNTAX-CALLING-FUNCS-NAMED

> select pg_stat_statements_reset(dbid := 10);

So i am -1 for multiple function options.

regards, Sergei


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Markdown format output for psql, design notes
Next
From: Bruce Momjian
Date:
Subject: Re: Unnecessary asterisk in comment in postgres_fdw.c