Azure Postgres Autonomous tuning not supported

Marc Linster 0 Reputation points
2026-06-03T13:02:28.8966667+00:00

My server runs on General Purpose D8ds 8 vcores, Postgres 18, Hypopg and pg_stat_statements are installed.
Query performance insights works.

pg_qs.query_capture_mode is ON

When I try to set up Autonomous Tuning, I get the message "Autonomous tuning is not supported in this server because it doesn't meet the minimum requirements", but my server meets all the minimum requirements listed in the doc.

on the CLI

az postgres flexible-server autonomous-tuning update \

     --resource-group  resourcegroup \

     --server mltest  \

     --enabled true

Autonomous tuning is not supported for the server.

Copilot is of no help either.

What am I missing?

Azure Database for PostgreSQL

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Marc Linster 0 Reputation points
    2026-06-04T07:22:52.06+00:00

    The server runs on 4 vcores

    pg_qs.query_capture_mode = TOP

    pgms_wait_sampling.query_capture_mode = ALL

    track_io_timing = ON

    hypo_pg, pg_stat_statements, and btree_gist is installed

    But 'index_tuning.mode' is not an available server parameter.

    What am I missing?

    Was this answer helpful?

  2. Manoj Kumar Boyini 17,950 Reputation points Microsoft External Staff Moderator
    2026-06-04T02:30:26.0333333+00:00

    Hi @Marc Linster

    Based on the information provided, could you please confirm the following:

    1. Have you enabled Autonomous Tuning and Query Store by following the Microsoft documentation below? https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-configure-autonomous-tuning
    2. What is the current value of:
      • pg_qs.query_capture_mode
        • index_tuning.mode
        1. Do you see any index recommendations under Autonomous Tuning in the Azure portal or when using the CLI recommendation commands?

    Please note that Autonomous Tuning depends on Query Store data persisted in the azure_sys database. After enabling the feature, it can take up to 12 hours for the tuning engine to analyze the collected workload and generate recommendations.

    The additional details above will help us determine whether the issue is related to feature configuration, workload analysis, or server eligibility.

    Please let us know if you have any questions.

    Was this answer helpful?

  3. Amira Bedhiafi 43,036 Reputation points MVP Volunteer Moderator
    2026-06-03T19:10:01.5933333+00:00

    Hello Marc !

    Thank you for posting on MS Learn Q&A.

    You are probably not missing an extension because your server should meet the documented requirements: autonomous tuning is supported on Azure Database for PostgreSQL Flexible Server with PostgreSQL major version 12 or later and on supported compute SKUs with at least 4 vCores; your D8ds / 8 vCore / PostgreSQL 18 server fits that description. https://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-autonomous-tuning

    Autonomous tuning is not supported on read replicas or read-only instances because it depends on Query Store data stored locally in the azure_sys database.

    Query Store must be TOP or ALL, not just “on” because the relevant setting for autonomous tuning is pg_qs.query_capture_mode, and index_tuning.mode requires it to be TOP or ALL.

    Don't forget that autonomous tuning is not enabled just because hypopg, pg_stat_statements or Query Performance Insight work. The actual autonomous tuning mode must be set to report; default is off.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.