| Type: | bool |
| Default: | off |
| Context: | superuser |
| Restart: | false |
Causes the duration of every completed statement to be logged. The default is off. Only superusers can change this setting.
For clients using extended query protocol, durations of the Parse, Bind, and Execute steps are logged independently.
The difference between enabling log_duration and setting log_min_duration_statement to zero is that exceeding log_min_duration_statement forces the text of the query to be logged, but this option doesn't. Thus, if log_duration is on and log_min_duration_statement has a positive value, all durations are logged but the query text is included only for statements exceeding the threshold. This behavior can be useful for gathering statistics in high-load installations.
Recommendations
Useful for performance analysis.
On StackOverflow
On pgsql-hackers
- Re: Asynchronous and "direct" IO support for PostgreSQL.
- RE: [PATCH] New default role allowing to change per-role/database settings
- Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers)
- Re: [PATCH] New default role allowing to change per-role/database settings