---
title: "GET /subscriptions/{subscriptionId}/providers/Microsoft.DBforPostgreSQL/locations/{locationName}/performanceTiers"
method: GET
path: "/subscriptions/{subscriptionId}/providers/Microsoft.DBforPostgreSQL/locations/{locationName}/performanceTiers"
tags: ["LocationBasedPerformanceTier"]
---

# GET /subscriptions/{subscriptionId}/providers/Microsoft.DBforPostgreSQL/locations/{locationName}/performanceTiers

`GET /subscriptions/{subscriptionId}/providers/Microsoft.DBforPostgreSQL/locations/{locationName}/performanceTiers`

List all the performance tiers at specified location in a given subscription.

## Path parameters

- `subscriptionId` string, required
- `locationName` string, required

## Query parameters

- `api-version` string, required

## Response `200`

OK

- PerformanceTierListResult — A list of performance tiers.
  - `value` PerformanceTierProperties[] — The list of performance tiers
    - `id` string — ID of the performance tier.
    - `maxBackupRetentionDays` integer — Maximum Backup retention in days for the performance tier edition
    - `minBackupRetentionDays` integer — Minimum Backup retention in days for the performance tier edition
    - `maxStorageMB` integer — Max storage allowed for a server.
    - `minLargeStorageMB` integer — Max storage allowed for a server.
    - `maxLargeStorageMB` integer — Max storage allowed for a server.
    - `minStorageMB` integer — Max storage allowed for a server.
    - `serviceLevelObjectives` PerformanceTierServiceLevelObjectives[] — Service level objectives associated with the performance tier
      - `id` string — ID for the service level objective.
      - `edition` string — Edition of the performance tier.
      - `vCore` integer — vCore associated with the service level objective
      - `hardwareGeneration` string — Hardware generation associated with the service level objective
      - `maxBackupRetentionDays` integer — Maximum Backup retention in days for the performance tier edition
      - `minBackupRetentionDays` integer — Minimum Backup retention in days for the performance tier edition
      - `maxStorageMB` integer — Max storage allowed for a server.
      - `minStorageMB` integer — Max storage allowed for a server.

## Other responses

- `default` — Error response describing why the operation failed.

## Changes

- **2021-07-02** (2017-12-01-preview) `ae137050faec` — 1 info
  - endpoint added
- **2020-09-09** (2017-12-01-preview) `47f1c002a84e` — 1 breaking
  - api path removed without deprecation

[Change history](https://skmtc.dev/azure/apis/postgresqlmanagementclient/changes/subscriptions/:subscriptionId/providers/Microsoft.DBforPostgreSQL/locations/:locationName/performanceTiers/get.md)

---

[API](https://skmtc.dev/azure/apis/postgresqlmanagementclient.md) · [All operations](https://skmtc.dev/azure/apis/postgresqlmanagementclient/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/azure/postgresqlmanagementclient/revisions/ae137050faec/schema)