Has anyone put any thought or effort into figuring out how to measure the total volume of data in a database against how much of it is hot? I'm looking for some automatable approaches. Similarly, is there a way to measure rarely queried columns, or unused functions & triggers?
pg_stat_user_tables tells you how many records have been inserted, updated and deleted since the instance was started. It does not, though, say which records were updated,