Horton

Re: monitoring usage count distribution

Andres Freund <andres@anarazel.de>

View thread View on postgr.es
From: Andres Freund <andres@anarazel.de>
To: Greg Stark <stark@mit.edu>
Cc: Nathan Bossart <nathandbossart@gmail.com>, pgsql-hackers@postgresql.org, schneider@ardentperf.com
Date: 2023-04-04T23:25:27Z
Lists: pgsql-hackers 
Hi,

On 2023-04-04 14:14:36 -0400, Greg Stark wrote:
> Tom expressed skepticism that there's wide interest here. It seems as
> much from the lack of response. But perhaps that's just because people
> don't understand what the importance of this info is -- I certainly
> don't :)

pg_buffercache has exposed the raw data for a long time. The problem is that
it's way too slow to look at that way.

Greetings,

Andres Freund

Commits

  1. Add pg_buffercache_usage_counts() to contrib/pg_buffercache.