Re: Reconcile stats in find_tabstat_entry() and get rid of PgStat_BackendFunctionEntry

From: "Drouvot, Bertrand" <bertranddrouvot(dot)pg(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
Cc: andres(at)anarazel(dot)de, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Reconcile stats in find_tabstat_entry() and get rid of PgStat_BackendFunctionEntry
Date: 2023-03-22 08:20:25
Message-ID: 9fd52c6a-6533-a6f5-1394-1d8384806bb9@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On 3/22/23 7:44 AM, Drouvot, Bertrand wrote:
> Hi,
>
> On 3/22/23 5:45 AM, Michael Paquier wrote:
>> On Wed, Mar 22, 2023 at 11:37:03AM +0900, Kyotaro Horiguchi wrote:
>>> In the original description, "buffer fetches" appears to be a plural
>>> form of a compound noun and correct, similar to "buffer hits"
>>> mentioned later. If we reword it, I think it should be "number of
>>> buffers fetched".
>>
>> Using the plural makes sense, yes.
>
> Yeah, "buffer fetches" is similar to "buffer hits".
>
> For consistency, ISTM than renaming it to "buffers fetched" would also mean
> renaming "buffer hits" to "buffers hit". But then it would not be consistent
> with the documentation for things like pg_statio_all_tables.heap_blks_hit, idx_blks_hit, toast_blks_hit,
> tidx_blks_hit, pg_statio_all_indexes.idx_blks_hit, pg_statio_all_sequences.blks_hit
> where "Number of buffer hits" is used).
>

That said, please find enclosed V2 with "buffers fetched" suggested above (and no changes to
"buffer hits" to keep consistency with the other part of the documentation mentioned up-thread).

Regards,

--
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com

Attachment Content-Type Size
v2-0001-pg_stat_get_xact_blocks_fetched-and_hit-doc.patch text/plain 1.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2023-03-22 08:36:36 Re: An oversight in ExecInitAgg for grouping sets
Previous Message Andrei Zubkov 2023-03-22 08:17:00 Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements