Comment by mannyv

12 hours ago

I expect that the thing that makes it an extension is "T005: Tables with potential missing indexes (high sequential scan usage)." Can you get that data on the outside?

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