Skip to content

Instantly share code, notes, and snippets.

@varun-dhawan

varun-dhawan/AutoVacuumMonitoring.md

Last active February 2, 2023 04:44
Show Gist options
  • Save varun-dhawan/50d12e68c030f7eabd32a384ee7a2186 to your computer and use it in GitHub Desktop.
Save varun-dhawan/50d12e68c030f7eabd32a384ee7a2186 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. varun-dhawan revised this gist Feb 2, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -22,7 +22,7 @@ We are exposing 12 new metrics that customers can use to investigate and resolve

    ## Enabling Autovacuum metrics
    * Autovacuum metrics are disabled by default
    * To enable these metrics, please turn ON the server parameter `metrics.autovacuum_diagnostics`.
    * To enable these metrics, please turn ON the server parameter `metrics.autovacuum_diagnostics`
    * This parameter is dynamic, hence will not require instance restart.

    ## List of Autovacuum metrics
  2. varun-dhawan revised this gist Jan 31, 2023. No changes.
  3. varun-dhawan revised this gist Jan 31, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -8,7 +8,7 @@ ms.author: varun.dhawan
    ms.date: 12/01/2022
    ---

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

    ## Autovacuum

  4. varun-dhawan revised this gist Jan 27, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -18,7 +18,7 @@ Autovacuum is a daemon or background utility process offered by PostgreSQL to us

    Typically once you have enabled autovacuuming in Azure Database for Postgres Flexible Server, customers don't need to think about how or when the vacuuming is performed, as the process is automatically handled by the database. However on a busy server with high transactional workload, vacuuming schedules may not be able to keep up with the pace of the changes. In worse sistuations, vacuum processes may not be running at all, that in turn will negatively impact database performance and resource usage. With Autovacuum metrics, our goal is to expose some key autovacuum metrics, that will help our customers to ensure vacuuming is working as expected.

    We are exposing 24 new metrics that customers can use to investigate and resolve issues that prevent VACUUMs from running efficiently. Each metric is emitted at a **30 minute** frequency, and has up to **93 days** of retenion. Customers can configure alerts on the metrics and can also access the new metrics dimensions, to split and filter the metrics data on database name.
    We are exposing 12 new metrics that customers can use to investigate and resolve issues that prevent VACUUMs from running efficiently. Each metric is emitted at a **30 minute** frequency, and has up to **93 days** of retenion. Customers can configure alerts on the metrics and can also access the new metrics dimensions, to split and filter the metrics data on database name.

    ## Enabling Autovacuum metrics
    * Autovacuum metrics are disabled by default
  5. varun-dhawan revised this gist Jan 26, 2023. 1 changed file with 7 additions and 19 deletions.
    26 changes: 7 additions & 19 deletions AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -29,30 +29,18 @@ We are exposing 24 new metrics that customers can use to investigate and resolve

    |Display Name |Metric ID |Unit |Description |Dimension |Default enabled|
    |-------------------------------------------------|-------------------------------|-----|--------------------------------------------------------------------------------------------------------|------------|---------------|
    |**Estimated Live Rows** (Preview) |n_live_tup |Count|Estimated number of live rows for all tables in this database |DatabaseName|No |
    |**Estimated Live Rows User Tables** (Preview) |n_live_tup_user_tables |Count|Estimated number of live rows for user only tables in this database |DatabaseName|No |
    |**Estimated Dead Rows** (Preview) |n_dead_tup |Count|Estimated number of dead rows for all tables in this database |DatabaseName|No |
    |**Estimated Dead Rows User Tables** (Preview) |n_dead_tup_user_tables |Count|Estimated number of dead rows for user only tables in this database |DatabaseName|No |
    |**Vacuum Counter** (Preview) |vacuum_count |Count|Number of times all the tables have been manually vacuumed in this database (not counting VACUUM FULL) |DatabaseName|No |
    |**Vacuum Counter User Tables** (Preview) |vacuum_count_user_tables |Count|Number of times user only tables have been manually vacuumed in this database (not counting VACUUM FULL)|DatabaseName|No |
    |**AutoVacuum Counter** (Preview) |autovacuum_count |Count|Number of times all the tables have been vacuumed by the autovacuum daemon in this database |DatabaseName|No |
    |**AutoVacuum Counter User Tables** (Preview) |autovacuum_count_user_tables |Count|Number of times user only tables have been vacuumed by the autovacuum daemon in this database |DatabaseName|No |
    |**Analyze Counter** (Preview) |analyze_count |Count|Number of times all the tables have been manually analyzed in this database |DatabaseName|No |
    |**Analyze Counter User Tables** (Preview) |analyze_count_user_tables |Count|Number of times user only tables have been manually analyzed in this database |DatabaseName|No |
    |**AutoAnalyze Counter** (Preview) |autoanalyze_count |Count|Number of times all the tables have been analyzed by the autovacuum daemon in this database |DatabaseName|No |
    |**AutoAnalyze Counter User Tables** (Preview) |autoanalyze_count_user_tables |Count|Number of times user only tables have been analyzed by the autovacuum daemon in this database |DatabaseName|No |
    |**Estimated Modifications** (Preview) |n_mod_since_analyze |Count|Estimated number of rows modified since tables were last analyzed |DatabaseName|No |
    |**AutoVacuum Counter User Tables** (Preview) |autovacuum_count_user_tables |Count|Number of times user only tables have been vacuumed by the autovacuum daemon in this database |DatabaseName|No |
    |**Estimated Dead Rows User Tables** (Preview) |n_dead_tup_user_tables |Count|Estimated number of dead rows for user only tables in this database |DatabaseName|No |
    |**Estimated Live Rows User Tables** (Preview) |n_live_tup_user_tables |Count|Estimated number of live rows for user only tables in this database |DatabaseName|No |
    |**Estimated Modifications User Tables** (Preview)|n_mod_since_analyze_user_tables|Count|Estimated number of rows modified since user only tables were last analyzed |DatabaseName|No |
    |**Tables Counter** (Preview) |tables_counter |Count|Number of all tables in this database |DatabaseName|No |
    |**User Tables Counter** (Preview) |tables_counter_user_tables |Count|Number of user only tables in this database |DatabaseName|No |
    |**Tables Vacuumed** (Preview) |tables_vacuumed |Count|Number of tables that have been vacuumed in this database |DatabaseName|No |
    |**User Tables Vacuumed** (Preview) |tables_vacuumed_user_tables |Count|Number of user only tables that have been vacuumed in this database |DatabaseName|No |
    |**Tables AutoVacuumed** (Preview) |tables_autovacuumed |Count|Number of tables that have been vacuumed by the autovacuum daemon in this database |DatabaseName|No |
    |**User Tables AutoVacuumed** (Preview) |tables_autovacuumed_user_tables|Count|Number of user only tables that have been vacuumed by the autovacuum daemon in this database |DatabaseName|No |
    |**Tables Analyzed** (Preview) |tables_analyzed |Count|Number of tables that have been analyzed in this database |DatabaseName|No |
    |**User Tables Analyzed** (Preview) |tables_analyzed_user_tables |Count|Number of user only tables that have been analyzed in this database |DatabaseName|No |
    |**Tables AutoAnalyzed** (Preview) |tables_autoanalyzed |Count|Number of tables that have been analyzed by the autovacuum daemon in this database |DatabaseName|No |
    |**User Tables AutoAnalyzed** (Preview) |tables_autoanalyzed_user_tables|Count|Number of user only tables that have been analyzed by the autovacuum daemon in this database |DatabaseName|No |
    |**User Tables AutoVacuumed** (Preview) |tables_autovacuumed_user_tables|Count|Number of user only tables that have been vacuumed by the autovacuum daemon in this database |DatabaseName|No |
    |**User Tables Counter** (Preview) |tables_counter_user_tables |Count|Number of user only tables in this database |DatabaseName|No |
    |**User Tables Vacuumed** (Preview) |tables_vacuumed_user_tables |Count|Number of user only tables that have been vacuumed in this database |DatabaseName|No |
    |**Vacuum Counter User Tables** (Preview) |vacuum_count_user_tables |Count|Number of times user only tables have been manually vacuumed in this database (not counting VACUUM FULL)|DatabaseName|No |

    ## References

  6. varun-dhawan revised this gist Jan 18, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -60,4 +60,4 @@ Postgres Vacuuming Basics - https://www.postgresql.org/docs/current/routine-vacu

    ## Team
    * Engineering - [email protected]
    * Product - varun.dhawan@microsoft.com
    * Product - Varun.Dhawan@microsoft.com
  7. varun-dhawan revised this gist Jan 18, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -4,7 +4,7 @@ description: Metrics to monitor Auto Vacuum
    ms.service: postgresql
    ms.subservice: flexible-server
    ms.topic: conceptual
    ms.author: varundhawan
    ms.author: varun.dhawan
    ms.date: 12/01/2022
    ---

  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 AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -8,7 +8,7 @@ ms.author: varundhawan
    ms.date: 12/01/2022
    ---

    # Azure Postgres Flexible Server - Auto Vacuum Moitoring (Preview) [Zn Sem]
    # Azure Postgres Flexible Server - Autovacuum metrics (Preview) [Zn Sem]

    ## Autovacuum

  10. varun-dhawan revised this gist Jan 18, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -8,7 +8,7 @@ ms.author: varundhawan
    ms.date: 12/01/2022
    ---

    # Azure Database for PostgreSQL Flexible Server - Auto Vacuum Moitoring (Preview) [Zn Sem]
    # Azure Postgres Flexible Server - Auto Vacuum Moitoring (Preview) [Zn Sem]

    ## Autovacuum

  11. varun-dhawan revised this gist Jan 18, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -8,7 +8,7 @@ ms.author: varundhawan
    ms.date: 12/01/2022
    ---

    # Azure Database for PostgreSQL Flexible Server - Auto Vacuum Moitoring (Preview)
    # Azure Database for PostgreSQL Flexible Server - Auto Vacuum Moitoring (Preview) [Zn Sem]

    ## Autovacuum

  12. varun-dhawan revised this gist Jan 18, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -25,7 +25,7 @@ We are exposing 24 new metrics that customers can use to investigate and resolve
    * To enable these metrics, please turn ON the server parameter `metrics.autovacuum_diagnostics`.
    * This parameter is dynamic, hence will not require instance restart.

    ## Autovacuum metrics - List
    ## List of Autovacuum metrics

    |Display Name |Metric ID |Unit |Description |Dimension |Default enabled|
    |-------------------------------------------------|-------------------------------|-----|--------------------------------------------------------------------------------------------------------|------------|---------------|
  13. varun-dhawan revised this gist Jan 18, 2023. 1 changed file with 26 additions and 26 deletions.
    52 changes: 26 additions & 26 deletions AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -27,32 +27,32 @@ We are exposing 24 new metrics that customers can use to investigate and resolve

    ## Autovacuum metrics - List

    |Display Name |Metric ID |Unit |Description |Dimension |Default enabled|
    |---------------------------------------------|-------------------------------|-----|--------------------------------------------------------------------------------------------------------|------------|---------------|
    |Estimated Live Rows (Preview) |n_live_tup |Count|Estimated number of live rows for all tables in this database |DatabaseName|No |
    |Estimated Live Rows User Tables (Preview) |n_live_tup_user_tables |Count|Estimated number of live rows for user only tables in this database |DatabaseName|No |
    |Estimated Dead Rows (Preview) |n_dead_tup |Count|Estimated number of dead rows for all tables in this database |DatabaseName|No |
    |Estimated Dead Rows User Tables (Preview) |n_dead_tup_user_tables |Count|Estimated number of dead rows for user only tables in this database |DatabaseName|No |
    |Vacuum Counter (Preview) |vacuum_count |Count|Number of times all the tables have been manually vacuumed in this database (not counting VACUUM FULL) |DatabaseName|No |
    |Vacuum Counter User Tables (Preview) |vacuum_count_user_tables |Count|Number of times user only tables have been manually vacuumed in this database (not counting VACUUM FULL)|DatabaseName|No |
    |AutoVacuum Counter (Preview) |autovacuum_count |Count|Number of times all the tables have been vacuumed by the autovacuum daemon in this database |DatabaseName|No |
    |AutoVacuum Counter User Tables (Preview) |autovacuum_count_user_tables |Count|Number of times user only tables have been vacuumed by the autovacuum daemon in this database |DatabaseName|No |
    |Analyze Counter (Preview) |analyze_count |Count|Number of times all the tables have been manually analyzed in this database |DatabaseName|No |
    |Analyze Counter User Tables (Preview) |analyze_count_user_tables |Count|Number of times user only tables have been manually analyzed in this database |DatabaseName|No |
    |AutoAnalyze Counter (Preview) |autoanalyze_count |Count|Number of times all the tables have been analyzed by the autovacuum daemon in this database |DatabaseName|No |
    |AutoAnalyze Counter User Tables (Preview) |autoanalyze_count_user_tables |Count|Number of times user only tables have been analyzed by the autovacuum daemon in this database |DatabaseName|No |
    |Estimated Modifications (Preview) |n_mod_since_analyze |Count|Estimated number of rows modified since tables were last analyzed |DatabaseName|No |
    |Estimated Modifications User Tables (Preview)|n_mod_since_analyze_user_tables|Count|Estimated number of rows modified since user only tables were last analyzed |DatabaseName|No |
    |Tables Counter (Preview) |tables_counter |Count|Number of all tables in this database |DatabaseName|No |
    |User Tables Counter (Preview) |tables_counter_user_tables |Count|Number of user only tables in this database |DatabaseName|No |
    |Tables Vacuumed (Preview) |tables_vacuumed |Count|Number of tables that have been vacuumed in this database |DatabaseName|No |
    |User Tables Vacuumed (Preview) |tables_vacuumed_user_tables |Count|Number of user only tables that have been vacuumed in this database |DatabaseName|No |
    |Tables AutoVacuumed (Preview) |tables_autovacuumed |Count|Number of tables that have been vacuumed by the autovacuum daemon in this database |DatabaseName|No |
    |User Tables AutoVacuumed (Preview) |tables_autovacuumed_user_tables|Count|Number of user only tables that have been vacuumed by the autovacuum daemon in this database |DatabaseName|No |
    |Tables Analyzed (Preview) |tables_analyzed |Count|Number of tables that have been analyzed in this database |DatabaseName|No |
    |User Tables Analyzed (Preview) |tables_analyzed_user_tables |Count|Number of user only tables that have been analyzed in this database |DatabaseName|No |
    |Tables AutoAnalyzed (Preview) |tables_autoanalyzed |Count|Number of tables that have been analyzed by the autovacuum daemon in this database |DatabaseName|No |
    |User Tables AutoAnalyzed (Preview) |tables_autoanalyzed_user_tables|Count|Number of user only tables that have been analyzed by the autovacuum daemon in this database |DatabaseName|No |
    |Display Name |Metric ID |Unit |Description |Dimension |Default enabled|
    |-------------------------------------------------|-------------------------------|-----|--------------------------------------------------------------------------------------------------------|------------|---------------|
    |**Estimated Live Rows** (Preview) |n_live_tup |Count|Estimated number of live rows for all tables in this database |DatabaseName|No |
    |**Estimated Live Rows User Tables** (Preview) |n_live_tup_user_tables |Count|Estimated number of live rows for user only tables in this database |DatabaseName|No |
    |**Estimated Dead Rows** (Preview) |n_dead_tup |Count|Estimated number of dead rows for all tables in this database |DatabaseName|No |
    |**Estimated Dead Rows User Tables** (Preview) |n_dead_tup_user_tables |Count|Estimated number of dead rows for user only tables in this database |DatabaseName|No |
    |**Vacuum Counter** (Preview) |vacuum_count |Count|Number of times all the tables have been manually vacuumed in this database (not counting VACUUM FULL) |DatabaseName|No |
    |**Vacuum Counter User Tables** (Preview) |vacuum_count_user_tables |Count|Number of times user only tables have been manually vacuumed in this database (not counting VACUUM FULL)|DatabaseName|No |
    |**AutoVacuum Counter** (Preview) |autovacuum_count |Count|Number of times all the tables have been vacuumed by the autovacuum daemon in this database |DatabaseName|No |
    |**AutoVacuum Counter User Tables** (Preview) |autovacuum_count_user_tables |Count|Number of times user only tables have been vacuumed by the autovacuum daemon in this database |DatabaseName|No |
    |**Analyze Counter** (Preview) |analyze_count |Count|Number of times all the tables have been manually analyzed in this database |DatabaseName|No |
    |**Analyze Counter User Tables** (Preview) |analyze_count_user_tables |Count|Number of times user only tables have been manually analyzed in this database |DatabaseName|No |
    |**AutoAnalyze Counter** (Preview) |autoanalyze_count |Count|Number of times all the tables have been analyzed by the autovacuum daemon in this database |DatabaseName|No |
    |**AutoAnalyze Counter User Tables** (Preview) |autoanalyze_count_user_tables |Count|Number of times user only tables have been analyzed by the autovacuum daemon in this database |DatabaseName|No |
    |**Estimated Modifications** (Preview) |n_mod_since_analyze |Count|Estimated number of rows modified since tables were last analyzed |DatabaseName|No |
    |**Estimated Modifications User Tables** (Preview)|n_mod_since_analyze_user_tables|Count|Estimated number of rows modified since user only tables were last analyzed |DatabaseName|No |
    |**Tables Counter** (Preview) |tables_counter |Count|Number of all tables in this database |DatabaseName|No |
    |**User Tables Counter** (Preview) |tables_counter_user_tables |Count|Number of user only tables in this database |DatabaseName|No |
    |**Tables Vacuumed** (Preview) |tables_vacuumed |Count|Number of tables that have been vacuumed in this database |DatabaseName|No |
    |**User Tables Vacuumed** (Preview) |tables_vacuumed_user_tables |Count|Number of user only tables that have been vacuumed in this database |DatabaseName|No |
    |**Tables AutoVacuumed** (Preview) |tables_autovacuumed |Count|Number of tables that have been vacuumed by the autovacuum daemon in this database |DatabaseName|No |
    |**User Tables AutoVacuumed** (Preview) |tables_autovacuumed_user_tables|Count|Number of user only tables that have been vacuumed by the autovacuum daemon in this database |DatabaseName|No |
    |**Tables Analyzed** (Preview) |tables_analyzed |Count|Number of tables that have been analyzed in this database |DatabaseName|No |
    |**User Tables Analyzed** (Preview) |tables_analyzed_user_tables |Count|Number of user only tables that have been analyzed in this database |DatabaseName|No |
    |**Tables AutoAnalyzed** (Preview) |tables_autoanalyzed |Count|Number of tables that have been analyzed by the autovacuum daemon in this database |DatabaseName|No |
    |**User Tables AutoAnalyzed** (Preview) |tables_autoanalyzed_user_tables|Count|Number of user only tables that have been analyzed by the autovacuum daemon in this database |DatabaseName|No |

    ## References

  14. varun-dhawan revised this gist Jan 18, 2023. 1 changed file with 26 additions and 26 deletions.
    52 changes: 26 additions & 26 deletions AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -27,32 +27,32 @@ We are exposing 24 new metrics that customers can use to investigate and resolve

    ## Autovacuum metrics - List

    |Metric ID |Unit |Aggregation|Display Name |Metric Description |Dimension |
    |-------------------------------|-----|-----------|---------------------------------------------|------------------------------------------------------------------------------------------------------------|------------|
    |n_live_tup |Count|Maximum |**Estimated Live Rows** (Preview) |Estimated number of live rows for all tables in this database |DatabaseName|
    |n_live_tup_user_tables |Count|Maximum |**Estimated Live Rows User Tables** (Preview) |Estimated number of live rows for user only tables in this database |DatabaseName|
    |n_dead_tup |Count|Maximum |**Estimated Dead Rows** (Preview) |Estimated number of dead rows for all tables in this database |DatabaseName|
    |n_dead_tup_user_tables |Count|Maximum |**Estimated Dead Rows User Tables** (Preview) |Estimated number of dead rows for user only tables in this database |DatabaseName|
    |vacuum_count |Count|Maximum |**Vacuum Counter** (Preview) |Number of times all the tables have been manually vacuumed in this database (not counting VACUUM FULL) |DatabaseName|
    |vacuum_count_user_tables |Count|Maximum |**Vacuum Counter User Tables** (Preview) |Number of times user only tables have been manually vacuumed in this database (not counting VACUUM FULL)|DatabaseName|
    |autovacuum_count |Count|Maximum |**AutoVacuum Counter** (Preview) |Number of times all the tables have been vacuumed by the autovacuum daemon in this database |DatabaseName|
    |autovacuum_count_user_tables |Count|Maximum |**AutoVacuum Counter User Tables** (Preview) |Number of times user only tables have been vacuumed by the autovacuum daemon in this database |DatabaseName|
    |analyze_count |Count|Maximum |**Analyze Counter** (Preview) |Number of times all the tables have been manually analyzed in this database |DatabaseName|
    |analyze_count_user_tables |Count|Maximum |**Analyze Counter User Tables** (Preview) |Number of times user only tables have been manually analyzed in this database |DatabaseName|
    |autoanalyze_count |Count|Maximum |**AutoAnalyze Counter** (Preview) |Number of times all the tables have been analyzed by the autovacuum daemon in this database |DatabaseName|
    |autoanalyze_count_user_tables |Count|Maximum |**AutoAnalyze Counter User Tables** (Preview) |Number of times user only tables have been analyzed by the autovacuum daemon in this database |DatabaseName|
    |n_mod_since_analyze |Count|Maximum |**Estimated Modifications** (Preview) |Estimated number of rows modified since tables were last analyzed |DatabaseName|
    |n_mod_since_analyze_user_tables|Count|Maximum |**Estimated Modifications** User Tables (Preview)|Estimated number of rows modified since user only tables were last analyzed |DatabaseName|
    |tables_counter |Count|Maximum |**Tables Counter** (Preview) |Number of all tables in this database |DatabaseName|
    |tables_counter_user_tables |Count|Maximum |**User Tables Counter** (Preview) |Number of user only tables in this database |DatabaseName|
    |tables_vacuumed |Count|Maximum |**Tables Vacuumed** (Preview) |Number of tables that have been vacuumed in this database |DatabaseName|
    |tables_vacuumed_user_tables |Count|Maximum |**User Tables Vacuumed** (Preview) |Number of user only tables that have been vacuumed in this database |DatabaseName|
    |tables_autovacuumed |Count|Maximum |**Tables AutoVacuumed** (Preview) |Number of tables that have been vacuumed by the autovacuum daemon in this database |DatabaseName|
    |tables_autovacuumed_user_tables|Count|Maximum |**User Tables AutoVacuumed** (Preview) |Number of user only tables that have been vacuumed by the autovacuum daemon in this database |DatabaseName|
    |tables_analyzed |Count|Maximum |**Tables Analyzed** (Preview) |Number of tables that have been analyzed in this database |DatabaseName|
    |tables_analyzed_user_tables |Count|Maximum |**User Tables Analyzed** (Preview) |Number of user only tables that have been analyzed in this database |DatabaseName|
    |tables_autoanalyzed |Count|Maximum |**Tables AutoAnalyzed** (Preview) |Number of tables that have been analyzed by the autovacuum daemon in this database |DatabaseName|
    |tables_autoanalyzed_user_tables|Count|Maximum |**User Tables AutoAnalyzed** (Preview) |Number of user only tables that have been analyzed by the autovacuum daemon in this database |DatabaseName|
    |Display Name |Metric ID |Unit |Description |Dimension |Default enabled|
    |---------------------------------------------|-------------------------------|-----|--------------------------------------------------------------------------------------------------------|------------|---------------|
    |Estimated Live Rows (Preview) |n_live_tup |Count|Estimated number of live rows for all tables in this database |DatabaseName|No |
    |Estimated Live Rows User Tables (Preview) |n_live_tup_user_tables |Count|Estimated number of live rows for user only tables in this database |DatabaseName|No |
    |Estimated Dead Rows (Preview) |n_dead_tup |Count|Estimated number of dead rows for all tables in this database |DatabaseName|No |
    |Estimated Dead Rows User Tables (Preview) |n_dead_tup_user_tables |Count|Estimated number of dead rows for user only tables in this database |DatabaseName|No |
    |Vacuum Counter (Preview) |vacuum_count |Count|Number of times all the tables have been manually vacuumed in this database (not counting VACUUM FULL) |DatabaseName|No |
    |Vacuum Counter User Tables (Preview) |vacuum_count_user_tables |Count|Number of times user only tables have been manually vacuumed in this database (not counting VACUUM FULL)|DatabaseName|No |
    |AutoVacuum Counter (Preview) |autovacuum_count |Count|Number of times all the tables have been vacuumed by the autovacuum daemon in this database |DatabaseName|No |
    |AutoVacuum Counter User Tables (Preview) |autovacuum_count_user_tables |Count|Number of times user only tables have been vacuumed by the autovacuum daemon in this database |DatabaseName|No |
    |Analyze Counter (Preview) |analyze_count |Count|Number of times all the tables have been manually analyzed in this database |DatabaseName|No |
    |Analyze Counter User Tables (Preview) |analyze_count_user_tables |Count|Number of times user only tables have been manually analyzed in this database |DatabaseName|No |
    |AutoAnalyze Counter (Preview) |autoanalyze_count |Count|Number of times all the tables have been analyzed by the autovacuum daemon in this database |DatabaseName|No |
    |AutoAnalyze Counter User Tables (Preview) |autoanalyze_count_user_tables |Count|Number of times user only tables have been analyzed by the autovacuum daemon in this database |DatabaseName|No |
    |Estimated Modifications (Preview) |n_mod_since_analyze |Count|Estimated number of rows modified since tables were last analyzed |DatabaseName|No |
    |Estimated Modifications User Tables (Preview)|n_mod_since_analyze_user_tables|Count|Estimated number of rows modified since user only tables were last analyzed |DatabaseName|No |
    |Tables Counter (Preview) |tables_counter |Count|Number of all tables in this database |DatabaseName|No |
    |User Tables Counter (Preview) |tables_counter_user_tables |Count|Number of user only tables in this database |DatabaseName|No |
    |Tables Vacuumed (Preview) |tables_vacuumed |Count|Number of tables that have been vacuumed in this database |DatabaseName|No |
    |User Tables Vacuumed (Preview) |tables_vacuumed_user_tables |Count|Number of user only tables that have been vacuumed in this database |DatabaseName|No |
    |Tables AutoVacuumed (Preview) |tables_autovacuumed |Count|Number of tables that have been vacuumed by the autovacuum daemon in this database |DatabaseName|No |
    |User Tables AutoVacuumed (Preview) |tables_autovacuumed_user_tables|Count|Number of user only tables that have been vacuumed by the autovacuum daemon in this database |DatabaseName|No |
    |Tables Analyzed (Preview) |tables_analyzed |Count|Number of tables that have been analyzed in this database |DatabaseName|No |
    |User Tables Analyzed (Preview) |tables_analyzed_user_tables |Count|Number of user only tables that have been analyzed in this database |DatabaseName|No |
    |Tables AutoAnalyzed (Preview) |tables_autoanalyzed |Count|Number of tables that have been analyzed by the autovacuum daemon in this database |DatabaseName|No |
    |User Tables AutoAnalyzed (Preview) |tables_autoanalyzed_user_tables|Count|Number of user only tables that have been analyzed by the autovacuum daemon in this database |DatabaseName|No |

    ## References

  15. varun-dhawan revised this gist Jan 18, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -27,7 +27,7 @@ We are exposing 24 new metrics that customers can use to investigate and resolve

    ## Autovacuum metrics - List

    |Metric ID |Unit |Aggregation|Metric Name |Metric Description |Dimension |
    |Metric ID |Unit |Aggregation|Display Name |Metric Description |Dimension |
    |-------------------------------|-----|-----------|---------------------------------------------|------------------------------------------------------------------------------------------------------------|------------|
    |n_live_tup |Count|Maximum |**Estimated Live Rows** (Preview) |Estimated number of live rows for all tables in this database |DatabaseName|
    |n_live_tup_user_tables |Count|Maximum |**Estimated Live Rows User Tables** (Preview) |Estimated number of live rows for user only tables in this database |DatabaseName|
  16. varun-dhawan revised this gist Jan 18, 2023. No changes.
  17. varun-dhawan revised this gist Jan 18, 2023. 1 changed file with 2 additions and 1 deletion.
    3 changes: 2 additions & 1 deletion AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -22,7 +22,8 @@ We are exposing 24 new metrics that customers can use to investigate and resolve

    ## Enabling Autovacuum metrics
    * Autovacuum metrics are disabled by default
    * To enable these metrics, please turn ON the server parameter `metrics.autovacuum_diagnostics`. This parameter is dynamic, hence will not require instance restart.
    * To enable these metrics, please turn ON the server parameter `metrics.autovacuum_diagnostics`.
    * This parameter is dynamic, hence will not require instance restart.

    ## Autovacuum metrics - List

  18. varun-dhawan revised this gist Jan 18, 2023. 1 changed file with 3 additions and 0 deletions.
    3 changes: 3 additions & 0 deletions AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -20,6 +20,9 @@ Typically once you have enabled autovacuuming in Azure Database for Postgres Fle

    We are exposing 24 new metrics that customers can use to investigate and resolve issues that prevent VACUUMs from running efficiently. Each metric is emitted at a **30 minute** frequency, and has up to **93 days** of retenion. Customers can configure alerts on the metrics and can also access the new metrics dimensions, to split and filter the metrics data on database name.

    ## Enabling Autovacuum metrics
    * Autovacuum metrics are disabled by default
    * To enable these metrics, please turn ON the server parameter `metrics.autovacuum_diagnostics`. This parameter is dynamic, hence will not require instance restart.

    ## Autovacuum metrics - List

  19. varun-dhawan revised this gist Jan 17, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -21,7 +21,7 @@ Typically once you have enabled autovacuuming in Azure Database for Postgres Fle
    We are exposing 24 new metrics that customers can use to investigate and resolve issues that prevent VACUUMs from running efficiently. Each metric is emitted at a **30 minute** frequency, and has up to **93 days** of retenion. Customers can configure alerts on the metrics and can also access the new metrics dimensions, to split and filter the metrics data on database name.


    ## Autovacuum metrics - list
    ## Autovacuum metrics - List

    |Metric ID |Unit |Aggregation|Metric Name |Metric Description |Dimension |
    |-------------------------------|-----|-----------|---------------------------------------------|------------------------------------------------------------------------------------------------------------|------------|
  20. varun-dhawan revised this gist Jan 17, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -21,7 +21,7 @@ Typically once you have enabled autovacuuming in Azure Database for Postgres Fle
    We are exposing 24 new metrics that customers can use to investigate and resolve issues that prevent VACUUMs from running efficiently. Each metric is emitted at a **30 minute** frequency, and has up to **93 days** of retenion. Customers can configure alerts on the metrics and can also access the new metrics dimensions, to split and filter the metrics data on database name.


    ## List of Metrics
    ## Autovacuum metrics - list

    |Metric ID |Unit |Aggregation|Metric Name |Metric Description |Dimension |
    |-------------------------------|-----|-----------|---------------------------------------------|------------------------------------------------------------------------------------------------------------|------------|
  21. varun-dhawan revised this gist Jan 17, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -10,7 +10,7 @@ ms.date: 12/01/2022

    # Azure Database for PostgreSQL Flexible Server - Auto Vacuum Moitoring (Preview)

    ## What is Autovacuum?
    ## Autovacuum

    Autovacuum is a daemon or background utility process offered by PostgreSQL to users to issue a regular clean-up of redundant data in the database and server. It does not require the user to manually issue the vacuuming and instead, is defined in the postgresql.conf file. In order to access this file, simply direct yourself to the following directory on your terminal and then open the file in a suitable editor. For more details on autovacuum, refer postgres [docs](https://www.postgresql.org/docs/14/routine-vacuuming.html)

  22. varun-dhawan revised this gist Jan 17, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -18,7 +18,7 @@ Autovacuum is a daemon or background utility process offered by PostgreSQL to us

    Typically once you have enabled autovacuuming in Azure Database for Postgres Flexible Server, customers don't need to think about how or when the vacuuming is performed, as the process is automatically handled by the database. However on a busy server with high transactional workload, vacuuming schedules may not be able to keep up with the pace of the changes. In worse sistuations, vacuum processes may not be running at all, that in turn will negatively impact database performance and resource usage. With Autovacuum metrics, our goal is to expose some key autovacuum metrics, that will help our customers to ensure vacuuming is working as expected.

    We are exposing 24 new metrics that customers can use to investigate and resolve issues that prevent VACUUMs from running efficiently. Each metric is emitted at a **30 minute** frequency, and has up to **93 days** of retenion. Customers can configure alerts on the metrics and can also access the new metrics dimensions, to split and filter the metrics data on database name, state, etc.
    We are exposing 24 new metrics that customers can use to investigate and resolve issues that prevent VACUUMs from running efficiently. Each metric is emitted at a **30 minute** frequency, and has up to **93 days** of retenion. Customers can configure alerts on the metrics and can also access the new metrics dimensions, to split and filter the metrics data on database name.


    ## List of Metrics
  23. varun-dhawan revised this gist Jan 17, 2023. 1 changed file with 1 addition and 2 deletions.
    3 changes: 1 addition & 2 deletions AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -18,8 +18,7 @@ Autovacuum is a daemon or background utility process offered by PostgreSQL to us

    Typically once you have enabled autovacuuming in Azure Database for Postgres Flexible Server, customers don't need to think about how or when the vacuuming is performed, as the process is automatically handled by the database. However on a busy server with high transactional workload, vacuuming schedules may not be able to keep up with the pace of the changes. In worse sistuations, vacuum processes may not be running at all, that in turn will negatively impact database performance and resource usage. With Autovacuum metrics, our goal is to expose some key autovacuum metrics, that will help our customers to ensure vacuuming is working as expected.

    We are exposing 24 new metrics that customers can use to investigate and resolve issues that prevent VACUUMs from running efficiently. Each metric is emitted at a **30 minute** frequency, and has up to **93 days** of retenion. Customers ou can configure alerts on the metrics.

    We are exposing 24 new metrics that customers can use to investigate and resolve issues that prevent VACUUMs from running efficiently. Each metric is emitted at a **30 minute** frequency, and has up to **93 days** of retenion. Customers can configure alerts on the metrics and can also access the new metrics dimensions, to split and filter the metrics data on database name, state, etc.


    ## List of Metrics
  24. varun-dhawan revised this gist Jan 17, 2023. 1 changed file with 1 addition and 3 deletions.
    4 changes: 1 addition & 3 deletions AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -18,9 +18,7 @@ Autovacuum is a daemon or background utility process offered by PostgreSQL to us

    Typically once you have enabled autovacuuming in Azure Database for Postgres Flexible Server, customers don't need to think about how or when the vacuuming is performed, as the process is automatically handled by the database. However on a busy server with high transactional workload, vacuuming schedules may not be able to keep up with the pace of the changes. In worse sistuations, vacuum processes may not be running at all, that in turn will negatively impact database performance and resource usage. With Autovacuum metrics, our goal is to expose some key autovacuum metrics, that will help our customers to ensure vacuuming is working as expected.

    Here

    This article will provide some background on why vacuuming is important in PostgreSQL, and explore a few ways to investigate and resolve issues that prevent VACUUMs from running efficiently
    We are exposing 24 new metrics that customers can use to investigate and resolve issues that prevent VACUUMs from running efficiently. Each metric is emitted at a **30 minute** frequency, and has up to **93 days** of retenion. Customers ou can configure alerts on the metrics.



  25. varun-dhawan revised this gist Jan 17, 2023. 1 changed file with 9 additions and 0 deletions.
    9 changes: 9 additions & 0 deletions AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -14,6 +14,15 @@ ms.date: 12/01/2022

    Autovacuum is a daemon or background utility process offered by PostgreSQL to users to issue a regular clean-up of redundant data in the database and server. It does not require the user to manually issue the vacuuming and instead, is defined in the postgresql.conf file. In order to access this file, simply direct yourself to the following directory on your terminal and then open the file in a suitable editor. For more details on autovacuum, refer postgres [docs](https://www.postgresql.org/docs/14/routine-vacuuming.html)

    ## Autovacuum Monitoring

    Typically once you have enabled autovacuuming in Azure Database for Postgres Flexible Server, customers don't need to think about how or when the vacuuming is performed, as the process is automatically handled by the database. However on a busy server with high transactional workload, vacuuming schedules may not be able to keep up with the pace of the changes. In worse sistuations, vacuum processes may not be running at all, that in turn will negatively impact database performance and resource usage. With Autovacuum metrics, our goal is to expose some key autovacuum metrics, that will help our customers to ensure vacuuming is working as expected.

    Here

    This article will provide some background on why vacuuming is important in PostgreSQL, and explore a few ways to investigate and resolve issues that prevent VACUUMs from running efficiently



    ## List of Metrics

  26. varun-dhawan revised this gist Jan 17, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -12,7 +12,7 @@ ms.date: 12/01/2022

    ## What is Autovacuum?

    Autovacuum is a daemon or background utility process offered by PostgreSQL to users to issue a regular clean-up of redundant data in the database and server. It does not require the user to manually issue the vacuuming and instead, is defined in the postgresql.conf file. In order to access this file, simply direct yourself to the following directory on your terminal and then open the file in a suitable editor.
    Autovacuum is a daemon or background utility process offered by PostgreSQL to users to issue a regular clean-up of redundant data in the database and server. It does not require the user to manually issue the vacuuming and instead, is defined in the postgresql.conf file. In order to access this file, simply direct yourself to the following directory on your terminal and then open the file in a suitable editor. For more details on autovacuum, refer postgres [docs](https://www.postgresql.org/docs/14/routine-vacuuming.html)


    ## List of Metrics
  27. varun-dhawan revised this gist Jan 17, 2023. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,5 +1,5 @@
    ---
    title: Azure Database for PostgreSQL Flexible Server - Auto Vacuum Moitoring (Preview)
    title: Azure Database for PostgreSQL Flexible Server - Autovacuum metrics (Preview)
    description: Metrics to monitor Auto Vacuum
    ms.service: postgresql
    ms.subservice: flexible-server
    @@ -10,7 +10,7 @@ ms.date: 12/01/2022

    # Azure Database for PostgreSQL Flexible Server - Auto Vacuum Moitoring (Preview)

    What is Autovacuum?
    ## What is Autovacuum?

    Autovacuum is a daemon or background utility process offered by PostgreSQL to users to issue a regular clean-up of redundant data in the database and server. It does not require the user to manually issue the vacuuming and instead, is defined in the postgresql.conf file. In order to access this file, simply direct yourself to the following directory on your terminal and then open the file in a suitable editor.

  28. varun-dhawan revised this gist Jan 6, 2023. 1 changed file with 26 additions and 26 deletions.
    52 changes: 26 additions & 26 deletions AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -17,32 +17,32 @@ Autovacuum is a daemon or background utility process offered by PostgreSQL to us

    ## List of Metrics

    |Metric ID |Unit |Aggregation|Metric Name |Metric Description |Dimension |Category |
    |-------------------------------|-----|-----------|---------------------------------------------|--------------------------------------------------------------------------------------------------------|------------|--------------------|
    |n_live_tup |Count|Maximum |**Estimated Live Rows** (Preview) |Estimated number of live rows for all tables in this database |DatabaseName|Autovacuum (Preview)|
    |n_live_tup_user_tables |Count|Maximum |**Estimated Live Rows User Tables** (Preview) |Estimated number of live rows for user only tables in this database |DatabaseName|Autovacuum (Preview)|
    |n_dead_tup |Count|Maximum |**Estimated Dead Rows** (Preview) |Estimated number of dead rows for all tables in this database |DatabaseName|Autovacuum (Preview)|
    |n_dead_tup_user_tables |Count|Maximum |**Estimated Dead Rows User Tables** (Preview) |Estimated number of dead rows for user only tables in this database |DatabaseName|Autovacuum (Preview)|
    |vacuum_count |Count|Maximum |**Vacuum Counter** (Preview) |Number of times all the tables have been manually vacuumed in this database (not counting VACUUM FULL) |DatabaseName|Autovacuum (Preview)|
    |vacuum_count_user_tables |Count|Maximum |**Vacuum Counter User Tables** (Preview) |Number of times user only tables have been manually vacuumed in this database (not counting VACUUM FULL)|DatabaseName|Autovacuum (Preview)|
    |autovacuum_count |Count|Maximum |**AutoVacuum Counter** (Preview) |Number of times all the tables have been vacuumed by the autovacuum daemon in this database |DatabaseName|Autovacuum (Preview)|
    |autovacuum_count_user_tables |Count|Maximum |**AutoVacuum Counter User Tables** (Preview) |Number of times user only tables have been vacuumed by the autovacuum daemon in this database |DatabaseName|Autovacuum (Preview)|
    |analyze_count |Count|Maximum |**Analyze Counter** (Preview) |Number of times all the tables have been manually analyzed in this database |DatabaseName|Autovacuum (Preview)|
    |analyze_count_user_tables |Count|Maximum |**Analyze Counter User Tables** (Preview) |Number of times user only tables have been manually analyzed in this database |DatabaseName|Autovacuum (Preview)|
    |autoanalyze_count |Count|Maximum |**AutoAnalyze Counter** (Preview) |Number of times all the tables have been analyzed by the autovacuum daemon in this database |DatabaseName|Autovacuum (Preview)|
    |autoanalyze_count_user_tables |Count|Maximum |**AutoAnalyze Counter User Tables** (Preview) |Number of times user only tables have been analyzed by the autovacuum daemon in this database |DatabaseName|Autovacuum (Preview)|
    |n_mod_since_analyze |Count|Maximum |**Estimated Modifications** (Preview) |Estimated number of rows modified since tables were last analyzed |DatabaseName|Autovacuum (Preview)|
    |n_mod_since_analyze_user_tables|Count|Maximum |**Estimated Modifications** User Tables (Preview)|Estimated number of rows modified since user only tables were last analyzed |DatabaseName|Autovacuum (Preview)|
    |tables_counter |Count|Maximum |**Tables Counter** (Preview) |Number of all tables in this database |DatabaseName|Autovacuum (Preview)|
    |tables_counter_user_tables |Count|Maximum |**User Tables Counter** (Preview) |Number of user only tables in this database |DatabaseName|Autovacuum (Preview)|
    |tables_vacuumed |Count|Maximum |**Tables Vacuumed** (Preview) |Number of tables that have been vacuumed in this database |DatabaseName|Autovacuum (Preview)|
    |tables_vacuumed_user_tables |Count|Maximum |**User Tables Vacuumed** (Preview) |Number of user only tables that have been vacuumed in this database |DatabaseName|Autovacuum (Preview)|
    |tables_autovacuumed |Count|Maximum |**Tables AutoVacuumed** (Preview) |Number of tables that have been vacuumed by the autovacuum daemon in this database |DatabaseName|Autovacuum (Preview)|
    |tables_autovacuumed_user_tables|Count|Maximum |**User Tables AutoVacuumed** (Preview) |Number of user only tables that have been vacuumed by the autovacuum daemon in this database |DatabaseName|Autovacuum (Preview)|
    |tables_analyzed |Count|Maximum |**Tables Analyzed** (Preview) |Number of tables that have been analyzed in this database |DatabaseName|Autovacuum (Preview)|
    |tables_analyzed_user_tables |Count|Maximum |**User Tables Analyzed** (Preview) |Number of user only tables that have been analyzed in this database |DatabaseName|Autovacuum (Preview)|
    |tables_autoanalyzed |Count|Maximum |**Tables AutoAnalyzed** (Preview) |Number of tables that have been analyzed by the autovacuum daemon in this database |DatabaseName|Autovacuum (Preview)|
    |tables_autoanalyzed_user_tables|Count|Maximum |**User Tables AutoAnalyzed** (Preview) |Number of user only tables that have been analyzed by the autovacuum daemon in this database |DatabaseName|Autovacuum (Preview)|
    |Metric ID |Unit |Aggregation|Metric Name |Metric Description |Dimension |
    |-------------------------------|-----|-----------|---------------------------------------------|------------------------------------------------------------------------------------------------------------|------------|
    |n_live_tup |Count|Maximum |**Estimated Live Rows** (Preview) |Estimated number of live rows for all tables in this database |DatabaseName|
    |n_live_tup_user_tables |Count|Maximum |**Estimated Live Rows User Tables** (Preview) |Estimated number of live rows for user only tables in this database |DatabaseName|
    |n_dead_tup |Count|Maximum |**Estimated Dead Rows** (Preview) |Estimated number of dead rows for all tables in this database |DatabaseName|
    |n_dead_tup_user_tables |Count|Maximum |**Estimated Dead Rows User Tables** (Preview) |Estimated number of dead rows for user only tables in this database |DatabaseName|
    |vacuum_count |Count|Maximum |**Vacuum Counter** (Preview) |Number of times all the tables have been manually vacuumed in this database (not counting VACUUM FULL) |DatabaseName|
    |vacuum_count_user_tables |Count|Maximum |**Vacuum Counter User Tables** (Preview) |Number of times user only tables have been manually vacuumed in this database (not counting VACUUM FULL)|DatabaseName|
    |autovacuum_count |Count|Maximum |**AutoVacuum Counter** (Preview) |Number of times all the tables have been vacuumed by the autovacuum daemon in this database |DatabaseName|
    |autovacuum_count_user_tables |Count|Maximum |**AutoVacuum Counter User Tables** (Preview) |Number of times user only tables have been vacuumed by the autovacuum daemon in this database |DatabaseName|
    |analyze_count |Count|Maximum |**Analyze Counter** (Preview) |Number of times all the tables have been manually analyzed in this database |DatabaseName|
    |analyze_count_user_tables |Count|Maximum |**Analyze Counter User Tables** (Preview) |Number of times user only tables have been manually analyzed in this database |DatabaseName|
    |autoanalyze_count |Count|Maximum |**AutoAnalyze Counter** (Preview) |Number of times all the tables have been analyzed by the autovacuum daemon in this database |DatabaseName|
    |autoanalyze_count_user_tables |Count|Maximum |**AutoAnalyze Counter User Tables** (Preview) |Number of times user only tables have been analyzed by the autovacuum daemon in this database |DatabaseName|
    |n_mod_since_analyze |Count|Maximum |**Estimated Modifications** (Preview) |Estimated number of rows modified since tables were last analyzed |DatabaseName|
    |n_mod_since_analyze_user_tables|Count|Maximum |**Estimated Modifications** User Tables (Preview)|Estimated number of rows modified since user only tables were last analyzed |DatabaseName|
    |tables_counter |Count|Maximum |**Tables Counter** (Preview) |Number of all tables in this database |DatabaseName|
    |tables_counter_user_tables |Count|Maximum |**User Tables Counter** (Preview) |Number of user only tables in this database |DatabaseName|
    |tables_vacuumed |Count|Maximum |**Tables Vacuumed** (Preview) |Number of tables that have been vacuumed in this database |DatabaseName|
    |tables_vacuumed_user_tables |Count|Maximum |**User Tables Vacuumed** (Preview) |Number of user only tables that have been vacuumed in this database |DatabaseName|
    |tables_autovacuumed |Count|Maximum |**Tables AutoVacuumed** (Preview) |Number of tables that have been vacuumed by the autovacuum daemon in this database |DatabaseName|
    |tables_autovacuumed_user_tables|Count|Maximum |**User Tables AutoVacuumed** (Preview) |Number of user only tables that have been vacuumed by the autovacuum daemon in this database |DatabaseName|
    |tables_analyzed |Count|Maximum |**Tables Analyzed** (Preview) |Number of tables that have been analyzed in this database |DatabaseName|
    |tables_analyzed_user_tables |Count|Maximum |**User Tables Analyzed** (Preview) |Number of user only tables that have been analyzed in this database |DatabaseName|
    |tables_autoanalyzed |Count|Maximum |**Tables AutoAnalyzed** (Preview) |Number of tables that have been analyzed by the autovacuum daemon in this database |DatabaseName|
    |tables_autoanalyzed_user_tables|Count|Maximum |**User Tables AutoAnalyzed** (Preview) |Number of user only tables that have been analyzed by the autovacuum daemon in this database |DatabaseName|

    ## References

  29. varun-dhawan revised this gist Jan 6, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -37,7 +37,7 @@ Autovacuum is a daemon or background utility process offered by PostgreSQL to us
    |tables_counter_user_tables |Count|Maximum |**User Tables Counter** (Preview) |Number of user only tables in this database |DatabaseName|Autovacuum (Preview)|
    |tables_vacuumed |Count|Maximum |**Tables Vacuumed** (Preview) |Number of tables that have been vacuumed in this database |DatabaseName|Autovacuum (Preview)|
    |tables_vacuumed_user_tables |Count|Maximum |**User Tables Vacuumed** (Preview) |Number of user only tables that have been vacuumed in this database |DatabaseName|Autovacuum (Preview)|
    |tables_autovacuumed |Count|Maximum |**Tables AutoVacuumed (Preview) |Number of tables that have been vacuumed by the autovacuum daemon in this database |DatabaseName|Autovacuum (Preview)|
    |tables_autovacuumed |Count|Maximum |**Tables AutoVacuumed** (Preview) |Number of tables that have been vacuumed by the autovacuum daemon in this database |DatabaseName|Autovacuum (Preview)|
    |tables_autovacuumed_user_tables|Count|Maximum |**User Tables AutoVacuumed** (Preview) |Number of user only tables that have been vacuumed by the autovacuum daemon in this database |DatabaseName|Autovacuum (Preview)|
    |tables_analyzed |Count|Maximum |**Tables Analyzed** (Preview) |Number of tables that have been analyzed in this database |DatabaseName|Autovacuum (Preview)|
    |tables_analyzed_user_tables |Count|Maximum |**User Tables Analyzed** (Preview) |Number of user only tables that have been analyzed in this database |DatabaseName|Autovacuum (Preview)|
  30. varun-dhawan revised this gist Jan 6, 2023. 1 changed file with 3 additions and 0 deletions.
    3 changes: 3 additions & 0 deletions AutoVacuumMonitoring.md
    View file
    Original file line number Diff line number Diff line change
    @@ -44,6 +44,9 @@ Autovacuum is a daemon or background utility process offered by PostgreSQL to us
    |tables_autoanalyzed |Count|Maximum |**Tables AutoAnalyzed** (Preview) |Number of tables that have been analyzed by the autovacuum daemon in this database |DatabaseName|Autovacuum (Preview)|
    |tables_autoanalyzed_user_tables|Count|Maximum |**User Tables AutoAnalyzed** (Preview) |Number of user only tables that have been analyzed by the autovacuum daemon in this database |DatabaseName|Autovacuum (Preview)|

    ## References

    Postgres Vacuuming Basics - https://www.postgresql.org/docs/current/routine-vacuuming.html

    ## Team
    * Engineering - [email protected]