[mannyv]

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?

[wiredfool]

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