Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,314 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?
{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 415 Reputation points Microsoft External Staff2025-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 415 Reputation points Microsoft External Staff
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 415 Reputation points Microsoft External Staff
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 415 Reputation points Microsoft External Staff
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 415 Reputation points Microsoft External Staff
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 415 Reputation points Microsoft External Staff
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.
Sign in to comment
Sign in to answer