Index recommendations analyzes the most resource intensive set of queries in your workload and produces recommendations of indexes that, once created, improve the performance of those queries.
It also recommends indexes you can drop if they are identified as duplicates or are considered irrelevant for lack of use.
The new index recommendations feature builds on query store in Azure Database for PostgreSQL – Flexible Server, which captures and retains a history of queries executed in your workload and the runtime statistics of those queries.
