Index Advisor
Index Advisor reads a managed PostgreSQL databaseโs own workload and recommends indexes to add, with the evidence behind each one, plus unused, duplicate and invalid indexes to review. It is on by default for PostgreSQL databases created since 27 October 2026; an older database turns it on with one restart.