| 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, in the output of sql-explain when the BUFFERS option is used, by autovacuum for auto-vacuums and auto-analyzes, when log_autovacuum_min_duration is set and by pgstatstatements. Only superusers can change this setting.
Recommendations
Turn it on if you're monitoring disk usage per request.
On StackOverflow
- Phrase frequency counter with FULL Text Search of PostgreSQL 9.6
- Postgresql 12 - Simple select statement without filter condition is giving less throughput of 5K rows/sec? What can we optimize here?
- How to set PGOPTIONS when starting Postgres using docker-compose
- Postgres query is very slow for 1 billion rows
- How to activate Postgresql statistics collector?