Horton

pg_buffercache: Add pg_buffercache_summary()

Andres Freund <andres@anarazel.de>

View on postgr.es
Commit: 2589434ae0fbfe08e46b6a4ffba400140b636074
Author: Andres Freund <andres@anarazel.de>
Date: 2022-10-13T16:55:46Z
Releases: 16.0 
pg_buffercache: Add pg_buffercache_summary()

Using pg_buffercache_summary() is significantly cheaper than querying
pg_buffercache and summarizing in SQL.

Author: Melih Mutlu <m.melihmutlu@gmail.com>
Reviewed-by: Andres Freund <andres@anarazel.de>
Reviewed-by: Aleksander Alekseev <aleksander@timescale.com>
Reviewed-by: Zhang Mingli <zmlpostgres@gmail.com>
Discussion: https://postgr.es/m/CAGPVpCQAXYo54Q%3D8gqBsS%3Du0uk9qhnnq4%2B710BtUhUisX1XGEg%40mail.gmail.com

Files

PathChange+/−
contrib/pg_buffercache/expected/pg_buffercache.out modified +33 −0
contrib/pg_buffercache/Makefile modified +2 −1
contrib/pg_buffercache/meson.build modified +1 −0
contrib/pg_buffercache/pg_buffercache--1.3--1.4.sql added +17 −0
contrib/pg_buffercache/pg_buffercache.control modified +1 −1
contrib/pg_buffercache/pg_buffercache_pages.c modified +67 −0
contrib/pg_buffercache/sql/pg_buffercache.sql modified +18 −0
doc/src/sgml/pgbuffercache.sgml modified +111 −3

Documentation touched

Discussion