pg_stat_progress_vacuum.delay_time
Total time spent sleeping due to cost-based delay (see Section 19.10.2), in milliseconds (if track_cost_delay_timing is enabled, otherwise zero). This includes the time that any associated parallel workers have slept. However, parallel workers report their sleep time no more frequently than once per second, so the reported value may be slightly stale.
Reading PG 18·Select a recorded version
- View
- pg_stat_progress_vacuum
- Field
- delay_time
- SQL type
- double precision
- Units named in the field definition
- milliseconds
- Reset observation
- No stats_reset field is documented for this view
- documented
- true
- field
- delay_time
- manual path
- /docs/18/progress-reporting.html
- signature
- SELECT delay_time FROM pg_catalog.pg_stat_progress_vacuum;
- source only
- false
- sql type
- double precision
- units mentioned
- milliseconds
- view
- pg_stat_progress_vacuum
Definition PG 18
Total time spent sleeping due to cost-based delay (see Section 19.10.2), in milliseconds (if track_cost_delay_timing is enabled, otherwise zero). This includes the time that any associated parallel workers have slept. However, parallel workers report their sleep time no more frequently than once per second, so the reported value may be slightly stale.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f