| 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
- How to set PGOPTIONS when starting Postgres using docker-compose
- Postgresql 12 - Simple select statement without filter condition is giving less throughput of 5K rows/sec? What can we optimize here?
- Postgres query is very slow for 1 billion rows
- How to activate Postgresql statistics collector?
On pgsql-hackers
- Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
- Re: log_autovacuum in Postgres 14 -- ordering issue
- Re: Unifying VACUUM VERBOSE and log_autovacuum_min_duration output
- Re: Asynchronous and "direct" IO support for PostgreSQL.
- RE: track_io_timing default setting