The pg_stat_io tables have a bunch of data that will tell you about index and table usage.