Horton

Re: Support reset of Shared objects statistics in "pg_stat_reset" function

Fujii Masao <masao.fujii@oss.nttdata.com>

View thread View on postgr.es
From: Fujii Masao <masao.fujii@oss.nttdata.com>
To: Mahendra Singh Thalor <mahi6run@gmail.com>, Sadhuprasad Patro <b.sadhu@gmail.com>
Cc: Dilip Kumar <dilipbalaut@gmail.com>, Himanshu Upadhyaya <upadhyaya.himanshu@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2021-08-20T02:42:30Z
Lists: pgsql-hackers 

On 2021/08/20 11:07, Mahendra Singh Thalor wrote:
> 1)
>           Resets statistics for a single table or index in the current database
> -        to zero.
> +        to zero. The input can be a shared table also
> 
> I think, above comment should be modified. Maybe, we can modify it as "If input is a shared oid(table or index or toast), then resets statistics for a single shared entry to zero.

I'm not sure if ordinary users can understand what "shared oid" means. Instead,
what about "Resets statistics for a single relation in the current database or
shared across all databases in the cluster to zero."?

Regards,

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION

Commits

  1. Enhance pg_stat_reset_single_table_counters function.