Add pg_buffercache_usage_counts() to contrib/pg_buffercache.
Tom Lane <tgl@sss.pgh.pa.us>
Add pg_buffercache_usage_counts() to contrib/pg_buffercache. It was pointed out that pg_buffercache_summary()'s report of the overall average usage count isn't that useful, and what would be more helpful in many cases is to report totals for each possible usage count. Add a new function to do it like that. Since pg_buffercache 1.4 is already new for v16, we don't need to create a new extension version; we'll just define this as part of 1.4. Nathan Bossart Discussion: https://postgr.es/m/20230130233040.GA2800702@nathanxps13
Files
| Path | Change | +/− |
|---|---|---|
| contrib/pg_buffercache/expected/pg_buffercache.out | modified | +14 −0 |
| contrib/pg_buffercache/pg_buffercache--1.3--1.4.sql | modified | +11 −0 |
| contrib/pg_buffercache/pg_buffercache_pages.c | modified | +43 −0 |
| contrib/pg_buffercache/sql/pg_buffercache.sql | modified | +4 −0 |
| doc/src/sgml/pgbuffercache.sgml | modified | +101 −4 |
Documentation touched
Discussion
- monitoring usage count distribution 20 messages · 2023-01-30 → 2023-04-08