<title>Sample Output</title>

<screen>

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

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

FROM pg_buffercache b INNER JOIN pg_class c

ON b.relfilenode = pg_relation_filenode(c.oid) AND

b.reldatabase IN (0, (SELECT oid FROM pg_database

WHERE datname = current_database()))

GROUP BY c.relname

ORDER BY 2 DESC

JOIN pg_namespace n ON n.oid = c.relnamespace

GROUP BY n.nspname, c.relname

ORDER BY 3 DESC

LIMIT 10;

relname | buffers

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

tenk2|345

tenk1|141

pg_proc| 46

pg_class| 45

pg_attribute_relid_attnam_index |26

pg_depend| 22

nspname| relname | buffers

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

public| delete_test_table |593

public| delete_test_table_pkey|494

pg_catalog | pg_attribute |472

public| quad_poly_tbl |353

pg_catalog |pg_largeobject | 206

public| gin_test_tbl |188

(10 rows)

</screen>

</sect2>