How to Find the Postgres Indexes Your Planner Never Picks (I Found 20 of 51)

Postgres tells you how many times each index was scanned. It can't tell you which one the planner picked for your slow query. I built a 3-file analyzer — and the first run found 20 of 51 indexes never used, 78% of my index disk wasted.

Fonte

DEV.to

Endereço

https://dev.to/alimafana/postgres-tells-you-your-query-was-slow-not-which-index-was-wasted-171g

Autoria

Ali Afana

Tecnologias

SQL & Bancos de dados

Curadoria

Revisado pela equipe do DevEducation

O DevEducation não hospeda este conteúdo. Todo o material pertence a Ali Afana e é acessado diretamente em dev.to.