Skip to content

Instantly share code, notes, and snippets.

@varun-dhawan

varun-dhawan/AzurePostgresFlexibleServer-NewMetrics.md

Last active January 18, 2023 21:10
Show Gist options
  • Save varun-dhawan/ac56513f22912786075300ca7e2380a7 to your computer and use it in GitHub Desktop.
Save varun-dhawan/ac56513f22912786075300ca7e2380a7 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. varun-dhawan revised this gist Jan 18, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -20,7 +20,7 @@ Azure Database for PostgreSQL provides various metrics that give insight into th

    - Most of these new metrics are _disabled_ by default, barring a few exeptions (per the list below)
    - To enable these metrics, please turn ON the server parameter `metrics.collector_database_activity`.
    - This parameter is dynamic, hence will not require instance restart.
    - This parameter is dynamic, hence will not require instance restart.

    ## List of enhanced metrics

  2. varun-dhawan revised this gist Jan 18, 2023. 1 changed file with 2 additions and 1 deletion.
    3 changes: 2 additions & 1 deletion AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -19,7 +19,8 @@ Azure Database for PostgreSQL provides various metrics that give insight into th
    ## Enabling enhanced metrics

    - Most of these new metrics are _disabled_ by default, barring a few exeptions (per the list below)
    - To enable these metrics, please turn ON the server parameter `metrics.collector_database_activity`. This parameter is dynamic, hence will not require instance restart.
    - To enable these metrics, please turn ON the server parameter `metrics.collector_database_activity`.
    - This parameter is dynamic, hence will not require instance restart.

    ## List of enhanced metrics

  3. varun-dhawan revised this gist Jan 18, 2023. No changes.
  4. varun-dhawan revised this gist Jan 18, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -4,7 +4,7 @@ description: List of new metrics
    ms.service: postgresql
    ms.subservice: flexible-server
    ms.topic: conceptual
    ms.author: varun.dhawan@microsoft.com
    ms.author: varun.dhawan
    ms.date: 10/13/2022
    ---

  5. varun-dhawan revised this gist Jan 18, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -4,7 +4,7 @@ description: List of new metrics
    ms.service: postgresql
    ms.subservice: flexible-server
    ms.topic: conceptual
    ms.author: varundhawan
    ms.author: [email protected]
    ms.date: 10/13/2022
    ---

  6. varun-dhawan revised this gist Jan 18, 2023. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,5 +1,5 @@
    ---
    title: Azure Database for PostgreSQL Flexible Server Enhanced Metrics - Preview
    title: Azure Database for PostgreSQL Flexible Server Enhanced metrics - Preview
    description: List of new metrics
    ms.service: postgresql
    ms.subservice: flexible-server
    @@ -8,7 +8,7 @@ ms.author: varundhawan
    ms.date: 10/13/2022
    ---

    # Azure Postgres Flexible Server - Enhanced Metrics (Preview) [Zn Sem]
    # Azure Postgres Flexible Server - Enhanced metrics (Preview) [Zn Sem]

    ## Enhanced Metrics
    Azure Database for PostgreSQL provides various metrics that give insight into the behavior of the resources supporting the PostgreSQL server. Each metric is emitted at a **one-minute frequency**, and has up to **93 days of history**. You can configure alerts on the metrics. Other options include setting up automated actions, performing advanced analytics, and archiving history. For more information, see the [Azure Monitor Metrics Overview](https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-monitoring).
  7. varun-dhawan revised this gist Jan 18, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -8,7 +8,7 @@ ms.author: varundhawan
    ms.date: 10/13/2022
    ---

    # Azure Database for PostgreSQL Flexible Server - Enhanced Metrics (Preview) [Zn Sem]
    # Azure Postgres Flexible Server - Enhanced Metrics (Preview) [Zn Sem]

    ## Enhanced Metrics
    Azure Database for PostgreSQL provides various metrics that give insight into the behavior of the resources supporting the PostgreSQL server. Each metric is emitted at a **one-minute frequency**, and has up to **93 days of history**. You can configure alerts on the metrics. Other options include setting up automated actions, performing advanced analytics, and archiving history. For more information, see the [Azure Monitor Metrics Overview](https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-monitoring).
  8. varun-dhawan revised this gist Jan 18, 2023. No changes.
  9. varun-dhawan revised this gist Jan 18, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -8,7 +8,7 @@ ms.author: varundhawan
    ms.date: 10/13/2022
    ---

    # Azure Database for PostgreSQL Flexible Server - Enhanced Metrics (Preview) Zn Sem
    # Azure Database for PostgreSQL Flexible Server - Enhanced Metrics (Preview) [Zn Sem]

    ## Enhanced Metrics
    Azure Database for PostgreSQL provides various metrics that give insight into the behavior of the resources supporting the PostgreSQL server. Each metric is emitted at a **one-minute frequency**, and has up to **93 days of history**. You can configure alerts on the metrics. Other options include setting up automated actions, performing advanced analytics, and archiving history. For more information, see the [Azure Monitor Metrics Overview](https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-monitoring).
  10. varun-dhawan revised this gist Jan 18, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -8,7 +8,7 @@ ms.author: varundhawan
    ms.date: 10/13/2022
    ---

    # Azure Database for PostgreSQL Flexible Server - Enhanced Metrics (Preview); Zn Sem
    # Azure Database for PostgreSQL Flexible Server - Enhanced Metrics (Preview) Zn Sem

    ## Enhanced Metrics
    Azure Database for PostgreSQL provides various metrics that give insight into the behavior of the resources supporting the PostgreSQL server. Each metric is emitted at a **one-minute frequency**, and has up to **93 days of history**. You can configure alerts on the metrics. Other options include setting up automated actions, performing advanced analytics, and archiving history. For more information, see the [Azure Monitor Metrics Overview](https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-monitoring).
  11. varun-dhawan revised this gist Jan 18, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -8,7 +8,7 @@ ms.author: varundhawan
    ms.date: 10/13/2022
    ---

    # Azure Database for PostgreSQL Flexible Server - Enhanced Metrics (Preview) "Zn Sem"
    # Azure Database for PostgreSQL Flexible Server - Enhanced Metrics (Preview); Zn Sem

    ## Enhanced Metrics
    Azure Database for PostgreSQL provides various metrics that give insight into the behavior of the resources supporting the PostgreSQL server. Each metric is emitted at a **one-minute frequency**, and has up to **93 days of history**. You can configure alerts on the metrics. Other options include setting up automated actions, performing advanced analytics, and archiving history. For more information, see the [Azure Monitor Metrics Overview](https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-monitoring).
  12. varun-dhawan revised this gist Jan 18, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -8,7 +8,7 @@ ms.author: varundhawan
    ms.date: 10/13/2022
    ---

    # Azure Database for PostgreSQL Flexible Server - Enhanced Metrics (Preview)
    # Azure Database for PostgreSQL Flexible Server - Enhanced Metrics (Preview) "Zn Sem"

    ## Enhanced Metrics
    Azure Database for PostgreSQL provides various metrics that give insight into the behavior of the resources supporting the PostgreSQL server. Each metric is emitted at a **one-minute frequency**, and has up to **93 days of history**. You can configure alerts on the metrics. Other options include setting up automated actions, performing advanced analytics, and archiving history. For more information, see the [Azure Monitor Metrics Overview](https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-monitoring).
  13. varun-dhawan revised this gist Dec 15, 2022. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -25,7 +25,7 @@ Azure Database for PostgreSQL provides various metrics that give insight into th

    ##### `Activity`

    |Display Name |Metric ID |Unit |Description |Dimension |Enabled by default|
    |Display Name |Metric ID |Unit |Description |Dimension |Default enabled|
    |-----------------------------------|----------------------------|-------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------|------------------|
    |**Sessions By State** (Preview) |sessions_by_state |Count |Overall state of the backends |State |No |
    |**Sessions By WaitEventType** (Preview)|sessions_by_wait_event_type |Count |Sessions by the type of event for which the backend is waiting |Wait Event Type|No |
  14. varun-dhawan revised this gist Dec 9, 2022. 1 changed file with 7 additions and 7 deletions.
    14 changes: 7 additions & 7 deletions AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -27,13 +27,13 @@ Azure Database for PostgreSQL provides various metrics that give insight into th

    |Display Name |Metric ID |Unit |Description |Dimension |Enabled by default|
    |-----------------------------------|----------------------------|-------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------|------------------|
    |Sessions By State (Preview) |sessions_by_state |Count |Overall state of the backends |State |No |
    |Sessions By WaitEventType (Preview)|sessions_by_wait_event_type |Count |Sessions by the type of event for which the backend is waiting |Wait Event Type|No |
    |Oldest Backend (Preview) |oldest_backend_time_sec |Seconds|The age in seconds of the oldest backend (irrespective of the state) |N/a |No |
    |Oldest Query (Preview) |longest_query_time_sec |Seconds|The age in seconds of the longest query that is currently running |N/a |No |
    |Oldest Transaction (Preview) |longest_transaction_time_sec|Seconds|The age in seconds of the longest transaction (including idle transactions) |N/a |No |
    |Oldest xmin (Preivew) |oldest_backend_xmin |Count |The actual value of the oldest xmin. If xmin is not increasing it indicates there are some long running transactions that can potentially hold dead tuples from being removed |N/a |No |
    |Oldest xmin Age (Preivew) |oldest_backend_xmin_age |Count |Age in units of the oldest xmin. It indicated how many transactions passed since oldest xmin |N/a |No |
    |**Sessions By State** (Preview) |sessions_by_state |Count |Overall state of the backends |State |No |
    |**Sessions By WaitEventType** (Preview)|sessions_by_wait_event_type |Count |Sessions by the type of event for which the backend is waiting |Wait Event Type|No |
    |**Oldest Backend** (Preview) |oldest_backend_time_sec |Seconds|The age in seconds of the oldest backend (irrespective of the state) |N/a |No |
    |**Oldest Query** (Preview) |longest_query_time_sec |Seconds|The age in seconds of the longest query that is currently running |N/a |No |
    |**Oldest Transaction** (Preview) |longest_transaction_time_sec|Seconds|The age in seconds of the longest transaction (including idle transactions) |N/a |No |
    |**Oldest xmin** (Preivew) |oldest_backend_xmin |Count |The actual value of the oldest xmin. If xmin is not increasing it indicates there are some long running transactions that can potentially hold dead tuples from being removed |N/a |No |
    |**Oldest xmin Age** (Preivew) |oldest_backend_xmin_age |Count |Age in units of the oldest xmin. It indicated how many transactions passed since oldest xmin |N/a |No |

    ##### `Database`

  15. varun-dhawan revised this gist Dec 7, 2022. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -32,8 +32,8 @@ Azure Database for PostgreSQL provides various metrics that give insight into th
    |Oldest Backend (Preview) |oldest_backend_time_sec |Seconds|The age in seconds of the oldest backend (irrespective of the state) |N/a |No |
    |Oldest Query (Preview) |longest_query_time_sec |Seconds|The age in seconds of the longest query that is currently running |N/a |No |
    |Oldest Transaction (Preview) |longest_transaction_time_sec|Seconds|The age in seconds of the longest transaction (including idle transactions) |N/a |No |
    |Oldest xmin (Preivew) |oldest_backend_xmin |Count |Age in units of the oldest xmin. It indicated how many transactions passed since oldest xmin |N/a |No |
    |Oldest xmin Age (Preivew) |oldest_backend_xmin_age |Count |The actual value of the oldest xmin. If xmin is not increasing it indicates there are some long running transactions that can potentially hold dead tuples from being removed.|N/a |No |
    |Oldest xmin (Preivew) |oldest_backend_xmin |Count |The actual value of the oldest xmin. If xmin is not increasing it indicates there are some long running transactions that can potentially hold dead tuples from being removed |N/a |No |
    |Oldest xmin Age (Preivew) |oldest_backend_xmin_age |Count |Age in units of the oldest xmin. It indicated how many transactions passed since oldest xmin |N/a |No |

    ##### `Database`

  16. varun-dhawan revised this gist Dec 5, 2022. 1 changed file with 8 additions and 9 deletions.
    17 changes: 8 additions & 9 deletions AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -25,16 +25,15 @@ Azure Database for PostgreSQL provides various metrics that give insight into th

    ##### `Activity`

    |Display Name |Metric ID |Unit |Description |Dimension |Default enabled |
    |Display Name |Metric ID |Unit |Description |Dimension |Enabled by default|
    |-----------------------------------|----------------------------|-------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------|------------------|
    |**Oldest Backend** (Preview) |oldest_backend_time_sec |Seconds|The age in seconds of the oldest backend (irrespective of the state) |N/a |No |
    |**Oldest Query** (Preview) |longest_query_time_sec |Seconds|The age in seconds of the longest query that is currently running |N/a |No |
    |**Oldest Transaction** (Preview) |longest_transaction_time_sec|Seconds|The age in seconds of the longest transaction (including idle transactions) |N/a |No |
    |**Oldest xmin** (Preivew) |oldest_backend_xmin_age |Count |The actual value of the oldest xmin |N/a |No |
    |**Oldest xmin Age** (Preivew) |oldest_backend_xmin |Count |Age in units of the oldest xmin. It indicated how many transactions passed since oldest xmin |N/a |No |
    |**Sessions By State** (Preview) |sessions_by_state |Count |Overall state of the backends |State |No |
    |**Sessions By WaitEventType** (Preview)|sessions_by_wait_event_type |Count |Sessions by the type of event for which the backend is waiting |Wait Event Type|No |

    |Sessions By State (Preview) |sessions_by_state |Count |Overall state of the backends |State |No |
    |Sessions By WaitEventType (Preview)|sessions_by_wait_event_type |Count |Sessions by the type of event for which the backend is waiting |Wait Event Type|No |
    |Oldest Backend (Preview) |oldest_backend_time_sec |Seconds|The age in seconds of the oldest backend (irrespective of the state) |N/a |No |
    |Oldest Query (Preview) |longest_query_time_sec |Seconds|The age in seconds of the longest query that is currently running |N/a |No |
    |Oldest Transaction (Preview) |longest_transaction_time_sec|Seconds|The age in seconds of the longest transaction (including idle transactions) |N/a |No |
    |Oldest xmin (Preivew) |oldest_backend_xmin |Count |Age in units of the oldest xmin. It indicated how many transactions passed since oldest xmin |N/a |No |
    |Oldest xmin Age (Preivew) |oldest_backend_xmin_age |Count |The actual value of the oldest xmin. If xmin is not increasing it indicates there are some long running transactions that can potentially hold dead tuples from being removed.|N/a |No |

    ##### `Database`

  17. varun-dhawan revised this gist Nov 14, 2022. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -82,7 +82,7 @@ Azure Database for PostgreSQL provides various metrics that give insight into th
    |-------------------|---------------|-----|---------------------------------------------------------------|---------|------------------|
    |**Max Connections^** |max_connections|Count|Max Connections |N/a |Yes |

    ^ `max_connections` represents the configured value for max_connections server parameter, and it is collected every 30 minutes.
    ^ `max_connections` represents the configured value for __max_connections__ server parameter, and it is collected every 30 minutes.

    ## Applying Filters and Splitting on enhanced metrics

  18. varun-dhawan revised this gist Nov 14, 2022. 1 changed file with 3 additions and 1 deletion.
    4 changes: 3 additions & 1 deletion AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -80,7 +80,9 @@ Azure Database for PostgreSQL provides various metrics that give insight into th

    |Display Name|Metric ID |Unit |Description |Dimension|Default enabled |
    |-------------------|---------------|-----|---------------------------------------------------------------|---------|------------------|
    |**Max Connections** |max_connections|Count|Max Connections |N/a |Yes |
    |**Max Connections^** |max_connections|Count|Max Connections |N/a |Yes |

    ^ `max_connections` represents the configured value for max_connections server parameter, and it is collected every 30 minutes.

    ## Applying Filters and Splitting on enhanced metrics

  19. varun-dhawan revised this gist Nov 10, 2022. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -8,7 +8,7 @@ ms.author: varundhawan
    ms.date: 10/13/2022
    ---

    # Azure Database for PostgreSQL Flexible Server - Enhanced Metrics (Private-Preview)
    # Azure Database for PostgreSQL Flexible Server - Enhanced Metrics (Preview)

    ## Enhanced Metrics
    Azure Database for PostgreSQL provides various metrics that give insight into the behavior of the resources supporting the PostgreSQL server. Each metric is emitted at a **one-minute frequency**, and has up to **93 days of history**. You can configure alerts on the metrics. Other options include setting up automated actions, performing advanced analytics, and archiving history. For more information, see the [Azure Monitor Metrics Overview](https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-monitoring).
  20. varun-dhawan revised this gist Nov 8, 2022. 1 changed file with 3 additions and 4 deletions.
    7 changes: 3 additions & 4 deletions AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -30,8 +30,8 @@ Azure Database for PostgreSQL provides various metrics that give insight into th
    |**Oldest Backend** (Preview) |oldest_backend_time_sec |Seconds|The age in seconds of the oldest backend (irrespective of the state) |N/a |No |
    |**Oldest Query** (Preview) |longest_query_time_sec |Seconds|The age in seconds of the longest query that is currently running |N/a |No |
    |**Oldest Transaction** (Preview) |longest_transaction_time_sec|Seconds|The age in seconds of the longest transaction (including idle transactions) |N/a |No |
    |**Oldest xmin** (Preivew) |oldest_backend_xmin_age |Count |Age in units of the oldest xmin. It indicated how many transactions passed since oldest xmin |N/a |No |
    |**Oldest xmin Age** (Preivew) |oldest_backend_xmin |Count |The actual value of the oldest xmin. If xmin is not increasing it indicates there are some long running transactions that can potentially hold dead tuples from being removed.|N/a |No |
    |**Oldest xmin** (Preivew) |oldest_backend_xmin_age |Count |The actual value of the oldest xmin |N/a |No |
    |**Oldest xmin Age** (Preivew) |oldest_backend_xmin |Count |Age in units of the oldest xmin. It indicated how many transactions passed since oldest xmin |N/a |No |
    |**Sessions By State** (Preview) |sessions_by_state |Count |Overall state of the backends |State |No |
    |**Sessions By WaitEventType** (Preview)|sessions_by_wait_event_type |Count |Sessions by the type of event for which the backend is waiting |Wait Event Type|No |

    @@ -80,8 +80,7 @@ Azure Database for PostgreSQL provides various metrics that give insight into th

    |Display Name|Metric ID |Unit |Description |Dimension|Default enabled |
    |-------------------|---------------|-----|---------------------------------------------------------------|---------|------------------|
    |**Max Connections** |max_connections|Count|Maximum number of concurrent connections to the database server|N/a |Yes |

    |**Max Connections** |max_connections|Count|Max Connections |N/a |Yes |

    ## Applying Filters and Splitting on enhanced metrics

  21. varun-dhawan revised this gist Nov 8, 2022. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -4,7 +4,7 @@ description: List of new metrics
    ms.service: postgresql
    ms.subservice: flexible-server
    ms.topic: conceptual
    ms.author: varun-dhawan
    ms.author: varundhawan
    ms.date: 10/13/2022
    ---

  22. varun-dhawan revised this gist Nov 8, 2022. 1 changed file with 13 additions and 14 deletions.
    27 changes: 13 additions & 14 deletions AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -19,14 +19,13 @@ Azure Database for PostgreSQL provides various metrics that give insight into th
    ## Enabling enhanced metrics

    - Most of these new metrics are _disabled_ by default, barring a few exeptions (per the list below)
    - To enable these metrics, please turn ON the server parameter `metrics.collector_database_activity`.
    - This parameter is dynamic, hence will not require instance restart.
    - To enable these metrics, please turn ON the server parameter `metrics.collector_database_activity`. This parameter is dynamic, hence will not require instance restart.

    ## List of enhanced metrics

    ### Activity
    ##### `Activity`

    |Display Name |Metric ID |Unit |Description |Dimension |Default enabled|
    |Display Name |Metric ID |Unit |Description |Dimension |Default enabled |
    |-----------------------------------|----------------------------|-------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------|------------------|
    |**Oldest Backend** (Preview) |oldest_backend_time_sec |Seconds|The age in seconds of the oldest backend (irrespective of the state) |N/a |No |
    |**Oldest Query** (Preview) |longest_query_time_sec |Seconds|The age in seconds of the longest query that is currently running |N/a |No |
    @@ -37,9 +36,9 @@ Azure Database for PostgreSQL provides various metrics that give insight into th
    |**Sessions By WaitEventType** (Preview)|sessions_by_wait_event_type |Count |Sessions by the type of event for which the backend is waiting |Wait Event Type|No |


    ### Database
    ##### `Database`

    |Display Name |Metric ID |Unit |Description |Dimension |Default enabled|
    |Display Name |Metric ID |Unit |Description |Dimension |Default enabled |
    |-------------------------------------|-------------|-----|----------------------------------------------------------------------------------------------------|-------------|------------------|
    |**Backends** (Preview) |numbackends |Count|Number of backends connected to this database |Database Name|No |
    |**Deadlocks** (Preview) |deadlocks |Count|Number of deadlocks detected in this database |Database Name|No |
    @@ -56,30 +55,30 @@ Azure Database for PostgreSQL provides various metrics that give insight into th
    |**Tuples Returned** (Preview) |tup_returned |Count|Number of rows returned by queries in this database |Database Name|No |
    |**Tuples Updated** (Preview) |tup_updated |Count|Number of rows updated by queries in this database |Database Name|No |

    ### Logical Replication
    ##### `Logical Replication`

    |Display Name |Metric ID |Unit |Description |Dimension|Default enabled|
    |Display Name |Metric ID |Unit |Description |Dimension|Default enabled |
    |-------------------------------------|----------------------------------|-----|------------------------------------------------|---------|------------------|
    |**Max Logical Replication Lag** (Preview)|logical_replication_delay_in_bytes|Bytes|Maximum lag across all logical replication slots|N/a |Yes |

    ### Replication
    ##### `Replication`

    |Display Name |Metric ID |Unit |Description |Dimension|Default enabled|
    |Display Name |Metric ID |Unit |Description |Dimension|Default enabled |
    |--------------------------------------|-------------------------------------|-------|--------------------------------------------------------------|---------|------------------|
    |**Max Physical Replication Lag** (Preview)|physical_replication_delay_in_bytes |Bytes |Maximum lag across all asynchronous physical replication slots|N/a |Yes |
    |**Read Replica Lag** (Preview) |physical_replication_delay_in_seconds|Seconds|Read Replica lag in seconds |N/a |Yes |


    ### Saturation
    ##### `Saturation`

    |Display Name |Metric ID |Unit |Description |Dimension|Default enabled|
    |Display Name |Metric ID |Unit |Description |Dimension|Default enabled |
    |---------------------------------------|----------------------------------|-------|-----------------------------------------------------|---------|------------------|
    |**Disk Bandwidth Consumed Percentage**|disk_bandwidth_consumed_percentage|Percent|Percentage of data disk bandwidth consumed per minute|N/a |Yes |
    |**Disk IOPS Consumed Percentage** |disk_iops_consumed_percentage |Percent|Percentage of data disk I/Os consumed per minute |N/a |Yes |

    ### Traffic
    ##### `Traffic`

    |Display Name|Metric ID |Unit |Description |Dimension|Default enabled|
    |Display Name|Metric ID |Unit |Description |Dimension|Default enabled |
    |-------------------|---------------|-----|---------------------------------------------------------------|---------|------------------|
    |**Max Connections** |max_connections|Count|Maximum number of concurrent connections to the database server|N/a |Yes |

  23. varun-dhawan revised this gist Nov 8, 2022. 1 changed file with 0 additions and 2 deletions.
    2 changes: 0 additions & 2 deletions AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -26,8 +26,6 @@ Azure Database for PostgreSQL provides various metrics that give insight into th

    ### Activity

    ### Activity

    |Display Name |Metric ID |Unit |Description |Dimension |Default enabled|
    |-----------------------------------|----------------------------|-------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------|------------------|
    |**Oldest Backend** (Preview) |oldest_backend_time_sec |Seconds|The age in seconds of the oldest backend (irrespective of the state) |N/a |No |
  24. varun-dhawan revised this gist Nov 8, 2022. 1 changed file with 19 additions and 15 deletions.
    34 changes: 19 additions & 15 deletions AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -26,34 +26,37 @@ Azure Database for PostgreSQL provides various metrics that give insight into th

    ### Activity

    ### Activity

    |Display Name |Metric ID |Unit |Description |Dimension |Default enabled|
    |-----------------------------------|----------------------------|-------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------|------------------|
    |**Sessions By State** (Preview) |sessions_by_state |Count |Overall state of the backends |State |No |
    |**Sessions By WaitEventType** (Preview)|sessions_by_wait_event_type |Count |Sessions by the type of event for which the backend is waiting |Wait Event Type|No |
    |**Oldest Backend** (Preview) |oldest_backend_time_sec |Seconds|The age in seconds of the oldest backend (irrespective of the state) |N/a |No |
    |**Oldest Query** (Preview) |longest_query_time_sec |Seconds|The age in seconds of the longest query that is currently running |N/a |No |
    |**Oldest Transaction** (Preview) |longest_transaction_time_sec|Seconds|The age in seconds of the longest transaction (including idle transactions) |N/a |No |
    |**Oldest xmin** (Preivew) |oldest_backend_xmin_age |Count |Age in units of the oldest xmin. It indicated how many transactions passed since oldest xmin |N/a |No |
    |**Oldest xmin Age** (Preivew) |oldest_backend_xmin |Count |The actual value of the oldest xmin. If xmin is not increasing it indicates there are some long running transactions that can potentially hold dead tuples from being removed.|N/a |No |
    |**Sessions By State** (Preview) |sessions_by_state |Count |Overall state of the backends |State |No |
    |**Sessions By WaitEventType** (Preview)|sessions_by_wait_event_type |Count |Sessions by the type of event for which the backend is waiting |Wait Event Type|No |


    ### Database

    |Display Name |Metric ID |Unit |Description |Dimension |Default enabled|
    |-------------------------------------|-------------|-----|----------------------------------------------------------------------------------------------------|-------------|------------------|
    |**Total Transactions** (Preview) |xact_total |Count|Number of total transactions executed in this database |Database Name|No |
    |**Transactions commited** (Preview) |xact_commit |Count|Number of transactions in this database that have been committed |Database Name|No |
    |**Transactions rolledback** (Preview) |xact_rollback|Count|Number of transactions in this database that have been rolled back |Database Name|No |
    |**Backends** (Preview) |numbackends |Count|Number of backends connected to this database |Database Name|No |
    |**Deadlocks** (Preview) |deadlocks |Count|Number of deadlocks detected in this database |Database Name|No |
    |**Tuples Inserted** (Preview) |tup_inserted |Count|Number of rows inserted by queries in this database |Database Name|No |
    |**Tuples Deleted** (Preview) |tup_deleted |Count|Number of rows deleted by queries in this database |Database Name|No |
    |**Tuples Updated** (Preview) |tup_updated |Count|Number of rows updated by queries in this database |Database Name|No |
    |**Tuples Returned** (Preview) |tup_returned |Count|Number of rows returned by queries in this database |Database Name|No |
    |**Tuples Fetched** (Preview) |tup_fetched |Count|Number of rows fetched by queries in this database |Database Name|No |
    |**Disk Blocks Hit** (Preview) |blks_hit |Count|Number of times disk blocks were found already in the buffer cache, so that a read was not necessary|Database Name|No |
    |**Disk Blocks Read** (Preview) |blks_read |Count|Number of disk blocks read in this database |Database Name|No |
    |**Temporary Files** (Preview) |temp_files |Count|Number of temporary files created by queries in this database |Database Name|No |
    |**Temporary Files Size** (Preview) |temp_bytes |Bytes|Total amount of data written to temporary files by queries in this database |Database Name|No |
    |**Disk Blocks Read** (Preview) |blks_read |Count|Number of disk blocks read in this database |Database Name|No |
    |**Disk Blocks Hit BufferCache** (Preview)|blks_hit |Count|Number of times disk blocks were found already in the buffer cache, so that a read was not necessary|Database Name|No |
    |**Total Transactions** (Preview) |xact_total |Count|Number of total transactions executed in this database |Database Name|No |
    |**Transactions Committed** (Preview) |xact_commit |Count|Number of transactions in this database that have been committed |Database Name|No |
    |**Transactions Rolled back** (Preview) |xact_rollback|Count|Number of transactions in this database that have been rolled back |Database Name|No |
    |**Tuples Deleted** (Preview) |tup_deleted |Count|Number of rows deleted by queries in this database |Database Name|No |
    |**Tuples Fetched** (Preview) |tup_fetched |Count|Number of rows fetched by queries in this database |Database Name|No |
    |**Tuples Inserted** (Preview) |tup_inserted |Count|Number of rows inserted by queries in this database |Database Name|No |
    |**Tuples Returned** (Preview) |tup_returned |Count|Number of rows returned by queries in this database |Database Name|No |
    |**Tuples Updated** (Preview) |tup_updated |Count|Number of rows updated by queries in this database |Database Name|No |

    ### Logical Replication

    @@ -65,15 +68,16 @@ Azure Database for PostgreSQL provides various metrics that give insight into th

    |Display Name |Metric ID |Unit |Description |Dimension|Default enabled|
    |--------------------------------------|-------------------------------------|-------|--------------------------------------------------------------|---------|------------------|
    |**Read Replica Lag** (Preview) |physical_replication_delay_in_seconds|Seconds|Read Replica lag in seconds |N/a |Yes |
    |**Max Physical Replication Lag** (Preview)|physical_replication_delay_in_bytes |Bytes |Maximum lag across all asynchronous physical replication slots|N/a |Yes |
    |**Read Replica Lag** (Preview) |physical_replication_delay_in_seconds|Seconds|Read Replica lag in seconds |N/a |Yes |


    ### Saturation

    |Display Name |Metric ID |Unit |Description |Dimension|Default enabled|
    |---------------------------------------|----------------------------------|-------|-----------------------------------------------------|---------|------------------|
    |**Data Disk Bandwidth Consumed Percentage**|disk_bandwidth_consumed_percentage|Percent|Percentage of data disk bandwidth consumed per minute|N/a |Yes |
    |**Data Disk IOPS Consumed Percentage** |disk_iops_consumed_percentage |Percent|Percentage of data disk I/Os consumed per minute |N/a |Yes |
    |**Disk Bandwidth Consumed Percentage**|disk_bandwidth_consumed_percentage|Percent|Percentage of data disk bandwidth consumed per minute|N/a |Yes |
    |**Disk IOPS Consumed Percentage** |disk_iops_consumed_percentage |Percent|Percentage of data disk I/Os consumed per minute |N/a |Yes |

    ### Traffic

  25. varun-dhawan revised this gist Nov 8, 2022. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -14,7 +14,7 @@ ms.date: 10/13/2022
    Azure Database for PostgreSQL provides various metrics that give insight into the behavior of the resources supporting the PostgreSQL server. Each metric is emitted at a **one-minute frequency**, and has up to **93 days of history**. You can configure alerts on the metrics. Other options include setting up automated actions, performing advanced analytics, and archiving history. For more information, see the [Azure Monitor Metrics Overview](https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-monitoring).

    > [Note]
    > In addition to these new metrics, we already have over 21 metrics already avaiavble in Flexible Server. For details, refer [here](https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-monitoring#list-of-metrics).
    > In addition to these new metrics, we already have over 21 metrics already avaiavble in Flexible Server. For list of existing metrics, refer [Monitor metrics on Azure Database for PostgreSQL - Flexible Server](https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-monitoring#list-of-metrics).
    ## Enabling enhanced metrics

  26. varun-dhawan revised this gist Nov 8, 2022. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -79,7 +79,7 @@ Azure Database for PostgreSQL provides various metrics that give insight into th

    |Display Name|Metric ID |Unit |Description |Dimension|Default enabled|
    |-------------------|---------------|-----|---------------------------------------------------------------|---------|------------------|
    |**max_connections** |max_connections|Count|Maximum number of concurrent connections to the database server|N/a |Yes |
    |**Max Connections** |max_connections|Count|Maximum number of concurrent connections to the database server|N/a |Yes |


    ## Applying Filters and Splitting on enhanced metrics
  27. varun-dhawan revised this gist Nov 8, 2022. 1 changed file with 55 additions and 0 deletions.
    55 changes: 55 additions & 0 deletions AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -26,6 +26,61 @@ Azure Database for PostgreSQL provides various metrics that give insight into th

    ### Activity

    |Display Name |Metric ID |Unit |Description |Dimension |Default enabled|
    |-----------------------------------|----------------------------|-------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------|------------------|
    |**Sessions By State** (Preview) |sessions_by_state |Count |Overall state of the backends |State |No |
    |**Sessions By WaitEventType** (Preview)|sessions_by_wait_event_type |Count |Sessions by the type of event for which the backend is waiting |Wait Event Type|No |
    |**Oldest Backend** (Preview) |oldest_backend_time_sec |Seconds|The age in seconds of the oldest backend (irrespective of the state) |N/a |No |
    |**Oldest Query** (Preview) |longest_query_time_sec |Seconds|The age in seconds of the longest query that is currently running |N/a |No |
    |**Oldest Transaction** (Preview) |longest_transaction_time_sec|Seconds|The age in seconds of the longest transaction (including idle transactions) |N/a |No |
    |**Oldest xmin** (Preivew) |oldest_backend_xmin_age |Count |Age in units of the oldest xmin. It indicated how many transactions passed since oldest xmin |N/a |No |
    |**Oldest xmin Age** (Preivew) |oldest_backend_xmin |Count |The actual value of the oldest xmin. If xmin is not increasing it indicates there are some long running transactions that can potentially hold dead tuples from being removed.|N/a |No |

    ### Database

    |Display Name |Metric ID |Unit |Description |Dimension |Default enabled|
    |-------------------------------------|-------------|-----|----------------------------------------------------------------------------------------------------|-------------|------------------|
    |**Total Transactions** (Preview) |xact_total |Count|Number of total transactions executed in this database |Database Name|No |
    |**Transactions commited** (Preview) |xact_commit |Count|Number of transactions in this database that have been committed |Database Name|No |
    |**Transactions rolledback** (Preview) |xact_rollback|Count|Number of transactions in this database that have been rolled back |Database Name|No |
    |**Backends** (Preview) |numbackends |Count|Number of backends connected to this database |Database Name|No |
    |**Deadlocks** (Preview) |deadlocks |Count|Number of deadlocks detected in this database |Database Name|No |
    |**Tuples Inserted** (Preview) |tup_inserted |Count|Number of rows inserted by queries in this database |Database Name|No |
    |**Tuples Deleted** (Preview) |tup_deleted |Count|Number of rows deleted by queries in this database |Database Name|No |
    |**Tuples Updated** (Preview) |tup_updated |Count|Number of rows updated by queries in this database |Database Name|No |
    |**Tuples Returned** (Preview) |tup_returned |Count|Number of rows returned by queries in this database |Database Name|No |
    |**Tuples Fetched** (Preview) |tup_fetched |Count|Number of rows fetched by queries in this database |Database Name|No |
    |**Temporary Files** (Preview) |temp_files |Count|Number of temporary files created by queries in this database |Database Name|No |
    |**Temporary Files Size** (Preview) |temp_bytes |Bytes|Total amount of data written to temporary files by queries in this database |Database Name|No |
    |**Disk Blocks Read** (Preview) |blks_read |Count|Number of disk blocks read in this database |Database Name|No |
    |**Disk Blocks Hit BufferCache** (Preview)|blks_hit |Count|Number of times disk blocks were found already in the buffer cache, so that a read was not necessary|Database Name|No |

    ### Logical Replication

    |Display Name |Metric ID |Unit |Description |Dimension|Default enabled|
    |-------------------------------------|----------------------------------|-----|------------------------------------------------|---------|------------------|
    |**Max Logical Replication Lag** (Preview)|logical_replication_delay_in_bytes|Bytes|Maximum lag across all logical replication slots|N/a |Yes |

    ### Replication

    |Display Name |Metric ID |Unit |Description |Dimension|Default enabled|
    |--------------------------------------|-------------------------------------|-------|--------------------------------------------------------------|---------|------------------|
    |**Read Replica Lag** (Preview) |physical_replication_delay_in_seconds|Seconds|Read Replica lag in seconds |N/a |Yes |
    |**Max Physical Replication Lag** (Preview)|physical_replication_delay_in_bytes |Bytes |Maximum lag across all asynchronous physical replication slots|N/a |Yes |

    ### Saturation

    |Display Name |Metric ID |Unit |Description |Dimension|Default enabled|
    |---------------------------------------|----------------------------------|-------|-----------------------------------------------------|---------|------------------|
    |**Data Disk Bandwidth Consumed Percentage**|disk_bandwidth_consumed_percentage|Percent|Percentage of data disk bandwidth consumed per minute|N/a |Yes |
    |**Data Disk IOPS Consumed Percentage** |disk_iops_consumed_percentage |Percent|Percentage of data disk I/Os consumed per minute |N/a |Yes |

    ### Traffic

    |Display Name|Metric ID |Unit |Description |Dimension|Default enabled|
    |-------------------|---------------|-----|---------------------------------------------------------------|---------|------------------|
    |**max_connections** |max_connections|Count|Maximum number of concurrent connections to the database server|N/a |Yes |


    ## Applying Filters and Splitting on enhanced metrics

  28. varun-dhawan revised this gist Nov 8, 2022. 1 changed file with 0 additions and 54 deletions.
    54 changes: 0 additions & 54 deletions AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -26,60 +26,6 @@ Azure Database for PostgreSQL provides various metrics that give insight into th

    ### Activity

    |Display Name |Metric ID |Unit |Description |Dimension |Default enabled|
    |-----------------------------------|----------------------------|-------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------|------------------|
    |Sessions By State (Preview) |sessions_by_state |Count |Overall state of the backends |State |No |
    |Sessions By WaitEventType (Preview)|sessions_by_wait_event_type |Count |Sessions by the type of event for which the backend is waiting |Wait Event Type|No |
    |Oldest Backend (Preview) |oldest_backend_time_sec |Seconds|The age in seconds of the oldest backend (irrespective of the state) |N/a |No |
    |Oldest Query (Preview) |longest_query_time_sec |Seconds|The age in seconds of the longest query that is currently running |N/a |No |
    |Oldest Transaction (Preview) |longest_transaction_time_sec|Seconds|The age in seconds of the longest transaction (including idle transactions) |N/a |No |
    |Oldest xmin (Preivew) |oldest_backend_xmin_age |Count |Age in units of the oldest xmin. It indicated how many transactions passed since oldest xmin |N/a |No |
    |Oldest xmin Age (Preivew) |oldest_backend_xmin |Count |The actual value of the oldest xmin. If xmin is not increasing it indicates there are some long running transactions that can potentially hold dead tuples from being removed.|N/a |No |

    ### Database

    |Display Name |Metric ID |Unit |Description |Dimension |Default enabled|
    |-------------------------------------|-------------|-----|----------------------------------------------------------------------------------------------------|-------------|------------------|
    |Total Transactions (Preview) |xact_total |Count|Number of total transactions executed in this database |Database Name|No |
    |Transactions commited (Preview) |xact_commit |Count|Number of transactions in this database that have been committed |Database Name|No |
    |Transactions rolledback (Preview) |xact_rollback|Count|Number of transactions in this database that have been rolled back |Database Name|No |
    |Backends (Preview) |numbackends |Count|Number of backends connected to this database |Database Name|No |
    |Deadlocks (Preview) |deadlocks |Count|Number of deadlocks detected in this database |Database Name|No |
    |Tuples Inserted (Preview) |tup_inserted |Count|Number of rows inserted by queries in this database |Database Name|No |
    |Tuples Deleted (Preview) |tup_deleted |Count|Number of rows deleted by queries in this database |Database Name|No |
    |Tuples Updated (Preview) |tup_updated |Count|Number of rows updated by queries in this database |Database Name|No |
    |Tuples Returned (Preview) |tup_returned |Count|Number of rows returned by queries in this database |Database Name|No |
    |Tuples Fetched (Preview) |tup_fetched |Count|Number of rows fetched by queries in this database |Database Name|No |
    |Temporary Files (Preview) |temp_files |Count|Number of temporary files created by queries in this database |Database Name|No |
    |Temporary Files Size (Preview) |temp_bytes |Bytes|Total amount of data written to temporary files by queries in this database |Database Name|No |
    |Disk Blocks Read (Preview) |blks_read |Count|Number of disk blocks read in this database |Database Name|No |
    |Disk Blocks Hit BufferCache (Preview)|blks_hit |Count|Number of times disk blocks were found already in the buffer cache, so that a read was not necessary|Database Name|No |

    ### Logical Replication

    |Display Name |Metric ID |Unit |Description |Dimension|Default enabled|
    |-------------------------------------|----------------------------------|-----|------------------------------------------------|---------|------------------|
    |Max Logical Replication Lag (Preview)|logical_replication_delay_in_bytes|Bytes|Maximum lag across all logical replication slots|N/a |Yes |

    ### Replication

    |Display Name |Metric ID |Unit |Description |Dimension|Default enabled|
    |--------------------------------------|-------------------------------------|-------|--------------------------------------------------------------|---------|------------------|
    |Read Replica Lag (Preview) |physical_replication_delay_in_seconds|Seconds|Read Replica lag in seconds |N/a |Yes |
    |Max Physical Replication Lag (Preview)|physical_replication_delay_in_bytes |Bytes |Maximum lag across all asynchronous physical replication slots|N/a |Yes |

    ### Saturation

    |Display Name |Metric ID |Unit |Description |Dimension|Default enabled|
    |---------------------------------------|----------------------------------|-------|-----------------------------------------------------|---------|------------------|
    |Data Disk Bandwidth Consumed Percentage|disk_bandwidth_consumed_percentage|Percent|Percentage of data disk bandwidth consumed per minute|N/a |Yes |
    |Data Disk IOPS Consumed Percentage |disk_iops_consumed_percentage |Percent|Percentage of data disk I/Os consumed per minute |N/a |Yes |

    ### Traffic

    |Display Name|Metric ID |Unit |Description |Dimension|Default enabled|
    |-------------------|---------------|-----|---------------------------------------------------------------|---------|------------------|
    |max_connections |max_connections|Count|Maximum number of concurrent connections to the database server|N/a |Yes |

    ## Applying Filters and Splitting on enhanced metrics

  29. varun-dhawan revised this gist Nov 8, 2022. No changes.
  30. varun-dhawan revised this gist Nov 8, 2022. 1 changed file with 6 additions and 6 deletions.
    12 changes: 6 additions & 6 deletions AzurePostgresFlexibleServer-NewMetrics.md
    View file
    Original file line number Diff line number Diff line change
    @@ -26,7 +26,7 @@ Azure Database for PostgreSQL provides various metrics that give insight into th

    ### Activity

    |Display Name |Metric ID |Unit |Description |Dimension |Enabled default|
    |Display Name |Metric ID |Unit |Description |Dimension |Default enabled|
    |-----------------------------------|----------------------------|-------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------|------------------|
    |Sessions By State (Preview) |sessions_by_state |Count |Overall state of the backends |State |No |
    |Sessions By WaitEventType (Preview)|sessions_by_wait_event_type |Count |Sessions by the type of event for which the backend is waiting |Wait Event Type|No |
    @@ -38,7 +38,7 @@ Azure Database for PostgreSQL provides various metrics that give insight into th

    ### Database

    |Display Name |Metric ID |Unit |Description |Dimension |Enabled default|
    |Display Name |Metric ID |Unit |Description |Dimension |Default enabled|
    |-------------------------------------|-------------|-----|----------------------------------------------------------------------------------------------------|-------------|------------------|
    |Total Transactions (Preview) |xact_total |Count|Number of total transactions executed in this database |Database Name|No |
    |Transactions commited (Preview) |xact_commit |Count|Number of transactions in this database that have been committed |Database Name|No |
    @@ -57,27 +57,27 @@ Azure Database for PostgreSQL provides various metrics that give insight into th

    ### Logical Replication

    |Display Name |Metric ID |Unit |Description |Dimension|Enabled default|
    |Display Name |Metric ID |Unit |Description |Dimension|Default enabled|
    |-------------------------------------|----------------------------------|-----|------------------------------------------------|---------|------------------|
    |Max Logical Replication Lag (Preview)|logical_replication_delay_in_bytes|Bytes|Maximum lag across all logical replication slots|N/a |Yes |

    ### Replication

    |Display Name |Metric ID |Unit |Description |Dimension|Enabled default|
    |Display Name |Metric ID |Unit |Description |Dimension|Default enabled|
    |--------------------------------------|-------------------------------------|-------|--------------------------------------------------------------|---------|------------------|
    |Read Replica Lag (Preview) |physical_replication_delay_in_seconds|Seconds|Read Replica lag in seconds |N/a |Yes |
    |Max Physical Replication Lag (Preview)|physical_replication_delay_in_bytes |Bytes |Maximum lag across all asynchronous physical replication slots|N/a |Yes |

    ### Saturation

    |Display Name |Metric ID |Unit |Description |Dimension|Enabled default|
    |Display Name |Metric ID |Unit |Description |Dimension|Default enabled|
    |---------------------------------------|----------------------------------|-------|-----------------------------------------------------|---------|------------------|
    |Data Disk Bandwidth Consumed Percentage|disk_bandwidth_consumed_percentage|Percent|Percentage of data disk bandwidth consumed per minute|N/a |Yes |
    |Data Disk IOPS Consumed Percentage |disk_iops_consumed_percentage |Percent|Percentage of data disk I/Os consumed per minute |N/a |Yes |

    ### Traffic

    |Display Name|Metric ID |Unit |Description |Dimension|Enabled default|
    |Display Name|Metric ID |Unit |Description |Dimension|Default enabled|
    |-------------------|---------------|-----|---------------------------------------------------------------|---------|------------------|
    |max_connections |max_connections|Count|Maximum number of concurrent connections to the database server|N/a |Yes |