| author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|
AlicjaKucharczyk |
alkuchar |
maghan |
06/18/2024 |
postgresql |
flexible-server |
include |
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Sets the application name to be reported in statistics and logs. |
| Data type | string |
| Default value | |
| Allowed values | [A-Za-z0-9._-]* |
| Parameter type | dynamic |
| Documentation | application_name |
[!INCLUDE server-parameters-azure-notes-void]
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Indents parse and plan tree displays. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | debug_pretty_print |
[!INCLUDE server-parameters-azure-notes-void]
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Logs each query's parse tree. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | debug_print_parse |
[!INCLUDE server-parameters-azure-notes-void]
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Logs each query's execution plan. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | debug_print_plan |
[!INCLUDE server-parameters-azure-notes-void]
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Logs each query's rewritten parse tree. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | debug_print_rewritten |
[!INCLUDE server-parameters-azure-notes-void]
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Sets the minimum execution time above which autovacuum actions will be logged. |
| Data type | integer |
| Default value | -1 |
| Allowed values | -1-2147483647 |
| Parameter type | dynamic |
| Documentation | log_autovacuum_min_duration |
[!INCLUDE server-parameters-azure-notes-void]
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Logs each checkpoint. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | log_checkpoints |
[!INCLUDE server-parameters-azure-notes-void]
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Causes each attempted connection to the server to be logged, as well as successful completion of client authentication. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | log_connections |
[!INCLUDE server-parameters-azure-notes-void]
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Logs end of a session, including duration. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | log_disconnections |
[!INCLUDE server-parameters-azure-notes-void]
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Logs the duration of each completed SQL statement. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | log_duration |
[!INCLUDE server-parameters-azure-notes-void]
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Controls the amount of detail written in the server log for each message that is logged. |
| Data type | enumeration |
| Default value | default |
| Allowed values | terse,default,verbose |
| Parameter type | dynamic |
| Documentation | log_error_verbosity |
[!INCLUDE server-parameters-azure-notes-void]
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Logs the host name in the connection logs. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | log_hostname |
[!INCLUDE server-parameters-azure-notes-void]
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Sets the printf-style string that is output at the beginning of each log line. |
| Data type | string |
| Default value | %t-%c- |
| Allowed values | [^']* |
| Parameter type | dynamic |
| Documentation | log_line_prefix |
[!INCLUDE server-parameters-azure-notes-void]
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Controls whether a log message is produced when a session waits longer than deadlock_timeout to acquire a lock. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | log_lock_waits |
[!INCLUDE server-parameters-azure-notes-void]
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Logs each replication command. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | log_replication_commands |
[!INCLUDE server-parameters-azure-notes-void]
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Sets the type of statements logged. |
| Data type | enumeration |
| Default value | none |
| Allowed values | none,ddl,mod,all |
| Parameter type | dynamic |
| Documentation | log_statement |
[!INCLUDE server-parameters-azure-notes-void]
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Logs the use of temporary files larger than this number of kilobytes. |
| Data type | integer |
| Default value | -1 |
| Allowed values | -1-2147483647 |
| Parameter type | dynamic |
| Documentation | log_temp_files |
[!INCLUDE server-parameters-azure-notes-void]
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Sets the time zone to use in log messages. |
| Data type | string |
| Default value | UTC |
| Allowed values | UTC |
| Parameter type | read-only |
| Documentation | log_timezone |
[!INCLUDE server-parameters-azure-notes-void]