PostgreSQL - How to check the usage of shared_buffers

Question

I am new to PostgreSQL and I would like to understand how can I see the utilization of shared_buffers in my PostgreSQL instance.

Let's assume I have shared_buffers = 8GB in my configuration, is there a way to check how much is being used in that 8GB?

Many Thanks, Suresh.

Laurenz Albe · Accepted Answer · 2022-02-22 07:33:24Z

7

Use the pg_buffercache extension:

CREATE EXTENSION pg_buffercache;

That provides a view of the same name that shows exactly what is stored where.

You can find empty buffers by looking for entries with usagecount IS NULL, but unless the server is newly started or the database is smaller than shared_buffers, you probably won't find any.

answered Feb 22, 2022 at 7:33

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Suresh Over a year ago

Thank you Laurenz Albe for your quick help

Collectives™ on Stack Overflow

PostgreSQL - How to check the usage of shared_buffers

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related