On 2/24/22 12:37 PM, Joseph Hammerman wrote:
> 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.