Now you can use index tuning to analyze the most resource intensive set of queries in your workload and produce recommendations of indexes that, once created, improve the performance of those queries. Index tuning also recommends indexes you can drop if they are identified as duplicates or are considered irrelevant for lack of use.
The new index tuning 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.