NEW: Paste your query and schema data and we give you the best index. Launch pganalyze Index Advisor

Step 4: Adjust Postgres log_line_prefix

By default Azure uses %t-%c- as the log_line_prefix setting. Whilst we support this setting, we recommend you utilize the following log_line_prefix parameter value instead:

log_line_prefix = '%m [%p] %q[user=%u,db=%d,app=%a] '

You can change this setting in the "Server parameters" section of your database. Please note the trailing space in the parameter value, which is required.

The correct setting for log_line_prefix ensures that the collector can associate each log line to the correct session, database and username.

Continue to Step 5: Configure collector

Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →