Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,010 questions
Azure Database for PostgreSQL flexible server Sudden Big Drop of Memory Percent
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 45%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHB%3C/text%3E%3C/svg%3E)
Hashem Bulbul
0
Reputation points
I have a hosted pgsql database and 2 days ago the performance dropped significantly.
I checked query insights but nothing signficant there.
When checking Memory and CPU percent i noticed that around the time the issue started, memory usage dropped from 40% to as low as 12%
Also read/write throughput dropped spiked during the same time the issue started
What could be done in to diagnose/track the cause of the issue (apart from checking queries insights)?
{count} votes
-
GeethaThatipatri-MSFT 29,377 Reputation points Microsoft Employee2024-02-28T14:09:20.9233333+00:00 @Hashem Bulbul Welcome to Microsoft Q&A thanks for posting your question.
Please check if there are any long running queries, You can find more information on how to diagnose and troubleshoot performance issues https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-troubleshooting-guides
Regards
Geetha
Sign in to comment
Sign in to answer