I expect that the thing that makes it an extension is "T005: Tables with potenti... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

mannyv on Oct 13, 2025 | parent | context | favorite | on: Database Linting and Analysis for PostgreSQL

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 on Oct 13, 2025 [–]

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

Consider applying for YC's Winter 2027 batch! Applications are open till November 2.
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact