Tables in cache

Table Name Table size Total buffers Total buffers size % of the table in cache
rental 1097728 134 1097728 100
film 450560 55 450560 100
pg_proc 417792 51 417792 100
payment_p2007_04 409600 50 409600 100
pg_depend 344064 42 344064 100
payment_p2007_03 344064 42 344064 100
pg_attribute 319488 39 319488 100
film_actor 221184 27 221184 100
inventory 204800 25 204800 100
payment_p2007_02 139264 17 139264 100
pg_description 131072 16 131072 100
pg_statistic 131072 16 131072 100
pg_operator 106496 13 106496 100
pg_rewrite 81920 10 81920 100
pg_type 73728 9 73728 100
payment_p2007_01 73728 9 73728 100
customer 65536 8 65536 100
pg_class 65536 8 65536 100
address 57344 7 57344 100
pg_trigger 57344 7 57344 100
film_category 40960 5 40960 100
sql_features 40960 5 40960 100
city 32768 4 32768 100
pg_index 24576 3 24576 100
pg_constraint 24576 3 24576 100
pg_amop 24576 3 24576 100
pg_ts_config_map 16384 2 16384 100
payment_p2007_05 16384 2 16384 100
pg_shdepend 16384 2 16384 100
pg_opclass 16384 2 16384 100
pg_attrdef 16384 2 16384 100
pg_conversion 16384 2 16384 100
pg_cast 16384 2 16384 100
pg_amproc 16384 2 16384 100
actor 16384 2 16384 100
category 8192 1 8192 100
pg_tablespace 8192 1 8192 100
pg_ts_config 8192 1 8192 100
pg_ts_dict 8192 1 8192 100
pg_opfamily 8192 1 8192 100
sql_languages 8192 1 8192 100
pg_database 8192 1 8192 100
pg_language 8192 1 8192 100
store 8192 1 8192 100
sql_sizing 8192 1 8192 100
pg_ts_parser 8192 1 8192 100
staff 8192 1 8192 100
pg_aggregate 8192 1 8192 100
pg_authid 8192 1 8192 100
sql_implementation_info 8192 1 8192 100
language 8192 1 8192 100
pg_namespace 8192 1 8192 100
sql_parts 8192 1 8192 100
pg_enum 8192 1 8192 100
pg_pltemplate 8192 1 8192 100
pg_am 8192 1 8192 100
sql_packages 8192 1 8192 100
pg_inherits 8192 1 8192 100
country 8192 1 8192 100
pg_shdescription 8192 1 8192 100
pg_ts_template 8192 1 8192 100

SELECT n.nspname, c.relname, pg_relation_size(c.oid) AS size, count(*) AS buffers FROM pg_buffercache b, pg_class c, pg_namespace n WHERE b.relfilenode = c.relfilenode AND c.relnamespace = n.oid AND c.relkind = 'r' AND b.reldatabase IN (0, (SELECT oid FROM pg_database WHERE datname = current_database())) GROUP BY n.nspname, c.relname, size ORDER BY 3 DESC