Actual Backup Cost and Compression Ratio in Azure Database for PostgreSQL

Hi Azeem, Muhammad
To determine the actual backup cost and understand the backup compression ratio in Azure PostgreSQL Flexible Server, follow these guidelines:
Checking Actual Backup Storage Consumption and Cost
Azure Portal: Navigate to the Azure Portal.
Go to your PostgreSQL Flexible Server instance.
Under the Monitoring section, look for Metrics.
Check metrics related to Backup Storage and Storage Usage.
Cost Analysis: Use Azure Cost Management to analyze costs associated with your PostgreSQL server. Filter by resource and look for backup-related expenditures.
Compression Ratio of Backups
Azure Documentation: The Azure Database for PostgreSQL uses a built-in backup compression mechanism, but exact compression ratios may not be exposed in the portal.
Monitoring Compression: Currently, there's no direct metric available in the Azure Portal that shows the compression ratio However, you can:Estimate compression by monitoring backup size over time compared to total data size.
Backup Storage Details:In the Backup section of your server settings, you can see backup-related storage info.
Built-in Tools and Metrics for Backup Insights
**Logs and Metrics:**Utilize the Azure Monitor to set up alerts and track resource metrics.
Inspect logs for backup operations that may provide insights into backup sizes.
Azure CLI or PowerShell:Use Azure CLI or PowerShell scripts to query for backup sizes and assess changes.

az postgres flexible-server show --name <your-server-name> --resource-group <your-resource-group>

For more detailed information and examples, you can refer to the following resources:

• Backup and restore - Azure Database for PostgreSQL - Flexible Server
• Pricing - Azure Database for PostgreSQL Flexible Server
• Configure backup for Azure Database for PostgreSQL - Flexible Server

By following these steps, you can effectively monitor and manage the backup storage consumption and costs for your Azure PostgreSQL Flexible server. If you have any further questions or need additional assistance, feel free to ask! Thank you