Missing all data in Monitoring Metrics for Azure Database for PostgreSQL - Flexible Server

Greg Polanco 0 Reputation points
2025-01-02T20:15:35.4833333+00:00

Firstly,

I have followed the instructions found in the following threads and nothing works:

1- https://zcusa.951200.xyz/en-us/answers/questions/2134061/azure-database-for-postgresql-metric-storage-perce

2- https://zcusa.951200.xyz/en-us/answers/questions/1817869/in-pass-few-days-all-the-metrics-of-azure-database

3- https://zcusa.951200.xyz/en-us/azure/azure-monitor/essentials/metrics-troubleshoot

Long story short: I have an Azure Database for PostgreSQL flexible Server and want to monitor the Metric "Storage Percent". When I configure the According Graph, it remains empty as you can see:

User's image

I have checked and validate that I have the right permissions, I have tried to reboot the server, only monitor 24 hours, check other stats to monitor, do exactly the same in others Azure Database for PostgreSQL flexible Server, check Microsoft.Insights resource provider is registered for my subscription, play around the time range (min 24 hours and max 29 days)

Interesting enough, I have 4 different instances of Azure Database for PostgreSQL - Flexible Server, all of them having at least from the metrics perspective the default values, and only 2 out of 4 displays correctly the Metrics Stats, the other 2 just shows empty.

Would love some support from you.

Azure Database for PostgreSQL
{count} votes

2 answers

Sort by: Most helpful
  1. Greg Polanco 0 Reputation points
    2025-01-09T16:43:27.4+00:00

    For anyone with this issue:

    I created again a whole new PostgreSQL - Flexible Server and this time it is showing me the metrics that I had issues so basically, I only had to migrate the DBs to this new instance. I don't know if this had something to do on how the PostgreSQL-Flexible Server instance was created or what was the issue because I did not do anything different when I was creating the second one.

    Moderators, you may close this.

    0 comments No comments

  2. Mahesh Kurva 1,700 Reputation points Microsoft Vendor
    2025-01-13T16:36:47.9+00:00

    Hi @Greg Polanco,

    I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer.

    Issue:

    I have an Azure Database for PostgreSQL flexible Server and want to monitor the Metric "Storage Percent".

    I have checked and validate that I have the right permissions, I have tried to reboot the server, only monitor 24 hours, check other stats to monitor, do exactly the same in others Azure Database for PostgreSQL flexible Server, check Microsoft.Insights resource provider is registered for my subscription, play around the time range (min 24 hours and max 29 days)

    Interesting enough, I have 4 different instances of Azure Database for PostgreSQL - Flexible Server, all of them having at least from the metrics perspective the default values, and only 2 out of 4 displays correctly the Metrics Stats, the other 2 just shows empty.

    Solution:

    I created again a whole new PostgreSQL - Flexible Server and this time it is showing me the metrics that I had issues so basically, I only had to migrate the DBs to this new instance. I don't know if this had something to do on how the PostgreSQL-Flexible Server instance was created or what was the issue because I did not do anything different when I was creating the second one.

    If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.

    Hope this helps. Do let us know if you have any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.