Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,397 questions
PostgreSQL Felxible Server Logs missing
![](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(54.400000000000006, 76%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVC%3C/text%3E%3C/svg%3E)
Vin Centso
0
Reputation points
Hello,
We have an Azure Database for PostgreSQL flexible server, and i turned on all the diagnostics settings, sending them to a Log Analytics workspace.
I modified only a few key Log parameters of the PostgreSQL server
Seemingly out of nowhere, On April 8th, I started to notice a huge reduction in the amount of logs produced. I would say that we have only generated MORE traffic, queries, inserts, updates, deletes ... etc.. The load should be the same or MORE but never less... so its a total mystery to me.
Any ideas?
Azure Database for PostgreSQL
{count} votes
-
![](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(256, 4%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Prasad Chaganti 770 Reputation points Microsoft External Staff Moderator2025-04-22T02:51:55.1+00:00 As I understand, you would like to access the server logs in Azure PostgreSQL
The below screenshot you shared.
Logs: You have enabled the following log categories:
- PostgreSQL Server Logs
- PostgreSQL Session data
- PostgreSQL Query Store Runtime
- PostgreSQL Query Store Wait Statistics
- PostgreSQL Connections
Destination: Logs and metrics are being sent to a Log Analytics workspace under the subscription "Microsoft Azure Sponsorship".
Please follow the below steps:
Once this is configured, the logs will flow to Azure Log Analytics workspace and we can run below query to get them.
Once this is configured, the logs will flow to Azure Log Analytics workspace and we can run below query to get them.
AzureDiagnostics | where Category == "PostgreSQLLogs"Referenced Article: https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-configure-and-access-logs
It usually takes some time for logs to get ingested. Can you please try it after 30 mins or 1 hour for the first time.
waited for around 30 minutes and can see all the logs as shown in below picture
I hope this information helps. Please do let us know if you have any further queries.
-
Vin Centso 0 Reputation points
2025-04-22T23:28:23.37+00:00 As I understand, you would like to access the server logs in Azure PostgreSQLHi Prasad Chaganti
No, I know how to access the logs. my questions is, why did the logs dramatically get reduced as you can see in the screenshot.
-
Prasad Chaganti 770 Reputation points Microsoft External Staff Moderator
2025-04-23T03:33:19.3266667+00:00 I kindly request you to provide the details mentioned in the private message so we can identify the root cause and address the issue effectively.
-
Prasad Chaganti 770 Reputation points Microsoft External Staff Moderator
2025-04-24T06:53:15.3533333+00:00 We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
-
Prasad Chaganti 770 Reputation points Microsoft External Staff Moderator
2025-04-25T05:46:22.6466667+00:00 We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution,
please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
-
Vin Centso 0 Reputation points
2025-04-26T14:21:32.2466667+00:00 I kindly request you to provide the details mentioned in the private message so we can identify the root cause and address the issue effectively.Im not sure i follow you. i dont believe i have any kind of private message.
where do i find "private messages" in this forum? -
Prasad Chaganti 770 Reputation points Microsoft External Staff Moderator
2025-04-28T01:52:04.3733333+00:00 -
Vin Centso 0 Reputation points
2025-04-29T00:16:32.74+00:00 thanks i responded in the priv msg
-
Prasad Chaganti 770 Reputation points Microsoft External Staff Moderator
2025-04-29T01:41:01.2666667+00:00 Hi Vin Centso,
Thank you for your response.
We are reaching out to the internal team to get more information related to your query and will get back to you as soon as we have an update. -
Prasad Chaganti 770 Reputation points Microsoft External Staff Moderator
2025-05-06T16:35:21.7833333+00:00 Hi Vin Centso,
Validated from the server side, there is no issue. Need to understand what all conf has changes.it seems the issue is happening after that only. will get more information from internal team and will get back to you as soon as we have an update.
-
Prasad Chaganti 770 Reputation points Microsoft External Staff Moderator
2025-05-08T19:38:13.1166667+00:00 Hi Vin Centso,
Sorry for the delay to answer your Query, our internal team is working on it as priority. It seems there is a fleet wide issue for burstable sku server. The investigation is in progress
Thank for your understanding. -
![](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(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SSingh-MSFT 16,281 Reputation points Moderator2025-05-15T10:04:33.19+00:00 Thanks for your patience.
I have checked internally for some servers there is a known issue with delay in logs.
Team is working on it, we will update you once the issue is solved.
Sorry about the inconvenience.
-
SSingh-MSFT 16,281 Reputation points Moderator
2025-06-04T03:50:01.1833333+00:00 Thanks for your patience.
Could you please check and let us know if you still facing delay in logs for your server.
Thanks.
Sign in to comment
Sign in to answer