Databases in cache

Database Name	Database size	Total buffers	Total buffers size	% of the database in cache
benchs	19234020	52	425984	2.21
middleoffice	196558052	59	483328	0.25
moduleo	4398308	52	425984	9.69
pagila	11885796	1418	11616256	97.73
postgres	4324580	108	884736	20.46
template1	4324580	52	425984	9.85
tests	150961380	52	425984	0.28

SELECT datname, pg_database_size(reldatabase) AS size, count(*) AS buffers FROM pg_buffercache, pg_database WHERE reldatabase=pg_database.oid GROUP BY 1, 2 ORDER BY 1, 2