Hubert (depesz) Lubaczewski • 2/13/2025

Waiting for PostgreSQL 18 – Add cost-based vacuum delay time to progress views.

The article details a new feature in PostgreSQL 18 that adds the measurement of time spent sleeping due to cost-based vacuum delays to the pg_stat_progress_vacuum and pg_stat_progress_analyze system views. It explains the new 'track_cost_delay_timing' configuration parameter and includes a practical demonstration with modified settings to show how the delay_time column works in monitoring vacuum operations.

0 comments

#performance monitoring #database #postgresql