Shared_buffers
Summarize the Buffer Cache with pg_buffercache_summary
Sep 8, 2026 / · 10 min read · postgresql database administration sql queries buffer cache pg_buffercache shared_buffers performance monitoring catalogs postgres dba ·Summarize the Buffer Cache with pg_buffercache_summary PostgreSQL 16 added a shortcut to a question DBAs have always had to answer the expensive way. Before that release, checking how full the shared buffer cache was — how many buffers were dirty, how many pinned, how hot the clock-sweep usage counts were running — …
Read MoreMonitor PostgreSQL Table Cache Hit Ratio with SQL
May 14, 2026 / · 4 min read · pg_statio_user_tables cache performance shared_buffers administration pg_statio_user_indexes ·Measuring PostgreSQL Table Cache Efficiency with pg_statio_user_tables PostgreSQL keeps frequently accessed data pages in shared_buffers to avoid hitting disk. When a backend reads a data block, PostgreSQL first checks shared_buffers; if the block is there, it counts as a heap hit. If it is not, PostgreSQL reads from …
Read More