PostgreSQL: Script to check the status of Shared Buffer (Use pg_buffercache)

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

In the previous post, I loaded table into the buffer cache of PostgreSQL (Using pg_prewarm).

PostgreSQL: Load table into Buffer Cache, Increase the Speed of Accessing data

In this post, I am sharing a script for checking the status of Shared buffer area of PostgreSQL.
Using pg_buffercache, we can check this. I took the script from the this official.

Please check the below script and output:

Create pg_buffercache module:

Script to check the status of Shared Buffer: