pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bill Moran <wmoran@potentialtech.com>
To: Sorin N. Ciolofan <ciolofan@ics.forth.gr>
Cc: pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_buffercache view
Date: Tue, 24 Apr 2007 09:02:54 -0400
Message-ID: <20070424090254.037f7996.wmoran@potentialtech.com> (raw)
In-Reply-To: <20070424100322.7E7EE8E40FC@mailhost.ics.forth.gr>
References: <20070418095419.169bc6cc.wmoran@potentialtech.com>
	<20070424100322.7E7EE8E40FC@mailhost.ics.forth.gr>

In response to "Sorin N. Ciolofan" <ciolofan@ics.forth.gr>:
> 
>  Dear all,
> 
> About the pg_buffercache view:
> I couldn't find the description for this view in the manual at
> http://www.postgresql.org/docs/8.2/interactive/catalogs.html
> However I found the readme file provided in the /contrib./pg_buffercache of
> the source code for version 8.2.3

Since pg_buffercache is contributed software, it's not documented in the
official PostgreSQL docs.

> Here it's written the following description:
> 
>    Column         |  references          | Description
>  
> ----------------+----------------------+------------------------------------
>    bufferid       |                      | Id, 1..shared_buffers.
>    relfilenode    | pg_class.relfilenode | Refilenode of the relation.
>    reltablespace  | pg_tablespace.oid    | Tablespace oid of the relation.
>    reldatabase    | pg_database.oid      | Database for the relation.
>    relblocknumber |                      | Offset of the page in the
> relation.
>    isdirty        |                      | Is the page dirty?
> 
> I've 2 questions:
> 1)
> I was not able to find the field "oid" from pg_database view. Could you
> please tell me what is the actual name of the column for which reldatabase
> is reffering to?

At the end of the README is an example query that I think answers your
question:
SELECT c.relname, count(*) AS buffers
               FROM pg_class c, pg_buffercache b
               WHERE b.relfilenode = c.relfilenode
               GROUP BY c.relname
               ORDER BY 2 DESC LIMIT 10;


> 2)
> In readme file is also written:
> "Unused buffers are shown with all fields null except buffered". 
> A "used" buffer means that is used 100% or could it be filled only
> partially?

Yes.  The buffer is either "used" or "not used", but pg_buffercache doesn't
know what percentage of it is used.  >0% is used.  0% is not used.

> Is there any way to know at a certain moment with precision how much shared
> memory expressed in Mb is used?

The precision is +/- 1 buffer.  I expect that trying to get more precision out
of the system will result in considerable performance degradation as the
data is collected and/or tracked.

-- 
Bill Moran
http://www.potentialtech.com



view thread (7+ messages)  latest in thread

Message-ID: <20070424090254.037f7996.wmoran@potentialtech.com>
Permalink:  ../20070424090254.037f7996.wmoran@potentialtech.com/
Also on:    postgresql.org/message-id/20070424090254.037f7996.wmoran@potentialtech.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: wmoran@potentialtech.com, ciolofan@ics.forth.gr, pgsql-general@postgresql.org
  Subject: Re: [GENERAL] pg_buffercache view
  In-Reply-To: <20070424090254.037f7996.wmoran@potentialtech.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox