Azure/azure-postgresql

Include bloat queries to health check notebook

SenthuranSivananthan opened this issue 5 years ago · 1 comments

SenthuranSivananthan commented 5 years ago

Will it be possible to include the queries from https://github.com/pgexperts/pgx_scripts/tree/master/bloat to the notebook?

rachel-msft commented 5 years ago

Hi Senthuran. The notebook here https://github.com/Azure/azure-postgresql/blob/master/samples/Health%20Checks/Postgres_database_health_check_notebook.ipynb is an example of what anyone can go create for themselves in Azure Data Studio. This notebook is based on the health check blog: https://www.citusdata.com/blog/2019/03/29/health-checks-for-your-postgres-database/ and so those are the queries it has.
You can use Azure Data Studio to create your own notebook with the queries (eg. bloat) that are important to you.