List parameters with modified defaults

This article provides step-by-step instructions to list all parameters with modified defaults of an Azure Database for PostgreSQL flexible server.

Steps to list parameters with modified defaults

Portal

Using the Azure portal:

1. Select your Azure Database for PostgreSQL flexible server instance.

2. In the resource menu, under Settings, select Parameters.

   

3. Select the Modified tab. The page shows a list of parameters whose currently set value deviates from the default.

   

CLI

You can list all parameters whose values are modified from defaults, via the az postgres flexible-server parameter list command.

az postgres flexible-server parameter list \
  --resource-group <resource_group> \
  --server-name <server> \
  --query "[?value!=defaultValue && isReadOnly==\`false\` && name!='temp_tablespaces' && name!='vacuum_cost_page_miss'] | [].name"

Note

Previous CLI command doesn't consider modified parameters the ones which are designated as read-only, temp_tablespaces, and vacuum_cost_page_miss, following the exact same criteria as the Parameters page in the Azure portal.

Related contents

• List all parameters.
• List read-write static parameters.
• List read-write dynamic parameters.
• List read-only parameters.
• Set the value of one or more parameters.
• Revert one parameter to its default.
• Revert all parameters to their default.