
Which Index Should You Actually Create? HypoPG, pg_qualstats, and the PostgreSQL Index Advisor
Most index advice is a hunch with a table name attached: this table gets scanned a lot, so maybe index something on it. The Index Advisor in the August 2026 release of the PostgreSQL Plug-in for Oracle Enterprise Manager replaces the hunch with two kinds of evidence. HypoPG prices a candidate index by planning against it without building it, and pg_qualstats reports the predicates your workload actually ran that no index served. Part one of four on the release's advisory features: how each layer works, where each one stops, why they deliberately disagree, and what it takes to install them.


