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

From: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>
To: Mahendra Singh Thalor <mahi6run(at)gmail(dot)com>, Sadhuprasad Patro <b(dot)sadhu(at)gmail(dot)com>
Cc: Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Himanshu Upadhyaya <upadhyaya(dot)himanshu(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Support reset of Shared objects statistics in "pg_stat_reset" function
Date: 2021-08-20 02:42:30
Message-ID: 8dcb2645-2aac-858f-3913-8c7fb04d6107@oss.nttdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro Horiguchi 2021-08-20 02:53:08 Re: Some leftovers of recent message cleanup?
Previous Message Mahendra Singh Thalor 2021-08-20 02:28:22 Re: Support reset of Shared objects statistics in "pg_stat_reset" function