Hi Tripesh Dhoriya,
I see you're facing an issue with your PostgreSQL Flexible Server where metrics stopped collecting after January 1, 2026. That sounds concerning, especially since this is affecting your production environment.
Based on what you’ve shared, since you’ve already tried recreating diagnostic settings, verifying Microsoft.Insights registration, and checked Azure Monitor without detecting any data post-January 1, this indeed appears to be a platform-level issue. Below are some troubleshooting steps and considerations that may help:
Check the Server Configuration: Ensure that the server parameters for metrics collection are set correctly. For example, the parameter metrics.collector_database_activity should be set to ON to ensure database activity metrics are collected. If this is not the case, it can result in a lack of metrics.
Verify Diagnostic Settings: While you've recreated the diagnostic settings, ensure that all necessary diagnostics are enabled that pertain to metrics for your PostgreSQL Flexible Server.
Resource Health and Status: Monitor the resource health of your server in the Azure portal to check if it reports any degradation or maintenance activities that might impact metrics collection.
- Review Azure Monitor Logs: Confirm that you are querying within the 30-day range limit in Azure Monitor. Sometimes, charts may display blank if the date range exceeds this limit.
To help you further, could you please clarify a few things:
- Can you confirm if the parameter for metrics collection is enabled (
metrics.collector_database_activity)?
- Have you encountered any alerts or notifications in the Azure portal regarding your server or its metrics collection?
- Are there any resource health issues that you've seen in the Azure portal for your PostgreSQL Flexible Server?
Hope this helps, and let me know if you need any further assistance!
References