Column | references | Description

----------------+----------------------+------------------------------------

bufferid | | Id, 1->shared_buffers.

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.

relfilenode | oid |

reltablespace | oid |

reldatabase | oid |

relblocknumber |numeric |

relblocknumber |bigint |

isdirty | boolean |

View definition:

SELECT p.bufferid, p.relfilenode, p.reltablespace, p.reldatabase,

p.relblocknumber, p.isdirty

FROM pg_buffercache_pages() p(bufferid integer, relfilenode oid,

reltablespace oid, reldatabase oid, relblocknumbernumeric(10,0),

reltablespace oid, reldatabase oid, relblocknumberbigint,

isdirty boolean);

regression=# SELECT c.relname, count(*) AS buffers

CREATE VIEW pg_buffercache AS

SELECT P.* FROM pg_buffercache_pages() AS P

(bufferid integer, relfilenode oid, reltablespace oid, reldatabase oid,

relblocknumbernumeric(10), isdirty bool);

relblocknumberint8, isdirty bool);

-- Don't want these to be available at public.

REVOKE ALL ON FUNCTION pg_buffercache_pages() FROM PUBLIC;

OIDOID,-1,0);

TupleDescInitEntry(tupledesc, (AttrNumber)4,"reldatabase",

OIDOID,-1,0);

TupleDescInitEntry(tupledesc, (AttrNumber)5,"relblockbumber",

NUMERICOID,-1,0);

TupleDescInitEntry(tupledesc, (AttrNumber)5,"relblocknumber",

INT8OID,-1,0);

TupleDescInitEntry(tupledesc, (AttrNumber)6,"isdirty",

BOOLOID,-1,0);