log_duration
A configuration parameter determining whether to log duration of statements
log_duration is a configuration parameter determining whether to log the duration of each statement executed.
log_duration was added in PostgreSQL 7.2.
Default value
The default value for log_duration is: off.
Change history
- PostgreSQL 7.2
- added (commit 548d646e)
Examples
If log_duration is set to on, each statement executed will result in a corresponding entry in the log file.
For example, executing:
postgres=# SELECT pg_sleep(1); pg_sleep ---------- (1 row)
will generate an entry like the following:
[2021-11-11 17:10:55 UTC] psql postgres postgres LOG: 00000: duration: 1002.239 ms
References
- PostgreSQL documentation: log_duration
Categories
See also
log_min_duration_statement, log_min_duration_sample, log_min_error_statement