Type: | bool |
Default: | off |
Context: | superuser |
Restart: | false |
Since: | 9.2 |
Enables timing of database I/O calls. This parameter is off by default, as it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms. You can use the pgtesttiming tool to measure the overhead of timing on your system. I/O timing information is displayed in pg_stat_database, pg_stat_io, in the output of sql-explain when the BUFFERS
option is used, in the output of sql-vacuum when the VERBOSE
option is used, by autovacuum for auto-vacuums and auto-analyzes, when log_autovacuum_min_duration is set and by pgstatstatements. Only superusers and users with the appropriate SET
privilege can change this setting.
Recommendations
Turn it on if you're monitoring disk usage per request.