Re: Per backend relation statistics tracking - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Per backend relation statistics tracking
Date
Msg-id uqaqymmcjgryr5jt3rtg7jdle4q54hngpee3fwg7h4z7gu424a@q3532yz7t6uc
Whole thread Raw
In response to Re: Per backend relation statistics tracking  (Bertrand Drouvot <bertranddrouvot.pg@gmail.com>)
List pgsql-hackers
Hi,

On 2025-08-26 06:38:41 +0000, Bertrand Drouvot wrote:
> > and IO related counters aren't
> > incremented remotely as often as the scan related counters are.
> 
> You mean the flush are not triggered as often? If so, yeah that's also something
> you've mentioned ([1]) and that I've in mind to look at.

I mean that we increment the counters less frequently.
pgstat_count_heap_getnext() is called for every tuple on a page, which is
obviously much more frequent than once per page like for IO.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [BUG?] check_exclusion_or_unique_constraint false negative
Next
From: Fujii Masao
Date:
Subject: Re: pg_restore --no-policies should not restore policies' comment