| title | description | services | author | ms.author | manager | editor | ms.service | ms.topic | ms.date |
|---|---|---|---|---|---|---|---|---|---|
Server Logs in Azure Database for PostgreSQL |
This article describes how Azure Database for PostgreSQL generates query and error logs, and how log retention is configured. |
postgresql |
rachel-msft |
raagyema |
kfile |
jasonwhowell |
postgresql |
article |
02/28/2018 |
Azure Database for PostgreSQL generates query and error logs. However, access to transaction logs is not supported. Query and error logs can be used to identify, troubleshoot, and repair configuration errors and suboptimal performance. For more information, see Error Reporting and Logging.
You can list and download Azure PostgreSQL server error logs using the Azure portal, Azure CLI, and Azure REST APIs.
You can set the retention period for system logs using the log_retention_period parameter associated with your server. The unit for this parameter is days. The default value is 3 days. The maximum value is 7 days. Your server must have enough allocated storage to contain the retained log files. The log files rotate every one hour or 100 MB size, whichever comes first.
You can enable query logging and error logging for your server. Error logs can contain auto-vacuum, connection, and checkpoints information.
You can enable query logging for your PostgreSQL DB instance by setting two server parameters: log_statement and log_min_duration_statement.
The log_statement parameter controls which SQL statements are logged. We recommend setting this parameter to all to log all statements; the default value is none.
The log_min_duration_statement parameter sets the limit in milliseconds of a statement to be logged. All SQL statements that run longer than the parameter setting are logged. This parameter is disabled and set to minus 1 (-1) by default. Enabling this parameter can be helpful in tracking down unoptimized queries in your applications.
The log_min_messages allows you to control which message levels are written to the server log. The default is WARNING.
For more information on these settings, see Error Reporting and Logging documentation. For particularly configuring Azure Database for PostgreSQL server parameters, see Customize server configuration parameters using Azure CLI.
- To access logs using Azure CLI command-line interface, see Configure and access server logs using Azure CLI.
- For more information on server parameters, see Customize server configuration parameters using Azure CLI.