Hi postgresql-admins,
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?
https://www.postgresql.org/docs/9.6/monitoring-stats.html
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,
--
Angular momentum makes the world go 'round.
Angular momentum makes the world go 'round.
