Wiki / Configuration Parameters

Enables timing of cost-based vacuum delay (see Section 19.10.2). 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 pg_test_timing tool to measure the overhead of timing on your system. Cost-based vacuum delay timing information is displayed in pg_stat_progress_vacuum, pg_stat_progress_analyze, in the output of VACUUM and ANALYZE when the VERBOSE option is used, and by autovacuum for auto-vacuums and auto-analyzes when log_autovacuum_min_duration is set. Only superusers and users with the appropriate SET privilege can change this setting.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

boot val

off

category

Statistics / Cumulative Query and Index Statistics

context

superuser

documented

true

enumvals

Unknown

extra desc

Unknown

lang

en

max val

Unknown

metadata version

18

min val

Unknown

name

track_cost_delay_timing

short desc

Collects timing statistics for cost-based vacuum delay.

source

pg-settings-source-snapshot

unit

Unknown

vartype

bool